public static List <User> GetUsers()
{
using (AdminContext context = new AdminContext())
{
return(context.List.ToList());
}
}
public static List <Admin> GetDetails()
{
using (AdminContext context = new AdminContext())
{
return(context.Detail.ToList());
}
}
public static void AddUser(User user)
{
using (AdminContext context = new AdminContext())
{
context.List.Add(user);
context.SaveChanges();
}
}
public static Admin GetInsuranceDetailsById(int insuranceId)
{
using (AdminContext context = new AdminContext())
{
Admin admin = context.Detail.Where(model => model.insuranceId == insuranceId).SingleOrDefault();
return(admin);
}
}
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();
}
}
public string SignIn(User user)
{
using (AdminContext context = new AdminContext())
{
List <User> signin = context.List.ToList();
foreach (var value in signin)
{
if (user.phoneNumber == value.phoneNumber && user.password == value.password)
{
return(value.role);
}
}
return("not");
}
}
