private void InsertData(DataTable dt)
{
int UpdateCount = 0, InsertCount = 0;
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
#region Value Initialization
CountryName = dt.Rows[i][CountryNameColumn].ToString().Trim();
StateName = dt.Rows[i][StateNameColumn].ToString().Trim();
CityName = dt.Rows[i][CityNameColumn].ToString().Trim();
AreaName = dt.Rows[i][AreaNameColumn].ToString().Trim();
Pincode = dt.Rows[i][PincodeColumn].ToString().Trim();
#endregion
int CountryId = new Country()
{
eStatus = (int)eStatus.Active, CountryName = CountryName.ToLower()
}.SelectList <Country>()[0].CountryId.Value;
int StateId = new State()
{
CountryId = CountryId, StateName = StateName, eStatus = (int)eStatus.Active
}.SelectList <State>()[0].StateId.Value;
int CityId = new City()
{
StateId = StateId, CityName = CityName, eStatus = (int)eStatus.Active
}.SelectList <City>()[0].CityId.Value;
DataTable dtArea = new Query()
{
StateId = StateId,
AreaName = AreaName.zFirstCharToUpper(),
eStatusNot = (int)eStatus.Delete
}.Select(eSP.qry_Area);
var objArea = new Area()
{
AreaId = dtArea.Rows.Count > 0 ? dtArea.Rows[0][CS.AreaId].zToInt() : (int?)null,
CityId = CityId,
AreaName = AreaName.zFirstCharToUpper(),
Pincode = Pincode,
};
if (objArea.AreaId.HasValue)
{
objArea.Update();
UpdateCount++;
}
else
{
objArea.eStatus = (int)eStatus.Active;
objArea.Insert();
InsertCount++;
}
}
CU.SetSuccessExcelMessage(InsertCount, UpdateCount, "Area");
}
catch (Exception ex)
{
CU.ZMessage(eMsgType.Error, string.Empty, ex.Message, 0);
}
LoadAreaGrid(ePageIndex.Custom);
}
