public Int64? InsertArea1(ForestArea forestArea, CadastralPoint[] cadastralPoints)
{
using (var db = new DefaultCS())
{
try
{
if (cadastralPoints != null)
{
EntityCollection<CadastralPoint> cp = new EntityCollection<CadastralPoint>();
foreach (var cpp in cadastralPoints)
{
cp.Add(cpp);
}
forestArea.CadastralPoints1 = cp;
}
forestArea.CreatedDate = DateTime.Now;
db.ForestAreas.AddObject(forestArea);
db.SaveChanges();
return forestArea.Id;
}
catch (Exception ex)
{
return null;
}
}
}
public static Int64 InsertArea(ForestArea forestArea)
{
using (var db = new DefaultCS())
{
db.ForestAreas.AddObject(forestArea);
db.SaveChanges();
}
return forestArea.Id;
}
public Int64? UpdateArea(ForestArea forestArea, ForestCoordinate[] forestCoordinates)
{
IFormatProvider provider = new System.Globalization.CultureInfo("en-GB", true);
using (var db = new DefaultCS())
{
try
{
var fUpdate = db.ForestAreas.Where(i => i.Id == forestArea.Id).First();
foreach (var fcc in forestCoordinates)
{
var forestC = db.ForestCoordinates.Where(i => i.Id == fcc.Id).First();
forestC.BackBearings = fcc.BackBearings;
forestC.BackDistanceInChain = fcc.BackDistanceInChain;
forestC.BackDistanceInMeter = fcc.BackDistanceInMeter;
forestC.BearingDifference = fcc.BearingDifference;
forestC.ForwardBearings = fcc.ForwardBearings;
forestC.Latitude = fcc.Latitude;
forestC.Longitude = fcc.Longitude;
forestC.PillarNo = fcc.PillarNo;
forestC.LatitudeField = fcc.LatitudeField;
forestC.LongitudeField = fcc.LongitudeField;
}
fUpdate.AreaInField = forestArea.AreaInField;
fUpdate.AreaCalculated = forestArea.AreaCalculated;
fUpdate.AreaInGazette = forestArea.AreaInGazette;
fUpdate.BlockId = forestArea.BlockId;
fUpdate.ForestName = forestArea.ForestName;
fUpdate.ForestType = forestArea.ForestType;
fUpdate.GazetteNo = forestArea.GazetteNo;
fUpdate.isReferencePoint = forestArea.isReferencePoint;
fUpdate.NumberOfPillars = forestArea.NumberOfPillars;
fUpdate.VillageId = forestArea.VillageId;
//fUpdate.GazetteDate = DateTime.Parse(forestArea.GazetteDate.ToString(), provider);
fUpdate.GazetteDate = forestArea.GazetteDate;
fUpdate.UpdatedDate = DateTime.Now;
fUpdate.UpdatedBy = forestArea.UpdatedBy;
db.SaveChanges();
return forestArea.Id;
}
catch (Exception ex)
{
return null;
}
}
}
public void Update(ForestArea forestArea, EntityCollection<GazetteDetail> gd)
{
IFormatProvider provider = new System.Globalization.CultureInfo("en-GB", true);
using (var db = new DefaultCS())
{
try
{
var fUpdate = db.ForestAreas.Where(i => i.Id == forestArea.Id).First();
var arrGD = db.GazetteDetails.Where(i => i.ForestAreaId == forestArea.Id).ToList();
if (arrGD.Count > 0)
{
arrGD.ForEach(i => { db.GazetteDetails.DeleteObject(i); });
}
foreach (var fcc in gd)
{
db.GazetteDetails.AddObject(fcc);
}
fUpdate.NotificationNo = forestArea.NotificationNo;
fUpdate.NotificationType = forestArea.NotificationType;
fUpdate.GazetteAuthority = forestArea.GazetteAuthority;
fUpdate.GazetteNo = forestArea.GazetteNo;
fUpdate.GazetteTitle = forestArea.GazetteTitle;
fUpdate.PagesInEnglish = forestArea.PagesInEnglish;
fUpdate.PagesInHindi = forestArea.PagesInHindi;
fUpdate.GazetteDate = forestArea.GazetteDate;
db.SaveChanges();
}
catch (Exception ex)
{
}
}
}
public Int64? InsertArea(ForestArea forestArea, ForestCoordinate[] forestCoordinates)
{
using (var db = new DefaultCS())
{
try
{
EntityCollection<ForestCoordinate> fc = new EntityCollection<ForestCoordinate>();
foreach (var fcc in forestCoordinates)
{
fc.Add(fcc);
}
forestArea.ForestCoordinates = fc;
forestArea.CreatedDate = DateTime.Now;
db.ForestAreas.AddObject(forestArea);
db.SaveChanges();
return forestArea.Id;
}
catch (Exception ex)
{
return null;
}
}
}
/// <summary>
/// Deprecated Method for adding a new object to the ForestAreas EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToForestAreas(ForestArea forestArea)
{
base.AddObject("ForestAreas", forestArea);
}
/// <summary>
/// Create a new ForestArea object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
public static ForestArea CreateForestArea(global::System.Int64 id)
{
ForestArea forestArea = new ForestArea();
forestArea.Id = id;
return forestArea;
}
protected void btnSave_Click(object sender, EventArgs e)
{
IFormatProvider cultureInfo = new CultureInfo("en-GB", true);
long num = Convert.ToInt64(base.Server.HtmlEncode(base.Request.QueryString["Code"]));
ForestArea forestArea = new ForestArea()
{
Id = num,
NotificationNo = this.txtNotificationNumber.Text.Trim(),
NotificationType = this.txtNotificationType.Text.Trim()
};
if (this.txtGazetteDate.Text.Trim() != "")
{
forestArea.GazetteDate = new DateTime?(DateTime.Parse(this.txtGazetteDate.Text.Trim(), cultureInfo));
}
forestArea.GazetteNo = this.txtGazetteNo.Text.Trim();
forestArea.GazetteAuthority = this.txtGazetteAuthority.Text.Trim();
forestArea.GazetteTitle = this.txtGazetteTitle.Text.Trim();
if (this.txtEnglishPage.Text.Trim() != "")
{
forestArea.PagesInEnglish = new int?(Convert.ToInt32(this.txtEnglishPage.Text.Trim()));
}
if (this.txtHindiPage.Text.Trim() != "")
{
forestArea.PagesInHindi = new int?(Convert.ToInt32(this.txtHindiPage.Text.Trim()));
}
EntityCollection<GazetteDetail> gazetteDetails = new EntityCollection<GazetteDetail>();
foreach (GridViewRow row in this.gvShow.Rows)
{
HiddenField hiddenField = (HiddenField)row.FindControl("hfLanguage");
HiddenField hiddenField1 = (HiddenField)row.FindControl("hfPhoto");
TextBox textBox = (TextBox)row.FindControl("txtPageNumber");
FileUpload fileUpload = (FileUpload)row.FindControl("fuImage");
GazetteDetail gazetteDetail = new GazetteDetail()
{
ForestAreaId = num,
Language = hiddenField.Value
};
if (textBox.Text.Trim() != "")
{
gazetteDetail.PageNo = new int?(Convert.ToInt32(textBox.Text.Trim()));
}
if (hiddenField1.Value != "")
{
gazetteDetail.Photo = hiddenField1.Value;
}
if (fileUpload.HasFile)
{
gazetteDetail.Photo = fileUpload.PostedFile.FileName;
string str = string.Concat(base.Server.MapPath("~"), "\\MAP\\", fileUpload.FileName);
HttpPostedFile postedFile = fileUpload.PostedFile;
if (postedFile.ContentLength > 0)
{
ResizeIamge.ResizeFromStream(str, 800, postedFile.InputStream);
}
}
gazetteDetails.Add(gazetteDetail);
}
this.fMethods.Update(forestArea, gazetteDetails);
js.ShowAlert(this, "Gazette details updated sucessfully!");
}
public Int64? UpdateArea1(ForestArea forestArea, CadastralPoint[] cadastralPoints)
{
IFormatProvider provider = new System.Globalization.CultureInfo("en-GB", true);
using (var db = new DefaultCS())
{
try
{
var fUpdate = db.ForestAreas.Where(i => i.Id == forestArea.Id).First();
if (cadastralPoints != null)
{
foreach (var cpp in cadastralPoints)
{
try
{
var CC = db.CadastralPoints.Where(i => i.ForestAreaId == fUpdate.Id);
foreach (CadastralPoint ccc in CC)
{
db.CadastralPoints.DeleteObject(ccc);
}
}
catch (Exception) { }
cpp.ForestAreaId = fUpdate.Id;
db.CadastralPoints.AddObject(cpp);
}
}
fUpdate.AreaInGazette = forestArea.AreaInGazette;
fUpdate.BlockId = forestArea.BlockId;
fUpdate.ForestName = forestArea.ForestName;
fUpdate.ForestType = forestArea.ForestType;
fUpdate.GazetteNo = forestArea.GazetteNo;
fUpdate.CadastralPoints = forestArea.CadastralPoints;
fUpdate.VillageId = forestArea.VillageId;
//fUpdate.GazetteDate = DateTime.Parse(forestArea.GazetteDate.ToString(), provider);
fUpdate.GazetteDate = forestArea.GazetteDate;
fUpdate.UpdatedDate = DateTime.Now;
fUpdate.UpdatedBy = forestArea.UpdatedBy;
db.SaveChanges();
return forestArea.Id;
}
catch (Exception ex)
{
return null;
}
}
}