public List <MERGED_Data> GetAllData() { using (var contextAR = new TestDB_UpdatedEntities()) { try { return(contextAR.MERGED_Data.OrderByDescending(x => x.UNITID).ToList()); } catch (Exception ex) { return(null); } } }
public List <MERGED_Data> GetAllDRFilter(string PrNo) { using (var contextAR = new TestDB_UpdatedEntities()) { try { return(contextAR.MERGED_Data.Where(i => i.UNITID.ToString() == PrNo).OrderByDescending(x => x.UNITID).ToList()); } catch (Exception ex) { return(null); } } }
public MERGED_Data getAllProjectDetails(double unitnm) { using (var contextAR = new TestDB_UpdatedEntities()) { try { var data = contextAR.MERGED_Data.Where(i => i.UNITID == unitnm).FirstOrDefault(); return(data); } catch (Exception ex) { return(null); } } }
public string SaveData(MERGED_Data dr) { using (var contextAR = new TestDB_UpdatedEntities()) { try { contextAR.MERGED_Data.Add(dr); contextAR.SaveChanges(); return("saved"); } catch (Exception ex) { return(ex.ToString()); } } }
public string DeleteRecord(double unitnm) { using (var contextAR = new TestDB_UpdatedEntities()) { try { var data = contextAR.MERGED_Data.Where(i => i.UNITID == unitnm).FirstOrDefault(); contextAR.MERGED_Data.Remove(data); contextAR.SaveChanges(); return("saved"); } catch (Exception ex) { return(ex.ToString()); } } }