public List <Regioninfo> SelectallRegioninfo() { try { List <Regioninfo> lstinfo = new List <Regioninfo>(); using (RMSDataContext db = new RMSDataContext()) { Regioninfo rinfo; var a = (from o in db.Regions select o).ToList(); foreach (var obj in a) { rinfo = new Regioninfo(); rinfo.RegionID = obj.RegionID; rinfo.Region_Name = obj.Region_Name; rinfo.Region_Description = obj.Region_Description; lstinfo.Add(rinfo); } return(lstinfo); } } catch (Exception ex) { return(new List <Regioninfo>()); } }
protected void btnSaveRegion_Click(object sender, EventArgs e) { Regioninfo Regiinfo = new Regioninfo(); // Regiinfo.RegionID=txtRegionID.Text; Regiinfo.Region_Name = txtRegionName.Text; Regiinfo.Region_Description = txtRegionDescription.Text; RegionController RegiController = new RegionController(); RegiController.InsertRegion(Regiinfo); gridviewcall(); }
public void DeleteRegioinByRegionID(Regioninfo regioninfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from a in db.Regions where a.RegionID == regioninfo.RegionID select a).First(); db.Regions.DeleteOnSubmit(obj); db.SubmitChanges(); } } catch (Exception ex) { Region Region = new Region(); } }
public void UpdateRegionByRegionID(Regioninfo regioninfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from a in db.Regions where a.RegionID == regioninfo.RegionID select a).First(); obj.RegionID = regioninfo.RegionID; obj.Region_Name = regioninfo.Region_Name; obj.Region_Description = regioninfo.Region_Description; db.SubmitChanges(); } } catch (Exception ex) { Region Region = new Region(); } }
public void DeleteRegion(Regioninfo Regioninfo) { Regdao.DeleteRegioinByRegionID(Regioninfo); }
public void UpdateRegion(Regioninfo Regioninfo) { Regdao.UpdateRegionByRegionID(Regioninfo); }
public void InsertRegion(Regioninfo Regioninfo) { // Regdao.InsertRegion(Regioninfo); }