public HttpResponseMessage CreateManpowerBankDetails() { HttpResponseMessage message; ManpowerBankDetailsInsertDTO objBankDetails = new ManpowerBankDetailsInsertDTO(); var BankDetail = HttpContext.Current.Request.Files[0]; var PassbookFileName = DateTime.Now.Ticks + "_" + BankDetail.FileName; var ManpowerId = HttpContext.Current.Request.Form[0]; var BankId = HttpContext.Current.Request.Form[1]; var AccountType = HttpContext.Current.Request.Form[2]; objBankDetails.AccountNumber = HttpContext.Current.Request.Form[3]; objBankDetails.IFSCCode = HttpContext.Current.Request.Form[4]; objBankDetails.CreatedBy = HttpContext.Current.Request.Form[5]; objBankDetails.PassbookUrl = PassbookFileName; objBankDetails.ManpowerId = Convert.ToInt32(ManpowerId); objBankDetails.BankId = Convert.ToInt32(BankId); objBankDetails.AccountType = Convert.ToInt32(AccountType); if (BankDetail != null && PassbookFileName != null) { var pathf = HttpContext.Current.Server.MapPath("~/PassbookImages"); var fileSavePath = Path.Combine(pathf, PassbookFileName); Directory.CreateDirectory(pathf); BankDetail.SaveAs(fileSavePath); } try { // ManPowerDataAccessLayer dal = new ManPowerDataAccessLayer(); var dynObj = new { result = _obj.InsertManpowerBankDetails(objBankDetails) }; 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 Bank"); } return(message); }
public bool InsertManpowerBankDetails(ManpowerBankDetailsInsertDTO objBankDetails) { bool res = false; SqlCommand SqlCmd = new SqlCommand("[dbo].[spInsertManpowerBankDetails]"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@ManpowerId", objBankDetails.ManpowerId); SqlCmd.Parameters.AddWithValue("@BankId", objBankDetails.BankId); SqlCmd.Parameters.AddWithValue("@AccountType", objBankDetails.AccountType); SqlCmd.Parameters.AddWithValue("@IFSCCode", objBankDetails.IFSCCode); SqlCmd.Parameters.AddWithValue("@AccountNumber", objBankDetails.AccountNumber); SqlCmd.Parameters.AddWithValue("@PassbookUrl", objBankDetails.PassbookUrl); SqlCmd.Parameters.AddWithValue("@CreatedBy", objBankDetails.CreatedBy); int result = _unitOfWork.DbLayer.ExecuteNonQuery(SqlCmd); if (result != Int32.MaxValue) { res = true; } return(res); }