public HttpResponseMessage ServiceInsert(MainAddRequest payload) { SuccessResponse response = new SuccessResponse(); // Instantiate MainPayload MainUpdatedAddRequest mainPayload = new MainUpdatedAddRequest(); mainPayload.Name = payload.Name; mainPayload.PostedBy = payload.PostedBy; mainPayload.Description = payload.Description; // Insert Contact Here, Return ContactId mainPayload.contactId = ContactService.ContactInsert(payload.ContactInfo); // Insert Address Here, Return AddressId mainPayload.addressId = AddressService.AddressInsert(payload.AddressInfo); // Insert Hours Here, Return HoursId mainPayload.hoursId = OperationTimeService.OperationTimeInsert(payload.OperationTime); // Insert Tags Here mainPayload.Tags = payload.Tags; // Insert Service Here, Return SuccessResponse MainService.MainInsert(mainPayload); return(Request.CreateResponse(response)); }
public static int MainInsert(MainUpdatedAddRequest payload) { int id = 0; string connString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (SqlConnection sqlConn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand("Service_Insert", sqlConn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", payload.Name); cmd.Parameters.AddWithValue("@PostedBy", payload.PostedBy); cmd.Parameters.AddWithValue("@contactId", payload.contactId); cmd.Parameters.AddWithValue("@addressId", payload.addressId); cmd.Parameters.AddWithValue("@hoursId", payload.hoursId); cmd.Parameters.AddWithValue("@Description", payload.Description); DataTable dt = new DataTable(); DataColumn dc = new DataColumn("ServiceTag", typeof(String)); dt.Columns.Add(dc); for (int i = 0; i < payload.Tags.Count; i++) { var category = payload.Tags[i].Name; DataRow dr = dt.NewRow(); dr[0] = category; dt.Rows.Add(dr); } cmd.Parameters.AddWithValue("@TableParams", dt); SqlParameter param = new SqlParameter(); param.ParameterName = "@ID"; param.SqlDbType = System.Data.SqlDbType.Int; param.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(param); sqlConn.Open(); cmd.ExecuteNonQuery(); id = (int)cmd.Parameters["@ID"].Value; } } return(id); }