public HttpResponseMessage CreateManPower(ManpowerInsertDTO objManPower)
{
HttpResponseMessage message;
try
{
// ManPowerDataAccessLayer dal = new ManPowerDataAccessLayer();
var dynObj = new { result = _obj.InsertManPower(objManPower) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "ManPower", "CreateManPower");
}
return(message);
}
public GetManPowerId InsertManPower(ManpowerInsertDTO objManPower)
{
GetManPowerId objManPowerId = new GetManPowerId();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spInsertManPower");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Name", objManPower.Name);
SqlCmd.Parameters.AddWithValue("@Gender", objManPower.Gender);
SqlCmd.Parameters.AddWithValue("@DateofBirth", objManPower.DateofBirth);
SqlCmd.Parameters.AddWithValue("@Age", objManPower.Age);
SqlCmd.Parameters.AddWithValue("@Mobile", ((objManPower.Mobile == null) ? "" : objManPower.Mobile));
SqlCmd.Parameters.AddWithValue("@AlternateNumber", ((objManPower.AlternateNumber == null) ? "" : objManPower.AlternateNumber));
SqlCmd.Parameters.AddWithValue("@MaritalStatus", objManPower.MaritalStatus);
SqlCmd.Parameters.AddWithValue("@CurrentAddress", ((objManPower.CurrentAddress == null) ? "" : objManPower.CurrentAddress));
SqlCmd.Parameters.AddWithValue("@PermanentAddress", ((objManPower.PermanentAddress == null) ? "" : objManPower.PermanentAddress));
SqlCmd.Parameters.AddWithValue("@Photo", ((objManPower.Photo == null) ? "" : objManPower.Photo));
SqlCmd.Parameters.AddWithValue("@FatherName", objManPower.FatherName);
SqlCmd.Parameters.AddWithValue("@MotherName", objManPower.MotherName);
SqlCmd.Parameters.AddWithValue("@State", objManPower.State);
SqlCmd.Parameters.AddWithValue("@City", objManPower.City);
SqlCmd.Parameters.AddWithValue("@JobType", ((objManPower.JobType == null) ? "" : objManPower.JobType));
SqlCmd.Parameters.AddWithValue("@BloodGroup", ((objManPower.BloodGroup == null) ? "" : objManPower.BloodGroup));
SqlCmd.Parameters.AddWithValue("@Company", objManPower.Company);
SqlCmd.Parameters.AddWithValue("@DateofJoin", objManPower.DateofJoin);
SqlCmd.Parameters.AddWithValue("@Designation", objManPower.Designation);
SqlCmd.Parameters.AddWithValue("@PreviousCompany", ((objManPower.PreviousCompany == null) ? "" : objManPower.PreviousCompany));
SqlCmd.Parameters.AddWithValue("@ReferenceBy", ((objManPower.ReferenceBy == null) ? "" : objManPower.ReferenceBy));
SqlCmd.Parameters.AddWithValue("@ReferenceContact1", ((objManPower.ReferenceContact1 == null) ? "" : objManPower.ReferenceContact1));
SqlCmd.Parameters.AddWithValue("@ReferenceContact2", ((objManPower.ReferenceContact2 == null) ? "" : objManPower.ReferenceContact2));
SqlCmd.Parameters.AddWithValue("@TotalExperience", objManPower.TotalExperience);
SqlCmd.Parameters.AddWithValue("@VerificationStatus", objManPower.VerificationStatus);
SqlCmd.Parameters.AddWithValue("@Payment", objManPower.Payment);
SqlCmd.Parameters.AddWithValue("@CreatedBy", objManPower.CreatedBy);
objManPowerId = dbLayer.GetEntityList <GetManPowerId>(SqlCmd).FirstOrDefault();
}
return(objManPowerId);
}
public HttpResponseMessage CreateManpowerDetils()
{
HttpResponseMessage message;
ManpowerInsertDTO objManpower = new ManpowerInsertDTO();
var VerifyProof = HttpContext.Current.Request.Files[0];
var PhotoName = DateTime.Now.Ticks + "_" + VerifyProof.FileName;
objManpower.Name = HttpContext.Current.Request.Form[0];
objManpower.Gender = HttpContext.Current.Request.Form[1];
var DateofBirth = HttpContext.Current.Request.Form[2];
var Age = HttpContext.Current.Request.Form[3];
objManpower.Mobile = HttpContext.Current.Request.Form[4];
objManpower.AlternateNumber = HttpContext.Current.Request.Form[5];
var MaritalStatus = HttpContext.Current.Request.Form[6];
objManpower.CurrentAddress = HttpContext.Current.Request.Form[7];
objManpower.PermanentAddress = HttpContext.Current.Request.Form[8];
objManpower.Photo = PhotoName;
var State = HttpContext.Current.Request.Form[9];
var City = HttpContext.Current.Request.Form[10];
objManpower.JobType = HttpContext.Current.Request.Form[11];
var Company = HttpContext.Current.Request.Form[12];
var DateofJoin = HttpContext.Current.Request.Form[13];
var Designation = HttpContext.Current.Request.Form[14];
objManpower.ReferenceBy = HttpContext.Current.Request.Form[15];
objManpower.PreviousCompany = HttpContext.Current.Request.Form[16];
objManpower.ReferenceContact1 = HttpContext.Current.Request.Form[17];
objManpower.ReferenceContact2 = HttpContext.Current.Request.Form[18];
objManpower.TotalExperience = HttpContext.Current.Request.Form[19];
var VerificationStatus = HttpContext.Current.Request.Form[20];
objManpower.FatherName = HttpContext.Current.Request.Form[21];
objManpower.MotherName = HttpContext.Current.Request.Form[22];
var Payment = HttpContext.Current.Request.Form[23];
objManpower.CreatedBy = HttpContext.Current.Request.Form[24];
objManpower.DateofBirth = Convert.ToDateTime(DateofBirth);
objManpower.Age = Convert.ToInt16(Age);
objManpower.MaritalStatus = Convert.ToByte(MaritalStatus);
objManpower.State = Convert.ToInt32(State);
objManpower.City = Convert.ToInt32(City);
objManpower.DateofJoin = Convert.ToDateTime(DateofJoin);
objManpower.Company = Convert.ToInt32(Company);
objManpower.Designation = Convert.ToInt32(Designation);
objManpower.VerificationStatus = Convert.ToByte(VerificationStatus);
objManpower.Payment = Convert.ToInt32(Payment);
if (VerifyProof != null && PhotoName != null)
{
var pathf = HttpContext.Current.Server.MapPath("~/PersonalImages");
var fileSavePath = Path.Combine(pathf, PhotoName);
Directory.CreateDirectory(pathf);
VerifyProof.SaveAs(fileSavePath);
}
try
{
// ManPowerDataAccessLayer dal = new ManPowerDataAccessLayer();
var dynObj = new { result = _obj.InsertManPower(objManpower) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "ManPower", "CreateManpowerDetils");
}
return(message);
}
