Hi Engineers,
i have webform application where all values are inserted through different store dprocedures and multiple paramters
SqlCommand cmd = new SqlCommand("Proc_insert_Offer_letter", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@company", SqlDbType.VarChar, 200).Value = ddlcompany.SelectedItem.Text;
cmd.Parameters.Add("@verti", SqlDbType.VarChar, 50).Value = vert;
cmd.Parameters.Add("@subverti", SqlDbType.VarChar, 50).Value = sverti;
cmd.Parameters.Add("@offerdate", SqlDbType.DateTime).Value = DateTime.Parse(txtofferdate.Text);
cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = name;
cmd.Parameters.Add("@addr1", SqlDbType.VarChar, 50).Value = txtaddr1.Text;
cmd.Parameters.Add("@addr2", SqlDbType.VarChar, 50).Value = txtaddr2.Text;
cmd.Parameters.Add("@addr3", SqlDbType.VarChar, 50).Value = txtaddr3.Text;
cmd.Parameters.Add("@pin", SqlDbType.VarChar, 50).Value = txtpin.Text;
cmd.Parameters.Add("@mob", SqlDbType.VarChar, 50).Value = txtmob.Text;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = txtemail.Text;
cmd.Parameters.Add("@desig", SqlDbType.VarChar, 50).Value = desig;
cmd.Parameters.Add("@grade", SqlDbType.VarChar, 50).Value = grade;
cmd.Parameters.Add("@loc", SqlDbType.VarChar, 50).Value = loc;
cmd.Parameters.Add("@ctc", SqlDbType.VarChar, 50).Value = txtctc.Text;
cmd.Parameters.Add("@joindate", SqlDbType.DateTime).Value = DateTime.Parse(txtdoj.Text);
cmd.Parameters.Add("@reporting", SqlDbType.VarChar, 50).Value = reporting;
and many more.
after submiting all values is going to show in multiple tables.
can i use viewmodel to create ?

Sachin SinghPosted Jan 13, 2023, 7:44 AM
No doubt, You must need to create ViewModel if your form consists of properties from different-different classes.
Rajeev KumarPosted Mar 2, 2023, 12:10 PM
Yes, You use viewmodel.It is best approach for Converting.
Vishal YelvePosted Jan 13, 2023, 8:34 AM
Yes, viewmodel is best approach
Pasang TamangPosted Jan 13, 2023, 7:43 AM
Hi,
Viewmodel is the best approach to use. You can check this article https://www.c-sharpcorner.com/UploadFile/ff2f08/multiple-models-in-single-view-in-mvc/. This explains how to use multiple viewmodels in a single view with multiple viewmodels.
Regards,
Pasang