private void InsertData(DataTable dt) { int UpdateCount = 0, InsertCount = 0; try { var lstInsertSA = new List <ServiceAvailability>(); var lstUpdateSA = new List <ServiceAvailability>(); var lstDeleteSA = new List <ServiceAvailability>(); int CourierId = ddlCourierExcel.zToInt().Value; int CountryId = CU.GetCountryId("India"); bool IsValidate = false; DataTable dtServiceAvailibility = new Query() { CourierId = CourierId, eStatusNot = (int)eStatus.Delete }.Select(eSP.qry_ServiceAvailability); for (int i = 0; i < dt.Rows.Count; i++) { #region Value Initialization PincodeCol = dt.Rows[i][PincodeColNo].ToString().Trim().TrimEnd(','); CityCol = dt.Rows[i][CityColNo].ToString().Trim().TrimEnd(','); StateCol = dt.Rows[i][StateColNo].ToString().Trim().TrimEnd(','); PrepaidCol = dt.Rows[i][PrepaidColNo].ToString().Trim().TrimEnd(',').ToLower(); CODCol = dt.Rows[i][CODColNo].ToString().Trim().TrimEnd(',').ToLower(); ReversePickupCol = dt.Rows[i][ReversePickupColNo].ToString().Trim().TrimEnd(',').ToLower(); PickupCol = dt.Rows[i][PickupColNo].ToString().Trim().TrimEnd(',').ToLower(); #endregion int StateId = CU.GetStateId(CountryId, StateCol); int CityId = CU.GetCityId(StateId, CityCol); var drServiceAvailibility = dtServiceAvailibility.Select(CS.Pincode + " = '" + PincodeCol + "'"); var objServiceAvailability = new ServiceAvailability() { ServiceAvailabilityId = drServiceAvailibility.Length > 0 ? drServiceAvailibility[0][CS.ServiceAvailabilityId].zToInt() : (int?)null, CourierId = CourierId, Pincode = PincodeCol, CityId = CityId, ePrepaid = (int)GeteYesNo(PrepaidCol, ref IsValidate), eCOD = (int)GeteYesNo(CODCol, ref IsValidate), eReversePickup = (int)GeteYesNo(ReversePickupCol, ref IsValidate), ePickup = (int)GeteYesNo(PickupCol, ref IsValidate), }; if (objServiceAvailability.ServiceAvailabilityId.HasValue) { lstUpdateSA.Add(objServiceAvailability); if (lstUpdateSA.Count >= 250) { lstUpdateSA.Update(); lstUpdateSA = new List <ServiceAvailability>(); } UpdateCount++; } else { objServiceAvailability.eStatus = (int)eStatus.Active; lstInsertSA.Add(objServiceAvailability); if (lstInsertSA.Count >= 250) { lstInsertSA.Insert(); lstInsertSA = new List <ServiceAvailability>(); } InsertCount++; } } foreach (DataRow dr in dtServiceAvailibility.Rows) { lstDeleteSA.Add(new ServiceAvailability() { ServiceAvailabilityId = dr[CS.ServiceAvailabilityId].zToInt() }); if (lstDeleteSA.Count >= 250) { lstDeleteSA.Delete(); lstDeleteSA = new List <ServiceAvailability>(); } } lstUpdateSA.Update(); lstInsertSA.Insert(); lstDeleteSA.Delete(); CU.SetSuccessExcelMessage(InsertCount, UpdateCount, "Service"); } catch (Exception ex) { CU.ZMessage(eMsgType.Error, string.Empty, ex.Message, 0); } LoadServiceGrid(ePageIndex.Custom); }
public int SaveAddress(int?AddressId) { bool LoadMap = IsLoadMap(); var objAddress = new Address() { Address1 = RemoveLastComma(txtAddress1.Text).zFirstCharToUpper(), Address2 = RemoveLastComma(txtAddress2.Text).zFirstCharToUpper(), Pincode = LoadMap ? txtPincodeMap.Text : txtPincode.Text, Latitude = txtLatitude.Text, Longitude = txtLongitude.Text, }; if (LoadMap) { objAddress.CountryId = CU.GetCountryId(txtCountryMap.Text); objAddress.StateId = CU.GetStateId(objAddress.CountryId, txtStateMap.Text); objAddress.CityId = CU.GetCityId(objAddress.StateId, txtCityMap.Text); objAddress.AreaId = CU.GetAreaId(objAddress.CityId, txtAreaMap.Text, objAddress.Pincode); } else { #region Set Country Value if (chkCountry.Checked) { objAddress.CountryId = CU.GetCountryId(txtOtherCountry.Text); } else { objAddress.CountryId = ddlCountry.zToInt(); } #endregion Set Country Value #region Set State Value if (chkState.Checked) { objAddress.StateId = CU.GetStateId(objAddress.CountryId, txtOtherState.Text); } else { objAddress.StateId = ddlState.zToInt(); } #endregion Set State Value #region Set City Value if (chkCity.Checked) { objAddress.CityId = CU.GetCityId(objAddress.StateId, txtOtherCity.Text); } else { objAddress.CityId = ddlCity.zToInt(); } #endregion Set City Value #region Set Area Value if (chkArea.Checked) { objAddress.AreaId = CU.GetAreaId(objAddress.CityId, txtOtherArea.Text, txtPincode.Text); } else { objAddress.AreaId = ddlArea.zToInt(); } #endregion Set Area Value } if (AddressId.HasValue && AddressId != 0) { objAddress.AddressId = AddressId; objAddress.UpdateAsync(); } else { AddressId = objAddress.Insert(); } return(AddressId.Value); }