public bool InsertAssignManpower(AddManpowerDTO objSite) { bool res = false; SqlCommand SqlCmd = new SqlCommand("spInsertAllocateManPower"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@ContractId", objSite.ContractId); SqlCmd.Parameters.AddWithValue("@CustomerId", objSite.CustomerId); SqlCmd.Parameters.AddWithValue("@BranchId", objSite.BranchId); SqlCmd.Parameters.AddWithValue("@SiteId", objSite.SiteId); SqlCmd.Parameters.AddWithValue("@ClassificationId", objSite.ClassificationId); SqlCmd.Parameters.AddWithValue("@Service", objSite.ServiceId); SqlCmd.Parameters.AddWithValue("@CreatedBy", objSite.CreatedBy); SqlCmd.Parameters.Add(new SqlParameter("@ManPowerId", SqlDbType.Int)); foreach (var id in objSite.ManPower) { if (SqlCmd.Connection != null) { if (SqlCmd.Connection.State == ConnectionState.Closed) { SqlCmd.Connection.Open(); } } SqlCmd.Parameters["@ManPowerId"].Value = id.ManPowerId; int result = new DbLayer().ExecuteNonQuery(SqlCmd); if (result != Int32.MaxValue) { res = true; } } return(res); }
public HttpResponseMessage CreateManpower(AddManpowerDTO objGetManPower) { HttpResponseMessage message; try { // AssignManpowerDataAccessLayer _manPower = new AssignManpowerDataAccessLayer(); var dynObj = new { result = _manPower.InsertAssignManpower(objGetManPower) }; message = Request.CreateResponse(HttpStatusCode.OK, dynObj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" }); ErrorLog.CreateErrorMessage(ex, "AssignManpower", "CreateManpower"); } return(message); }