Example #1
0
        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);
        }
Example #2
0
        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);
        }