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 void Delete(int id) { using (DefaultCS db = new DefaultCS()) { var d = db.mCIRCLEs.Where(i => i.CIRCLE_ID == id).First(); db.mCIRCLEs.DeleteObject(d); db.SaveChanges(); } }
public void Add(Village village) { using (DefaultCS db = new DefaultCS()) { db.Villages.MergeOption = MergeOption.NoTracking; db.Villages.AddObject(village); db.SaveChanges(); } }
public void Add(District district) { using (DefaultCS db = new DefaultCS()) { db.Districts.MergeOption = MergeOption.NoTracking; db.Districts.AddObject(district); db.SaveChanges(); } }
public static Int64 InsertArea(ForestArea forestArea) { using (var db = new DefaultCS()) { db.ForestAreas.AddObject(forestArea); db.SaveChanges(); } return forestArea.Id; }
public void Add(mSUBDIV division) { using (DefaultCS db = new DefaultCS()) { db.mSUBDIVs.MergeOption = MergeOption.NoTracking; db.mSUBDIVs.AddObject(division); db.SaveChanges(); } }
public void Add(mRA section) { using (DefaultCS db = new DefaultCS()) { db.mRAs.MergeOption = MergeOption.NoTracking; db.mRAs.AddObject(section); db.SaveChanges(); } }
public void Add(Tehsil tehsil) { using (DefaultCS db = new DefaultCS()) { db.Tehsils.MergeOption = MergeOption.NoTracking; db.Tehsils.AddObject(tehsil); db.SaveChanges(); } }
public void Delete(long id) { using (DefaultCS db = new DefaultCS()) { var d = db.mBEATs.Where(i => i.BEAT_ID == id).First(); db.mBEATs.DeleteObject(d); db.SaveChanges(); } }
public static string InsertCoordinates(ForestCoordinate forestCoordinates) { using (var db = new DefaultCS()) { db.ForestCoordinates.AddObject(forestCoordinates); db.SaveChanges(); } return "true"; }
public void Delete(int id) { using (DefaultCS db = new DefaultCS()) { var d = db.Tehsils.Where(i => i.Id == id).First(); db.Tehsils.DeleteObject(d); db.SaveChanges(); } }
public void Add(mWING zone) { using (DefaultCS db = new DefaultCS()) { db.mWINGs.MergeOption = MergeOption.NoTracking; db.mWINGs.AddObject(zone); db.SaveChanges(); } }
public void Update(District district) { using (DefaultCS db = new DefaultCS()) { var d = db.Districts.Where(i => i.Id == district.Id).First(); d.DistrictName = district.DistrictName; db.SaveChanges(); } }
public void Add(mCIRCLE circle) { using (DefaultCS db = new DefaultCS()) { db.mCIRCLEs.MergeOption = MergeOption.NoTracking; db.mCIRCLEs.AddObject(circle); db.SaveChanges(); } }
public void Add(Block block) { using (DefaultCS db = new DefaultCS()) { db.Blocks.MergeOption = MergeOption.NoTracking; db.Blocks.AddObject(block); db.SaveChanges(); } }
public void Create(LoginMaster loginMaster) { using (DefaultCS db = new DefaultCS()) { db.LoginMasters.MergeOption = MergeOption.NoTracking; db.LoginMasters.AddObject(loginMaster); db.SaveChanges(); } }
public void Update(mWING zone) { using (DefaultCS db = new DefaultCS()) { var d = db.mWINGs.Where(i => i.WING_ID == zone.WING_ID).First(); d.DESCRIPTION = zone.DESCRIPTION; db.SaveChanges(); } }
public void Update(Tehsil tehsil) { using (DefaultCS db = new DefaultCS()) { var d = db.Tehsils.Where(i => i.Id == tehsil.Id).First(); d.TehsilName = tehsil.TehsilName; d.DistrictId = tehsil.DistrictId; db.SaveChanges(); } }
public void Update(Village village) { using (DefaultCS db = new DefaultCS()) { var d = db.Villages.Where(i => i.Id == village.Id).First(); d.VillageName = village.VillageName; d.TehsilId = village.TehsilId; db.SaveChanges(); } }
//public void ChangePassord(string userid, string password, string newpassword) //{ // var Emp = GetUser(userid, password); // if (Emp != null) // { // UpdateUser(userid, newpassword); // } //} public void UpdateUser(string userId, string password) { using (var db = new DefaultCS()) { var newLogin = db.LoginMasters.Where(s => s.UserId == userId).FirstOrDefault(); if (newLogin != null) { newLogin.UserId = userId; newLogin.Password = password; db.SaveChanges(); } } }
public void Update(mRANGE range) { using (DefaultCS db = new DefaultCS()) { var d = db.mRANGEs.Where(i => i.RANGE_ID == range.RANGE_ID).First(); d.RANGE_ENAME = range.RANGE_ENAME; d.SUBDIV_ID = range.SUBDIV_ID; d.officername = range.officername; d.Std = range.Std; d.Phoneno = range.Phoneno; d.faxno = range.faxno; d.Mobileno = range.Mobileno; db.SaveChanges(); } }
public void Add(KhasaraDetail khasaraDetail) { DefaultCS defaultC = new DefaultCS(); try { defaultC.KhasaraDetails.MergeOption = MergeOption.NoTracking; defaultC.KhasaraDetails.AddObject(khasaraDetail); defaultC.SaveChanges(); } finally { if (defaultC != null) { ((IDisposable)defaultC).Dispose(); } } }
public void Update(mCIRCLE circle) { using (DefaultCS db = new DefaultCS()) { var d = db.mCIRCLEs.Where(i => i.CIRCLE_ID == circle.CIRCLE_ID).First(); d.CIRCLE_ENAME = circle.CIRCLE_ENAME; d.WING_ID = circle.WING_ID; d.officername = circle.officername; d.Std = circle.Std; d.Phoneno = circle.Phoneno; d.faxno = circle.faxno; d.Mobileno = circle.Mobileno; d.Lastupdatedon = circle.Lastupdatedon; db.SaveChanges(); } }
public void Update(mRA section) { using (DefaultCS db = new DefaultCS()) { var d = db.mRAs.Where(i => i.RASST_ID == section.RASST_ID).First(); d.RANGEASST_ENAME = section.RANGEASST_ENAME; d.RANGE_ID = section.RANGE_ID; //d.OfficerName = section.OfficerName; d.Std = section.Std; d.Phoneno = section.Phoneno; d.faxno = section.faxno; d.Mobileno = section.Mobileno; d.UpdateOn = section.UpdateOn; db.SaveChanges(); } }
public void Update(Block block) { using (DefaultCS db = new DefaultCS()) { var d = db.Blocks.Where(i => i.Id == block.Id).First(); d.BlockName = block.BlockName; d.SectionId = block.SectionId; d.OfficerName = block.OfficerName; d.STD = block.STD; d.PhoneNo = block.PhoneNo; d.FaxNo = block.FaxNo; d.MobileNo = block.MobileNo; d.UpdatedBy = block.UpdatedBy; d.UpdatedDate = block.UpdatedDate; db.SaveChanges(); } }
public void Update(mSUBDIV subDivision) { using (DefaultCS db = new DefaultCS()) { var d = db.mSUBDIVs.Where(i => i.SUBDIV_ID == subDivision.SUBDIV_ID).First(); d.SUBDIV_ENAME = subDivision.SUBDIV_ENAME; d.DIV_ID = subDivision.DIV_ID; d.officername = subDivision.officername; d.Std = subDivision.Std; d.Phoneno = subDivision.Phoneno; d.faxno = subDivision.faxno; d.Mobileno = subDivision.Mobileno; d.UpdateOn = subDivision.UpdateOn; d.Lastupdatedon = subDivision.Lastupdatedon; db.SaveChanges(); } }
public void Delete(int id) { DefaultCS defaultC = new DefaultCS(); try { KhasaraDetail khasaraDetail = ( from i in defaultC.KhasaraDetails where i.Id == id select i).First<KhasaraDetail>(); defaultC.KhasaraDetails.DeleteObject(khasaraDetail); defaultC.SaveChanges(); } finally { if (defaultC != null) { ((IDisposable)defaultC).Dispose(); } } }
public void Update(mDIVISION division) { using (DefaultCS db = new DefaultCS()) { var d = db.mDIVISIONs.Where(i => i.DIV_ID == division.DIV_ID).First(); d.DIV_ENAME = division.DIV_ENAME; d.CIRCLE_ID = division.CIRCLE_ID; d.officername = division.officername; d.Std = division.Std; d.Phoneno = division.Phoneno; d.faxno = division.faxno; d.Mobileno = division.Mobileno; d.Lastupdatedon = division.Lastupdatedon; d.InstrumentModel = division.InstrumentModel; d.NoOfInstrument = division.NoOfInstrument; db.SaveChanges(); } }
public void Delete(int id) { using (DefaultCS db = new DefaultCS()) { var d = db.ForestAreas.Where(i => i.Id == id).First(); var c = db.ForestCoordinates.Where(i => i.ForestAreaId == id).ToList(); c.ForEach(i => { db.ForestCoordinates.DeleteObject(i); }); var b = db.GazetteDetails.Where(i => i.ForestAreaId == id).ToList(); b.ForEach(i => { db.GazetteDetails.DeleteObject(i); }); db.ForestAreas.DeleteObject(d); db.SaveChanges(); } }
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) { } } }