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());
}
}
}
