public static void Delete(Web_Project_MedicalTest.Models.Particular particular)
{
MedicalTestDB1Entities db = new MedicalTestDB1Entities();
var deleteItem = db.Particulars.Where(p => p.ParticularID == particular.ParticularID).FirstOrDefault();
db.Particulars.Remove(deleteItem);
db.SaveChanges();
}
public static void Insert(Web_Project_MedicalTest.Models.Particular particular)
{
MedicalTestDB1Entities db = new MedicalTestDB1Entities();
string fileNameToInsert = HttpContext.Current.Session["ImagePath"].ToString();
if (fileNameToInsert != string.Empty)
{
particular.ImageUrl = fileNameToInsert;
db.Particulars.Add(particular);
db.SaveChanges();
}
}
public static void Update(Web_Project_MedicalTest.Models.Particular particular)
{
MedicalTestDB1Entities db = new MedicalTestDB1Entities();
string fileNameToUpdate = HttpContext.Current.Session["ImagePath"].ToString();
if (fileNameToUpdate != string.Empty)
{
var updatePrt = db.Particulars.Where(P => P.ParticularID == particular.ParticularID).FirstOrDefault();
updatePrt.ParticularName = particular.ParticularName;
updatePrt.ImageUrl = fileNameToUpdate;
updatePrt.Rate = particular.Rate;
db.SaveChanges();
}
}
public static List <Web_Project_MedicalTest.Models.Particular> Select()
{
MedicalTestDB1Entities db = new MedicalTestDB1Entities();
return(db.Particulars.ToList());
}