public static void AddUser(User user)
{
using (AdminContext context = new AdminContext())
{
context.List.Add(user);
context.SaveChanges();
}
}
public static void UpdateDetails(Admin admin)
{
using (AdminContext context = new AdminContext())
{
context.Entry(admin).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void DeleteDetails(Admin admin)
{
using (AdminContext context = new AdminContext())
{
Admin details = context.Detail.Where(model => model.insuranceId == admin.insuranceId).SingleOrDefault();
context.Detail.Attach(details);
context.Detail.Remove(details);
context.SaveChanges();
}
}
public static void AddDetails(Admin admin)
{
using (AdminContext context = new AdminContext())
{
SqlParameter insuranceNumber = new SqlParameter("@insuranceNumber", admin.insuranceNumber);
SqlParameter insuranceType = new SqlParameter("@insuranceType", admin.insuranceType);
SqlParameter GST = new SqlParameter("@GST", admin.GST);
var data = context.Database.ExecuteSqlCommand("Admin_Insert @insuranceNumber,@insuranceType,@GST", insuranceNumber, insuranceType, GST);
//context.Detail.Add(admin);
context.SaveChanges();
}
}