public async Task AddAreaMaster(AreaMaster prodData)
{
var maxId = await WithConnection(async c =>
{
return(await c.QueryAsync <int>("SELECT max(AreaIndex) FROM AreaMaster"));
});
//Setting Primary Key
if (maxId.SingleOrDefault() == 0)
{
prodData.AreaIndex = 1;
}
else
{
prodData.AreaIndex = maxId.SingleOrDefault() + 1;
}
//Filling Other Records like User Id, Creation & Update Date
prodData.CreateUserIndex = 1; //Later Logged in User
prodData.UpdateUserIndex = 1; //Later Logged in User
prodData.CreateDateTime = DateTime.Now;
prodData.UpdateDateTime = DateTime.Now;
await WithConnection(async c =>
{
return(await c.QueryAsync <int>(SQLConstants.InsertAreaMaster, prodData));
});
}
public List <AreaMaster> Area_Insert(AreaMaster input)
{
List <AreaMaster> listArea = new List <AreaMaster>();
using (MySqlDataReader reader = ExecuteDataReader("Area_InsertUpdateDelete",
CreateParameter("CityId_", MySqlDbType.Int32, input.CityId),
CreateParameter("ZipCode_", MySqlDbType.VarChar, input.ZipCode),
CreateParameter("Latitude_", MySqlDbType.VarChar, input.Latitude),
CreateParameter("Longitude_", MySqlDbType.VarChar, input.Longitude),
CreateParameter("AreaName_", MySqlDbType.VarChar, input.AreaName),
CreateParameter("Type_", MySqlDbType.Int32, 1)))
{
while (reader.Read())
{
AreaMaster obj = new AreaMaster();
obj.CityId = Convert.ToInt32(reader["CityId"]);
obj.CityName = reader["CityName"].ToString();
//obj.DistrictName = reader["DistrictName"].ToString();
//obj.StateName = reader["StateName"].ToString();
//obj.CountryName = reader["CountryName"].ToString();
obj.AreaId = Convert.ToInt32(reader["AreaId"]);
obj.AreaName = reader["AreaName"].ToString();
obj.ZipCode = reader["ZipCode"].ToString();
obj.Latitude = reader["Latitude"].ToString();
obj.Longitude = reader["Longitude"].ToString();
//obj.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
obj.IsActive = Convert.ToBoolean(reader["IsActive"]);
listArea.Add(obj);
}
}
return(listArea);
}
protected void grdAreaDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
AreaMaster _objAM = new AreaMaster();
try
{
_objAM.AreaID = Convert.ToInt32(((Label)grdAreaDetails.Rows[e.RowIndex].FindControl("lblAreaID")).Text);
_objAM.AreaCode = ((Label)grdAreaDetails.Rows[e.RowIndex].FindControl("lblAreaCode")).Text;
_objAM.AreaName = ((Label)grdAreaDetails.Rows[e.RowIndex].FindControl("lblAreaName")).Text;
//_objAM.AreaZoneID = ((Label)grdAreaDetails.Rows[e.RowIndex].FindControl("lblAreaZoneID")).Text;
_objAM.IsActive = Convert.ToBoolean(false);
_objAM.IsDeleted = Convert.ToBoolean(true);
_objAM.Save();
// MessageBox("Your record is Deleted");
grdAreaDetails.DataSource = BindGvAreaDetail();
grdAreaDetails.DataBind();
pnlAreaDetails.Visible = true;
pnlArea.Visible = false;
}
catch
{
}
}
public async Task Create(Area region)
{
string areaId = Guid.NewGuid().ToString();
region.AreaID = areaId;
region.Points = GooglePoints.Decode(region.EncodedPolygon).Select(x => new LocationPoint(x.Latitude, x.Longitude)).ToList();
region.EncodedPolygon = null;
List <Tile> tiles = this.GetCoordinateTile(region.Points.Select(x => new PointF((float)x.Lat, (float)x.Lng)).ToList(), true).tiles;
AreaMaster areaMaster = new AreaMaster()
{
AreaID = areaId,
AreaName = region.AreaName,
IsPredefine = false,
EncodedPolygon = GooglePoints.EncodeBase64(region.Points.Select(x => new CoordinateEntity(Convert.ToDouble(x.Lat), Convert.ToDouble(x.Lng)))),
EncodedCompletedTiles = GooglePoints.EncodeBase64(tiles.Where(x => !x.IsPartialTile).Select(x => new CoordinateEntity(x.Row, x.Column))),
EncodedPartialTiles = GooglePoints.EncodeBase64(tiles.Where(x => x.IsPartialTile).Select(x => new CoordinateEntity(x.Row, x.Column)))
};
List <Task> tasks = new List <Task>();
tasks.Add(Task.Factory.StartNew(() =>
{
this.context.SaveAsync <AreaMaster>(areaMaster).Wait();
}));
List <Area> areas = this.transformRegion(region, tiles);
SaveAreas(areas);
Task.WaitAll(tasks.ToArray());
}
public Response SaveArea(AreaMaster area, string CRUDAction)
{
AreaDAL objAreaDAL = null;
Response objResponse;
string ErrorCode = "";
try
{
objAreaDAL = new AreaDAL();
//area.CreatedBy = 1;
//area.ModifiedBy = 1;
objAreaDAL.Save(area, CRUDAction, out ErrorCode);
objResponse.ErrorCode = ErrorCode;
objResponse.Description = "";
}
catch (Exception ex)
{
throw;
}
finally
{
objAreaDAL = null;
}
return(objResponse);
}
public List <AreaMaster> Area_RetrieveAll(int cityId)
{
List <AreaMaster> listArea = new List <AreaMaster>();
using (MySqlDataReader reader = ExecuteDataReader("Area_Retrieve",
CreateParameter("AreaId_", MySqlDbType.Int32, -1),
CreateParameter("CityId_", MySqlDbType.Int32, cityId)))
{
while (reader.Read())
{
AreaMaster obj = new AreaMaster();
obj.CityId = Convert.ToInt32(reader["CityId"]);
obj.CityName = reader["CityName"].ToString();
//obj.DistrictName = reader["DistrictName"].ToString();
//obj.StateName = reader["StateName"].ToString();
//obj.CountryName = reader["CountryName"].ToString();
obj.AreaId = Convert.ToInt32(reader["AreaId"]);
obj.AreaName = reader["AreaName"].ToString();
obj.ZipCode = reader["ZipCode"].ToString();
obj.Latitude = reader["Latitude"].ToString();
obj.Longitude = reader["Longitude"].ToString();
//obj.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
obj.IsActive = Convert.ToBoolean(reader["IsActive"]);
listArea.Add(obj);
}
}
return(listArea);
}
public bool SaveArea(AreaModel model)
{
try
{
AreaMaster md = new AreaMaster();
md.areaCode = model.areaCode;
md.areaName = model.areaName;
md.address = model.address;
md.city = model.city;
md.pinCode = model.pinCode;
md.state = model.state;
md.phoneNo = model.phoneNo;
md.mobileNo = model.mobileNo;
md.emailId = model.emailId;
md.region = model.region;
md.cashBalanceLimit = model.cashBalanceLimit;
md.bankBalanceLimit = model.bankBalanceLimit;
md.remark = model.remark;
md.isActive = true;
_tRSEntities.AreaMasters.Add(md);
_tRSEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public DataBaseResultSet SaveAreaMaster <T>(T objData) where T : class, IModel, new()
{
AreaMaster obj = objData as AreaMaster;
string sQuery = "sprocAreaMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("AreaCode", "AreaCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AreaCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("AreaName", "AreaName", 50, GenericDataType.String, ParameterDirection.Input, obj.AreaName));
list.Add(SqlConnManager.GetConnParameters("CityCode", "CityCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CityCode));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
public void GetListAreaMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListAreaMaster";
AreaMaster objData = objFilter as AreaMaster;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("AreaCode", "AreaCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.AreaCode));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillAreaMasterDataFromReader, ref listData);
}
public DataView BindGvAreaDetail()
{
DataTable dt = new DataTable();
dt = AreaMaster.GetAreaMaster();
DataView dv = new DataView(dt);
return(dv);
}
public async Task <IHttpActionResult> Create(AreaMaster prodData)
{
if (prodData != null)
{
await AreaMasterDA.AddAreaMaster(prodData);
return(Ok());
}
return(BadRequest("Request cannot be NULL"));
}
private void FillAreaMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new()
{
while (DbReader.Read())
{
T obj = new T();
AreaMaster objData = obj as AreaMaster;
obj.FillDataFromDB(DbReader);
listData.Add(obj);
}
}
public List <AreaMaster> Get(QueryBO objQuery)
{
SqlDataReader reader = null;
SqlConnection con = null;
List <AreaMaster> lstArea = null;
SqlCommand objcmd = null;
AreaMaster objArea = null;
try
{
lstArea = new List <AreaMaster>();
using (con = DBconnection.ConnectToDB())
{
objcmd = new SqlCommand();
objcmd.Connection = con;
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "STP_SelectAreaMaster";
objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber));
objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize));
objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter));
objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort));
objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output;
reader = objcmd.ExecuteReader();
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
objArea = new AreaMaster();
objArea.AreaID = Convert.ToInt64(reader["AreaID"]);
objArea.CityID = Convert.ToInt32(reader["CityID"]);
objArea.StateID = Convert.ToInt32(reader["StateID"]);
objArea.AreaName = Convert.ToString("" + reader["AreaName"]);
objArea.CountryID = Convert.ToInt32(reader["CountryID"]);
objArea.Status = Convert.ToInt32("" + reader["Status"]);
objArea.Remarks = Convert.ToString("" + reader["Remarks"]);
objArea.strStatus = Convert.ToString("" + reader["strStatus"]);
lstArea.Add(objArea);
}
}
}
objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
reader.Dispose();
objcmd = null;
con = null;
}
return(lstArea);
}
private async Task <List <AreaMaster> > getRegionByArea(List <Point> points)
{
List <List <Area> > allAreas = new List <List <Area> >();
List <List <AreaMaster> > allAreasMaster = new List <List <AreaMaster> >();
Parallel.ForEach(points, point =>
{
Dictionary <string, Condition> keyConditions = new Dictionary <string, Condition>();
keyConditions.Add("Tile", new Condition()
{
ComparisonOperator = "EQ", AttributeValueList = new List <AttributeValue>()
{
new AttributeValue(GetTileStr(point.X, point.Y))
}
});
QueryRequest queryRequest = new QueryRequest()
{
TableName = areaTableName,
IndexName = "AreaIDIndex",
KeyConditions = keyConditions,
};
var result = dynamoDBClient.QueryAsync(queryRequest).Result;
allAreas.Add(Area.ConvertToEntity(result.Items));
});
Parallel.ForEach(allAreas.SelectMany(x => x).Select(x => x.AreaID).Distinct(), areaId =>
{
Dictionary <string, Condition> keyConditions = new Dictionary <string, Condition>();
keyConditions.Add("AreaID", new Condition()
{
ComparisonOperator = "EQ", AttributeValueList = new List <AttributeValue>()
{
new AttributeValue(areaId)
}
});
QueryRequest queryRequest = new QueryRequest()
{
TableName = areaMasterTableName,
IndexName = "AreaPolygonIndex",
KeyConditions = keyConditions,
};
var result = dynamoDBClient.QueryAsync(queryRequest).Result;
allAreasMaster.Add(AreaMaster.ConvertToEntity(result.Items));
});
return(allAreasMaster.SelectMany(x => x).ToList());
}
public static void Init()
{
Mod = new ModuleMaster();
Dic = new DictionMaster();
Area = new AreaMaster();
Track = new TrackMaster();
Device = new DeviceMaster();
Goods = new GoodsMaster();
Warn = new WarningMaster();
TileTrack = new TileTrackMaster();
Role = new RoleMaster();
PreStart();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
AreaMaster am = new AreaMaster
{
CityId = Convert.ToInt32(ddlcityid.SelectedItem.Value),
AreaName = txtAreaName.Text
};
DataClassesDataContext dcdc = new DataClassesDataContext();
dcdc.AreaMasters.InsertOnSubmit(am);
dcdc.SubmitChanges();
gvArea.DataBind();
txtAreaName.Text = "";
}
public ActionResult Action(AreaMasterFilter objFilter, string submit)
{
CommonBL objCommonBL = null;
AreaMaster objCity = null;
try
{
objDetailsVM = new AreaDetailsVM();
if (submit.ToLower() == "edit")
{
objCommonBL = new CommonBL();
TempData["CountryFilter"] = objFilter;
objAreaBL = new AreaBL();
objDetailsVM = new AreaDetailsVM();
objDetailsVM.AreaMstr = objAreaBL.GetData(new AreaMasterFilter()
{
AreaID = objFilter.AreaID
}).FirstOrDefault();
objDetailsVM.CntMst = Chikitsa.DataAccessLayer.StateDAL.GetCountry();
// objDetailsVM.lstUserTypes = objCommonBL.GetCodeDetail(new CodeDetailFilter() { CodeTypeId = 1 });
return(View("Details", objDetailsVM));
}
else if (submit.ToLower() == "delete")
{
objAreaBL = new AreaBL();
objListVM = new AreaMasterListVM();
objCity = new AreaMaster(objFilter.StateID);
objCity.ModifiedBy = 1;
objCity.Remarks = "Deleted";
objResponse = objAreaBL.SaveArea(objCity, "D");
objFilter.CountryID = 0;
objListVM = GetAreaListVM(objFilter);
objListVM.Toast = WebCommon.SetToast(objResponse);
return(View("Index", objListVM));
}
}
catch (Exception ex)
{
throw;
}
finally
{
objAreaBL = null;
objDetailsVM = null;
objListVM = null;
objCommonBL = null;
}
return(null);
}
public async Task <List <AreaMaster> > GetArea()
{
Dictionary <string, Condition> queryCondition = new Dictionary <string, Condition>();
//queryCondition.Add("IsPredefine", new Condition() { ComparisonOperator = "EQ", AttributeValueList = new List<AttributeValue>() { new AttributeValue() { N = "1" } } });
var request = new ScanRequest
{
TableName = areaMasterTableName,
IndexName = "AreaIDIndex",
ScanFilter = queryCondition
};
var response = await dynamoDBClient.ScanAsync(request);
List <AreaMaster> listings = AreaMaster.ConvertToEntity(response.Items);
return(listings);
}
public ActionResult Addarea(FormCollection frm)
{
try
{
Chatpata_dabbaEntities1 EntityFile = new Chatpata_dabbaEntities1();
AreaMaster reg = new AreaMaster();
reg.Name = Convert.ToString(frm["Name"]);
EntityFile.AreaMasters.Add(reg);
EntityFile.SaveChanges();
return(RedirectToAction("Admin", "Admin"));
}
catch (Exception ex)
{
throw ex;
}
}
//protected void btnAdd_Click(object sender, EventArgs e)
//{
// txtAreaCode.Text = "";
// txtAreaName.Text = "";
// lblID.Text = "0";
// pnlArea.Visible = true;
// pnlAreaDetails.Visible = false;
//}
protected void btnSave_Click(object sender, EventArgs e)
{
AreaMaster _objAm = new AreaMaster();
_objAm.AreaID = Convert.ToInt32(lblID.Text);
_objAm.AreaCode = txtAreaCode.Text.Trim();
_objAm.AreaName = txtAreaName.Text.Trim();
_objAm.AreaZoneID = Convert.ToInt32(DDLAreaZone.SelectedItem.Value.ToString());
_objAm.IsActive = Chekacv.Checked;
try
{
_objAm.Save();
MessageBox("Record saved successfully");
grdAreaDetails.DataSource = BindGvAreaDetail();
grdAreaDetails.DataBind();
if (btnSave.Text == "Update")
{
pnlAreaDetails.Visible = true;
pnlArea.Visible = false;
btnSave.Visible = false;
btnSave.Text = "Save";
txtAreaCode.Enabled = true;
filter.Visible = true;
btnprint.Visible = true;
}
else
{
pnlAreaDetails.Visible = false;
pnlArea.Visible = true;
txtAreaCode.Focus();
txtAreaCode.Text = "";
txtAreaName.Text = "";
DDLZone.Items.Clear();
DDLAreaZone.Items.Clear();
DDLSuperZone.SelectedValue = null;
Bind_DDL_SuperZone();
}
}
catch
{
}
}
public int Save(AreaMaster area, string CRUDAction, out string ErrorCode)
{
int result = 0;
ErrorCode = "-1";
using (SqlCommand objcmd = new SqlCommand())
{
try
{
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "STP_InsertUpdateAreaMaster";
objcmd.Parameters.Add(new SqlParameter("@AreaID", area.AreaID)).Direction = ParameterDirection.InputOutput;
objcmd.Parameters.Add(new SqlParameter("@AreaName", area.AreaName));
objcmd.Parameters.Add(new SqlParameter("@CityID", area.CityID));
objcmd.Parameters.Add(new SqlParameter("@CountryID", area.CountryID));
objcmd.Parameters.Add(new SqlParameter("@StateID", area.StateID));
objcmd.Parameters.Add(new SqlParameter("@Status", area.Status));
objcmd.Parameters.Add(new SqlParameter("@Remarks", area.Remarks));
objcmd.Parameters.Add(new SqlParameter("@CreatedBy", area.CreatedBy));
objcmd.Parameters.Add(new SqlParameter("@ModifiedBy", area.ModifiedBy));
objcmd.Parameters.Add(new SqlParameter("@CRUDAction", CRUDAction));
objcmd.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.VarChar, 20)).Direction = ParameterDirection.Output;
result = DBconnection.ExecuteNonQuery(objcmd);
area.AreaID = Convert.ToInt64("0" + objcmd.Parameters["@AreaID"].Value);
ErrorCode = Convert.ToString(objcmd.Parameters["@ErrorCode"].Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objcmd.Dispose();
}
}
return(result);
}
public List <T> GetTable <T>(TableFilter objFilter)
{
List <object> lstObject = null;
try
{
lstObject = new List <object>();
using (con = DBconnection.ConnectToDB())
{
objcmd = new SqlCommand();
objcmd.Connection = con;
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "STP_Select_BindDropdown";
objcmd.Parameters.Add(new SqlParameter("@Table", objFilter.TableName));
objcmd.Parameters.Add(new SqlParameter("@IDColumn", objFilter.IdColumn));
objcmd.Parameters.Add(new SqlParameter("@TextColumn", objFilter.TextColumn));
objcmd.Parameters.Add(new SqlParameter("@Condition", objFilter.Condition));
reader = objcmd.ExecuteReader();
if (reader != null && reader.HasRows)
{
switch (typeof(T).Name.ToLower())
{
case "countrymaster":
{
while (reader.Read())
{
CountryMaster obj = new CountryMaster();
obj.CountryID = Convert.ToInt64("0" + reader["CountryID"]);
obj.CountryName = Convert.ToString("" + reader["CountryName"]);
lstObject.Add(obj);
}
break;
}
case "statemaster":
{
while (reader.Read())
{
StateMaster obj = new StateMaster();
//obj.CountryId = Convert.ToInt32("0" + reader["CountryID"]);
obj.StateID = Convert.ToInt64("0" + reader["StateId"]);
obj.StateName = Convert.ToString("" + reader["StateName"]);
lstObject.Add(obj);
}
break;
}
case "citymaster":
{
while (reader.Read())
{
CityMaster obj = new CityMaster();
obj.CityID = Convert.ToInt64("0" + reader["CityID"]);
obj.CityName = Convert.ToString("" + reader["CityName"]);
lstObject.Add(obj);
}
break;
}
case "areamaster":
{
while (reader.Read())
{
AreaMaster obj = new AreaMaster();
obj.AreaID = Convert.ToInt64("0" + reader["Area_ID"]);
obj.AreaName = Convert.ToString("" + reader["Area_Name"]);
lstObject.Add(obj);
}
break;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
reader.Dispose();
objcmd = null;
con = null;
}
return(lstObject.OfType <T>().ToList());
}
public static void migrateAreas(DataRow[] dtAreas)
{
List <Area> areaMigration = new List <Area>();
foreach (DataRow area in dtAreas)
{
Area obj = new Area();
obj.AreaID = area[0].ToString();
obj.AreaName = area[1].ToString();
obj.URLName = area[2].ToString();
obj.URLPath = area[3].ToString();
obj.StateFIPS = area[4].ToString();
obj.FIPS = area[5].ToString();
obj.State = area[6].ToString();
obj.USPSCity = area[7].ToString();
obj.AreaTypeID = area[8].ToString();
obj.SubTypeID = area[9].ToString();
obj.OriginalPolygon = area[10].ToString();
obj.Latitude = Convert.ToDecimal(area[11].ToString());
obj.Longitude = Convert.ToDecimal(area[12].ToString());
obj.North = area[13].ToString();
obj.South = area[14].ToString();
obj.East = area[15].ToString();
obj.West = area[16].ToString();
obj.TopLeveeaID = area[17].ToString();
obj.SourceID = area[18].ToString();
obj.SourceKey = area[19].ToString();
obj.AreaStatus = !area.Table.Columns.Contains("Status") ? string.Empty : area[21].ToString();
areaMigration.Add(obj);
}
List <AreaMaster> areaMaster = new List <AreaMaster>();
List <Area> areas = new List <Area>();
foreach (Area obj in areaMigration)
{
var tempPoints = obj.OriginalPolygon.Replace("MULTIPOLYGON", "").Replace("POLYGON", "").Replace("(", "").Replace(")", "").Split(",").Select(x => x.Trim()).Where(x => x.Length > 0).Select(x => new LocationPoint()
{
Lng = Convert.ToDecimal(x.Substring(0, x.IndexOf(" ")).Trim()), Lat = Convert.ToDecimal(x.Substring(x.IndexOf(" "), x.Length - x.IndexOf(" ")).Trim())
}).ToList();
obj.Points = tempPoints;
List <Tile> rasterizePoints = regionServiceInstance.GetCoordinateTile(obj.Points.Select(x => new PointF((float)x.Lat, (float)x.Lng)).ToList(), true).tiles;
AreaMaster areaMasterObj = new AreaMaster();
areaMasterObj.AreaID = obj.AreaID;
areaMasterObj.AreaName = obj.AreaName;
areaMasterObj.EncodedPolygon = GooglePoints.EncodeBase64(tempPoints.Select(x => new CoordinateEntity(Convert.ToDouble(x.Lat), Convert.ToDouble(x.Lng))));
areaMasterObj.EncodedCompletedTiles = GooglePoints.EncodeBase64(rasterizePoints.Where(x => !x.IsPartialTile).Select(x => new CoordinateEntity(Convert.ToDouble(x.Row), Convert.ToDouble(x.Column))));
areaMasterObj.EncodedPartialTiles = GooglePoints.EncodeBase64(rasterizePoints.Where(x => x.IsPartialTile).Select(x => new CoordinateEntity(Convert.ToDouble(x.Row), Convert.ToDouble(x.Column))));
areaMasterObj.IsPredefine = true;
areaMaster.Add(areaMasterObj);
foreach (var point in rasterizePoints)
{
Area tempObj = (Area)obj.Clone();
tempObj.Tile = regionServiceInstance.GetTileStr((int)point.Row, (int)point.Column);
tempObj.Type = RecordType.Area;
tempObj.OriginalPolygon = "";
tempObj.Points = null;
areas.Add(tempObj);
}
}
List <AttributeDefinition> areaAttributeDefinition = new List <AttributeDefinition>()
{
new AttributeDefinition {
AttributeName = "Tile", AttributeType = ScalarAttributeType.S
},
new AttributeDefinition {
AttributeName = "AreaID", AttributeType = ScalarAttributeType.S
}
};
Projection projection = new Projection()
{
ProjectionType = "INCLUDE", NonKeyAttributes = new List <string> {
"AreaName"
}
};
List <LocalSecondaryIndex> localSecondaryIndexes = new List <LocalSecondaryIndex>();
List <KeySchemaElement> areaIDKeySchema = new List <KeySchemaElement>()
{
new KeySchemaElement {
AttributeName = "Tile", KeyType = KeyType.HASH
},
new KeySchemaElement {
AttributeName = "AreaID", KeyType = KeyType.RANGE
}
};
localSecondaryIndexes.Add(new LocalSecondaryIndex()
{
IndexName = "AreaIDIndex",
Projection = projection,
KeySchema = areaIDKeySchema
});
regionServiceInstance.CreateTempTable(regionServiceInstance.areaTableName, areaAttributeDefinition, null, localSecondaryIndexes, "Tile", "AreaID").Wait();
List <LocalSecondaryIndex> areaMasterLocalSecondaryIndexes = new List <LocalSecondaryIndex>();
List <KeySchemaElement> areaMasterAreaIDKeySchema = new List <KeySchemaElement>()
{
new KeySchemaElement {
AttributeName = "AreaID", KeyType = KeyType.HASH
},
new KeySchemaElement {
AttributeName = "AreaName", KeyType = KeyType.RANGE
}
};
areaMasterLocalSecondaryIndexes.Add(new LocalSecondaryIndex()
{
IndexName = "AreaIDIndex",
Projection = new Projection()
{
ProjectionType = "INCLUDE", NonKeyAttributes = new List <string> {
"IsPredefine"
}
},
KeySchema = areaMasterAreaIDKeySchema
});
List <KeySchemaElement> areaMasterAreaTileKeySchema = new List <KeySchemaElement>()
{
new KeySchemaElement {
AttributeName = "AreaID", KeyType = KeyType.HASH
},
new KeySchemaElement {
AttributeName = "IsPredefine", KeyType = KeyType.RANGE
}
};
areaMasterLocalSecondaryIndexes.Add(new LocalSecondaryIndex()
{
IndexName = "AreaTileIndex",
Projection = new Projection()
{
ProjectionType = "INCLUDE", NonKeyAttributes = new List <string> {
"EncodedTiles"
}
},
KeySchema = areaMasterAreaTileKeySchema
});
areaMasterLocalSecondaryIndexes.Add(new LocalSecondaryIndex()
{
IndexName = "AreaPolygonIndex",
Projection = new Projection()
{
ProjectionType = "INCLUDE", NonKeyAttributes = new List <string> {
"EncodedPolygon"
}
},
KeySchema = areaMasterAreaTileKeySchema
});
List <AttributeDefinition> areaMasterAttributeDefinition = new List <AttributeDefinition>()
{
new AttributeDefinition {
AttributeName = "AreaID", AttributeType = ScalarAttributeType.S
},
new AttributeDefinition {
AttributeName = "AreaName", AttributeType = ScalarAttributeType.S
},
new AttributeDefinition {
AttributeName = "IsPredefine", AttributeType = ScalarAttributeType.N
},
};
regionServiceInstance.CreateTempTable(regionServiceInstance.areaMasterTableName, areaMasterAttributeDefinition, null, areaMasterLocalSecondaryIndexes, "AreaID", "AreaName").Wait();
foreach (var obj in areaMaster.ToList().ChunkBy(100))
{
try
{
System.Console.WriteLine("adding Area Master chunk");
var batch = regionServiceInstance.context.CreateBatchWrite <AreaMaster>();
batch.AddPutItems(obj);
batch.ExecuteAsync().Wait();
System.Console.WriteLine("Area Master Chunk added");
//regionServiceInstance.context.SaveAsync(obj).Wait();
}
catch (Exception e)
{
System.Console.WriteLine(obj);
System.Console.WriteLine(e);
}
}
int count = 1;
foreach (var obj in areas.ToList().ChunkBy(100))
{
try
{
System.Console.WriteLine("adding Area chunk. index: " + count);
//Parallel.ForEach(obj, obj2 =>
//{
// regionServiceInstance.context.SaveAsync<Area>(obj2).Wait();
//});
var batch = regionServiceInstance.context.CreateBatchWrite <Area>();
batch.AddPutItems(obj);
batch.ExecuteAsync().Wait();
System.Console.WriteLine("Area Chunk added. index: " + count);
count += 1;
}
catch (Exception e)
{
System.Console.WriteLine(obj);
System.Console.WriteLine(e);
}
}
}
public int AddArea(AreaMaster areaMaster)
{
return(areaRepository.AddArea(areaMaster));
}
public async Task <GetAreaListingWrapper> GetArea(string id, string north = null, string east = null, string south = null, string west = null, string beds = null, string bathsFull = null, string bathsHalf = null, string propertyAddressId = null, string averageValue = null, string averageRent = null)
{
DateTime startQueryTime = DateTime.Now;
List <AreaMaster> listingArea = new List <AreaMaster>();
List <List <Property> > areaProperties = new List <List <Property> >();
Dictionary <string, Condition> areaKeyConditions = new Dictionary <string, Condition>();
Dictionary <string, Condition> areaQueryFilter = new Dictionary <string, Condition>();
areaKeyConditions.Add("AreaID", new Condition()
{
ComparisonOperator = "EQ", AttributeValueList = new List <AttributeValue>()
{
new AttributeValue(id)
}
});
areaQueryFilter.Add("IsPredefine", new Condition()
{
ComparisonOperator = "EQ", AttributeValueList = new List <AttributeValue>()
{
new AttributeValue()
{
N = "1"
}
}
});
QueryRequest queryRequest = new QueryRequest()
{
TableName = areaMasterTableName,
ReturnConsumedCapacity = "TOTAL",
KeyConditions = areaKeyConditions,
QueryFilter = areaQueryFilter
};
var result = dynamoDBClient.QueryAsync(queryRequest).Result;
listingArea = AreaMaster.ConvertToEntity(result.Items);
DateTime endQueryTime = DateTime.Now;
if (listingArea.Count() > 0)
{
var tempArea = new Area()
{
EncodedPolygon = listingArea.First().EncodedPolygon,
Points = GooglePoints.DecodeBase64(listingArea.First().EncodedPolygon).Select(x => new LocationPoint(x.Latitude, x.Longitude)).ToList()
};
GetListingWrapper output = await GetListing(tempArea, north, east, south, west, beds, bathsFull, bathsHalf, propertyAddressId, averageValue, averageRent, listingArea.First().EncodedCompletedTiles, listingArea.First().EncodedPartialTiles);
foreach (var area in listingArea)
{
area.EncodedPolygon = ASCIIEncoding.ASCII.GetString(Convert.FromBase64String(area.EncodedPolygon));
area.EncodedCompletedTiles = null;
area.EncodedPartialTiles = null;
}
return(new GetAreaListingWrapper
{
PropertyCount = output.PropertyCount,
ScanCount = output.ScanCount,
ConsumedCapacityCount = output.ConsumedCapacityCount,
TotalQueryExecutionTime = output.TotalQueryExecutionTime,
TotalLambdaExecutionTime = output.TotalLambdaExecutionTime,
TotalContainsExecutionTime = output.TotalContainsExecutionTime,
TotalAreaQueryTime = (endQueryTime - startQueryTime).TotalMilliseconds,
Properties = output.Properties,
Area = listingArea,
});
}
else
{
return(null);
}
}
