private List <ZoneProperty> FillZoneObject(DataTable dataTable)
{
var objZoneObjectList = new List <ZoneProperty>();
try
{
if (dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objZoneObject = new ZoneProperty
{
ZoneId = Convert.ToInt32(dataTable.Rows[j]["AjZoneId"]),
ZoneName = Convert.ToString(dataTable.Rows[j]["AjZoneName"])
};
objZoneObjectList.Add(objZoneObject);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing FillZoneObject in Zone.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objZoneObjectList);
}
public Zone(Editor e, Point p, int index)
{
editor = e;
attachPoint = new VertexMarker();
attachPoint.setPosition(PanAndZoom.fromLocalToGlobal(p));
attachPoint.Colour = System.Drawing.Brushes.Green;
outline = new Outline(p);
propertypanel = new ZoneProperty(this);
possession = Possession.Neutral;
Name = string.Format("Zone {0}", index);
setSelected(false);
}
public Zone(Editor e, Area a)
{
//name = a.Name;
editor = e;
area = a;
attachPoint = new VertexMarker();
attachPoint.setPosition(Geometry.Geometry.convertPoint(a.AttachmentPoint));
attachPoint.Colour = System.Drawing.Brushes.Green;
outline = new Outline(Geometry.Geometry.getOutline(a.Content));
propertypanel = new ZoneProperty(this);
possession = Possession.Neutral;
Name = string.Format("Zone {0}", a.Id);
setSelected(false);
}
protected void btnUpload_Click(object sender, EventArgs e)
{
_objCommon = new Common();
try
{
var objClsOledbdatalayer = new ClsOleDBDataWrapper();
var path = MapPath(fileUploadExcel.FileName);
fileUploadExcel.SaveAs(path);
var excelSheets = objClsOledbdatalayer.CountTotalSheets(path);
if (excelSheets.Length > 0)
{
foreach (string t in excelSheets)
{
DataSet ds = objClsOledbdatalayer.getdata(path, t);
if (ds.Tables[0].Rows.Count > 0)
{
for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++)
{
var errMsg = "";
_objZoneProperty = new ZoneProperty
{
ZoneName = ds.Tables[0].Rows[j]["ZoneName"].ToString(),
};
var result = ZoneProvider.Instance.InsertZoneDetails(ds.Tables[0].Rows[j]["ZoneName"].ToString(), LoggedInUserId, out errMsg);
}
lblMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg");
lblMsg.Visible = true;
BindAllZoneList();
}
}
}
else
{
lblErrorMsg.Text = _objCommon.GetErrorMessage("lblErrMsg");
lblMsg.Visible = false;
lblErrorMsg.Visible = true;
}
}
catch (Exception ex)
{
}
}
