public async Task <ActionResult> Edit(int?courierId) { using (var con = new SqlConnection(_connectionString)) { var folder = "/UploadedImages/Courier/"; var result = con.Query <ManageCourierModel>("SELECT * from Courier_Master WHERE CourierId=@CourierId", new { CourierId = courierId }, commandType: CommandType.Text).FirstOrDefault(); result.UploadedCourierFileUrl = folder + "Logo/" + result.UploadedCourierFile; result.UploadedGSTFileUrl = folder + "Gst/" + result.UploadedGSTFile; result.UserPANCardFileUrl = folder + "PanCards/" + result.UserPANCardFile; result.VoterIDFileUrl = folder + "VoterCards/" + result.VoterIDFile; result.AadhaarCardFileUrl = folder + "AdharCards/" + result.AadhaarCardFile; result.AgreementScanFileUrl = folder + "ScanAgreement/" + result.AgreementScanFile; result.CancelledChequeFileUrl = folder + "CancelledCheques/" + result.CancelledChequeFile; if (result != null) { result.Country = result.CountryId; result.StateDropdown = result.StateId; result.CityDropdown = result.CityId; result.PinCodeDropdown = result.Pincode; result.SC_CountryDropdown = result.SC_Country; result.PersonCountryDropdown = result.PersonCountry; result.PersonCityDropdown = result.PersonCity; result.PersonStateDropdown = result.PersonState; result.SC_PincodeDropdown = result.SC_Pincode; string volume = result.Volume.ToString(); result.CountryList = new SelectList(dropdown.BindCountry(), "Value", "Text"); result.StateList = new SelectList(dropdown.BindState(), "Value", "Text"); result.CityList = new SelectList(dropdown.BindLocation(), "Value", "Text"); result.PincodeList = new SelectList(dropdown.BindPincodeListByCountry(Convert.ToInt32(result.SC_Country)), "Value", "Text"); result.ApplicableTaxTypeList = new SelectList(await CommonModel.GetApplicationTaxType(), "Value", "Text"); result.PersonAddressTypeList = new SelectList(CommonModel.GetAddressTypes(), "Value", "Text"); result.AWBNumberUsedList = new SelectList(await CommonModel.GetAWBNumberUsedTypes(), "Value", "Text"); result.AgreementSignupList = new SelectList(await CommonModel.GetAgreementSignup(), "Value", "Text"); result.LegalDocumentVerificationList = new SelectList(await CommonModel.GetLegalDocumentVerification(), "Value", "Text"); string[] parts = volume.ToString().Split('-'); result.Volumn1 = parts[0]; result.Volumn2 = parts[1]; string weight = result.WeightRange.ToString(); string[] parts1 = weight.ToString().Split('-'); result.WeightRange1 = parts[0]; result.WeightRange2 = parts[1]; result.AgreementEndDate = Convert.ToDateTime(result.AgreementEndDate).ToString("MM-dd-yyyy"); result.AgreementStartDate = Convert.ToDateTime(result.AgreementStartDate).ToString("MM-dd-yyyy"); result.ApplicableFromDate = Convert.ToDateTime(result.ApplicableFromDate).ToString("MM-dd-yyyy"); } return(View(result)); } }
public async Task <ActionResult> Create() { DropdownBindController drop = new DropdownBindController(); ManageCourierModel courierModel = new ManageCourierModel { CountryList = new SelectList(dropdown.BindCountry(), "Value", "Text"), StateList = new SelectList(Enumerable.Empty <SelectListItem>()), CityList = new SelectList(Enumerable.Empty <SelectListItem>()), PincodeList = new SelectList(Enumerable.Empty <SelectListItem>()), ApplicableTaxTypeList = new SelectList(await CommonModel.GetApplicationTaxType(), "Value", "Text"), PersonAddressTypeList = new SelectList(CommonModel.GetAddressTypes(), "Value", "Text"), AWBNumberUsedList = new SelectList(await CommonModel.GetAWBNumberUsedTypes(), "Value", "Text"), AgreementSignupList = new SelectList(await CommonModel.GetAgreementSignup(), "Value", "Text"), LegalDocumentVerificationList = new SelectList(await CommonModel.GetLegalDocumentVerification(), "Value", "Text") }; return(View(courierModel)); }
public async Task <ActionResult> Create(ManageCourierModel model) { try { if (ModelState.IsValid) { using (var con = new SqlConnection(_connectionString)) { string UploadedCourierFile = SaveImageFile(model.UploadedCourierFilePath, "Courier/Logo"); string UploadedGSTFile = SaveImageFile(model.UploadedGSTFilePath, "Courier/Gst"); string PANCardFile = SaveImageFile(model.PANCardFilePath, "Courier/PanCards"); string UserPANCardFile = SaveImageFile(model.UserPANCardFilePath, "Courier/Pancards"); string VoterIDFile = SaveImageFile(model.VoterIDFilePath, "Courier/VoterCards"); string AadhaarCardFile = SaveImageFile(model.AadhaarCardFilePath, "Courier/AdharCards"); string AgreementScanFile = SaveImageFile(model.AgreementScanFilePath, "Courier/ScanAgreement"); string CancelledChequeFile = SaveImageFile(model.CancelledChequeFilePath, "Courier/CancelledCheques"); var result = con.Query <int>("Add_Modify_Delete_Courier", new { //Settings model.CourierId, model.CourierName, model.CourierCode, model.CourierBrandName, model.Priority, model.CourierTAT, model.AWBNumber, //CountryId = model.Country, //StateId = model.StateDropdown, // CityId = model.CityDropdown, model.CountryId, model.StateId, model.CityId, UploadedCourierFile, model.IsReverse, model.IsAllowPreference, //Organisation model.CourierCompanyName, model.OrganizationCode, model.StatutoryType, model.ApplicableTaxType, model.GSTNumber, UploadedGSTFile, model.PANCardNumber, PANCardFile, model.BikeMakeandModel, model.BikeNumber, //Address and Contact Person model.PersonAddresstype, PersonCountry = model.PersonCountryDropdown, PersonState = model.PersonStateDropdown, PersonCity = model.PersonCityDropdown, model.FullAddress, model.Locality, model.NearByLocation, model.Pincode, model.FirstName, model.LastName, model.MobileNumber, model.EmailAddress, model.UserPANCard, UserPANCardFile, model.VoterIDCardNo, VoterIDFile, model.AadhaarCardNo, AadhaarCardFile, model.IsUser, //Service Charge SC_Country = model.SC_CountryDropdown, SC_Pincode = model.SC_PincodeDropdown, model.Currency, model.ServiceChargeType, model.ValueRange, WeightRange = model.WeightRange1 + "-" + model.WeightRange2, Volume = model.Volumn1 + "-" + model.Volumn2, model.ServiceCharge, model.ApplicableFromDate, model.ItemType, //Agreement model.LegalDocumentVerificationStatus, model.AgreementSignupStatus, model.AgreementStartDate, model.AgreementEndDate, model.AgreementNumber, AgreementScanFile, //Bank Details model.BankName, model.BankAccountNumber, model.CompanyNameatBank, model.IFSCCode, model.BankBranch, CancelledChequeFile, model.PaymentCycle, //Registration model.LuluandSky_Status, model.Comments, model.IsActive, User = CurrentUser.UserId, CurrentUser.CompanyId, Action = "I", }, commandType: CommandType.StoredProcedure).FirstOrDefault(); var response = new ResponseModel(); if (result == 1) { response.IsSuccess = true; response.Response = "New Courier Successfully Added "; TempData["response"] = response; } else { response.IsSuccess = true; response.Response = "Courier Already Exist "; TempData["response"] = response; } } //return View(model); return(RedirectToAction("ManageCourier")); } else { model.CountryList = new SelectList(dropdown.BindCountry(), "Value", "Text"); model.StateList = new SelectList(Enumerable.Empty <SelectListItem>()); model.CityList = new SelectList(Enumerable.Empty <SelectListItem>()); model.PincodeList = new SelectList(Enumerable.Empty <SelectListItem>()); model.ApplicableTaxTypeList = new SelectList(await CommonModel.GetApplicationTaxType(), "Value", "Text"); model.PersonAddressTypeList = new SelectList(CommonModel.GetAddressTypes(), "Value", "Text"); model.AWBNumberUsedList = new SelectList(await CommonModel.GetAWBNumberUsedTypes(), "Value", "Text"); model.AgreementSignupList = new SelectList(await CommonModel.GetAgreementSignup(), "Value", "Text"); model.LegalDocumentVerificationList = new SelectList(await CommonModel.GetLegalDocumentVerification(), "Value", "Text"); return(View(model)); } } catch (Exception e) { model.CountryList = new SelectList(dropdown.BindCountry(), "Value", "Text"); model.StateList = new SelectList(Enumerable.Empty <SelectListItem>()); model.CityList = new SelectList(Enumerable.Empty <SelectListItem>()); model.PincodeList = new SelectList(Enumerable.Empty <SelectListItem>()); model.ApplicableTaxTypeList = new SelectList(await CommonModel.GetApplicationTaxType(), "Value", "Text"); model.PersonAddressTypeList = new SelectList(CommonModel.GetAddressTypes(), "Value", "Text"); model.AWBNumberUsedList = new SelectList(await CommonModel.GetAWBNumberUsedTypes(), "Value", "Text"); model.AgreementSignupList = new SelectList(await CommonModel.GetAgreementSignup(), "Value", "Text"); model.LegalDocumentVerificationList = new SelectList(await CommonModel.GetLegalDocumentVerification(), "Value", "Text"); return(View(model)); } }