public List <ManpowerInsertDTO> GetManPowerMasterById(GetProofDTO objGetMasterById)
{
List <ManpowerInsertDTO> manPower = new List <ManpowerInsertDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectManPower");
SqlCmd.Parameters.AddWithValue("@ManPowerId", objGetMasterById.ManPowerId);
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetMasterById.ActionBy);
SqlCmd.CommandType = CommandType.StoredProcedure;
manPower = dbLayer.GetEntityList <ManpowerInsertDTO>(SqlCmd);
}
return(manPower);
}
public List <GetManpowerProofDTO> GetVerifyDetail(GetProofDTO objGetVerify)
{
List <GetManpowerProofDTO> verify = new List <GetManpowerProofDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectManPowerProof");
SqlCmd.Parameters.AddWithValue("@ManPowerId", objGetVerify.ManPowerId);
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetVerify.ActionBy);
SqlCmd.CommandType = CommandType.StoredProcedure;
verify = dbLayer.GetEntityList <GetManpowerProofDTO>(SqlCmd);
}
return(verify);
}
public bool RemoveManpower(GetProofDTO objManpower)
{
bool res = false;
SqlCommand sqlcmd = new SqlCommand("spDeleteManPower");
sqlcmd.Parameters.AddWithValue("@ManpowerId", objManpower.ManPowerId);
sqlcmd.Parameters.AddWithValue("@ActionBy", objManpower.ActionBy);
sqlcmd.CommandType = CommandType.StoredProcedure;
int result = _unitOfWork.DbLayer.ExecuteNonQuery(sqlcmd);
if (result != Int32.MaxValue)
{
res = true;
}
return(res);
}
public HttpResponseMessage GetVerifyDetail(GetProofDTO objGetVerify)
{
HttpResponseMessage message;
try
{
// ManPowerDataAccessLayer dal = new ManPowerDataAccessLayer();
var dynObj = new { result = _obj.GetVerifyDetail(objGetVerify) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "ManPower", "GetVerifyDetail");
}
return(message);
}
