public static void Edit(int id, string so_dk_tau, int?so_thuyenvien, string khuvuc_gapnan, DateTime?tg_gannan, List <int> sucovetau, List <int> sucovenguoi, string coquanxuly, decimal?thiethai_uoctinh, string vido, string kinhdo, string tau_khac, string nguoi_khac, int?chet, int?mattich)
{
using (FDBContext db = new FDBContext())
{
var kt_thiethaikhaithac = db.KT_THIETHAIKHAITHAC.Where(x => x.ID == id).First();
kt_thiethaikhaithac.SO_DK_TAU = so_dk_tau;
kt_thiethaikhaithac.SO_THUYENVIEN = so_thuyenvien;
kt_thiethaikhaithac.KHUVUC_GAPNAN = khuvuc_gapnan;
kt_thiethaikhaithac.TG_GAPNAN = tg_gannan;
kt_thiethaikhaithac.COQUAN_XULY = coquanxuly;
kt_thiethaikhaithac.THIETHAI_UOCTINH = thiethai_uoctinh;
kt_thiethaikhaithac.VIDO = vido;
kt_thiethaikhaithac.KINHDO = kinhdo;
kt_thiethaikhaithac.TAU_KHAC = tau_khac;
kt_thiethaikhaithac.NGUOI_KHAC = nguoi_khac;
kt_thiethaikhaithac.SO_NGUOI_CHET = chet;
kt_thiethaikhaithac.SO_NGUOI_MAT_TICH = mattich;
kt_thiethaikhaithac.SUCOVETAU.Clear();
foreach (var sucovetauID in sucovetau)
{
var sucovetaus = db.DSUCOVETAU.Find(sucovetauID);
kt_thiethaikhaithac.SUCOVETAU.Add(sucovetaus);
}
kt_thiethaikhaithac.SUCOVENGUOI.Clear();
foreach (var sucovenguoiID in sucovenguoi)
{
var sucovenguois = db.DSUCOVENGUOI.Find(sucovenguoiID);
kt_thiethaikhaithac.SUCOVENGUOI.Add(sucovenguois);
}
db.SaveChanges();
}
}
public static List <DSUCOVENGUOI> GetAllSUCOVENGUOI()
{
using (FDBContext context = new FDBContext())
{
return(context.DSUCOVENGUOI.OrderByDescending(x => x.ID).ToList());
}
}
public static List <DSUCOVENGUOI> GetSUCOVENGUOIByID(int?id)
{
using (FDBContext context = new FDBContext())
{
return(context.KT_THIETHAIKHAITHAC.Where(x => x.ID == id).First().SUCOVENGUOI.OrderByDescending(x => x.ID).ToList());
}
}
public void initialCategorySearchAction()
{
var db = new FDBContext();
ViewBag.DTINHTPs = new SelectList(db.DTINHTP, "MA_TINHTP", "TEN_TINHTP");
}
private void Sum(ViewModelSearchKT_THIETHAIKHAITHAC SearchModel)
{
using (var ctx = new FDBContext())
{
//using (var cmd = ctx.Database.Connection.CreateCommand())
//{
// ctx.Database.Connection.Open();
var ListSuCoTAU = ctx.Database.SqlQuery <KT_SUCOVETAU>("exec KT_THIETHAIKHAITHAC_SUCOTAU @fromdate, @todate "
, new SqlParameter("@fromdate", SearchModel.TU_NGAY == null ? (object)DBNull.Value : SearchModel.TU_NGAY.Value)
, new SqlParameter("@todate", SearchModel.DEN_NGAY == null ? (object)DBNull.Value : SearchModel.DEN_NGAY.Value)
).ToList();
ViewBag.CountSuCoTAU = ListSuCoTAU;
var ListSuCoNGUOI = ctx.Database.SqlQuery <KT_SUCOVENGUOI>("exec KT_THIETHAIKHAITHAC_SUCONGUOI @fromdate, @todate "
, new SqlParameter("@fromdate", SearchModel.TU_NGAY == null ? (object)DBNull.Value : SearchModel.TU_NGAY.Value)
, new SqlParameter("@todate", SearchModel.DEN_NGAY == null ? (object)DBNull.Value : SearchModel.DEN_NGAY.Value)
).ToList();
ViewBag.CountSuCoNGUOI = ListSuCoNGUOI;
//const string selectCmd = @" select top 1 sum(THIETHAI_UOCTINH) as [tong_thiet_hai] from KT_THIETHAIKHAITHAC where (@fromdate is null or TG_GAPNAN >= @fromdate) and (@todate is null or TG_GAPNAN <= @todate) ";
var tong_thiethai = ctx.Database.SqlQuery <KT_SUCOVETAU>("exec KT_THIETHAIKHAITHAC_TONG @fromdate, @todate "
, new SqlParameter("@fromdate", SearchModel.TU_NGAY == null ? (object)DBNull.Value : SearchModel.TU_NGAY.Value)
, new SqlParameter("@todate", SearchModel.DEN_NGAY == null ? (object)DBNull.Value : SearchModel.DEN_NGAY.Value)
).FirstOrDefault();
ViewBag.tongthiethai = tong_thiethai.tong_thiet_hai == null?string.Empty :tong_thiethai.tong_thiet_hai.Value.ToString("#,###");
//}
}
}
//public static List<KT_THIETHAIKHAITHAC> GetAll()
//{
// using (FDBContext context = new FDBContext())
// {
// var kt_thiethaikhaithacs = context.KT_THIETHAIKHAITHAC.Include(x => x.SUCOVETAU ).OrderBy(x => x.ID).ToList();
// var kt_thiethaikhaithac = context.KT_THIETHAIKHAITHAC.ToList();
// return kt_thiethaikhaithacs;
// }
//}
public static KT_THIETHAIKHAITHAC GetByID(int?id)
{
using (FDBContext context = new FDBContext())
{
var kt_thiethai = context.KT_THIETHAIKHAITHAC.Include(x => x.SUCOVETAU).Include(x => x.SUCOVENGUOI).Where(x => x.ID == id).First();
return(kt_thiethai);
}
}
public static void Delete(int?id)
{
using (FDBContext db = new FDBContext())
{
var kt_thiethaikhaithac = db.KT_THIETHAIKHAITHAC.Where(x => x.ID == id).First();
db.KT_THIETHAIKHAITHAC.Remove(kt_thiethaikhaithac);
db.SaveChanges();
}
}
public JsonResult getAllKT_KHUBAOTON()
{
List <KT_KHUBAOTON> allKHUBAOTON = new List <KT_KHUBAOTON>();
// Here "MyDatabaseEntities " is dbContext, which is created at time of model creation.
db = new FDBContext();
allKHUBAOTON = db.KT_KHUBAOTON.ToList();
return(new JsonResult {
Data = allKHUBAOTON, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Login(Restoran user)
{
using (FDBContext fdb2 = new FDBContext())
{
var usr = fdb2.Restoran.SingleOrDefault(u => u.ImeRest == user.ImeRest && u.Passw == user.Passw);
if (usr != null)
{
Session["UserId"] = usr.RestId.ToString();
Session["Username"] = usr.ImeRest.ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Korisničko ime ili lozinka su pogrešni!");
}
}
return(View());
}
public static void Add(string so_dk_tau, int?so_thuyenvien, string khuvuc_gapnan, DateTime?tg_gannan, List <int> sucovetau, List <int> sucovenguoi, string coquanxuly, decimal?thiethai_uoctinh, string vido, string kinhdo, string tau_khac, string nguoi_khac, int?chet, int?mattich)
{
using (FDBContext db = new FDBContext())
{
var kt_thiethaikhaithac = new KT_THIETHAIKHAITHAC()
{
SO_DK_TAU = so_dk_tau,
SO_THUYENVIEN = so_thuyenvien,
KHUVUC_GAPNAN = khuvuc_gapnan,
TG_GAPNAN = tg_gannan,
COQUAN_XULY = coquanxuly,
THIETHAI_UOCTINH = thiethai_uoctinh,
VIDO = vido,
KINHDO = kinhdo,
TAU_KHAC = tau_khac,
NGUOI_KHAC = nguoi_khac,
SO_NGUOI_CHET = chet,
SO_NGUOI_MAT_TICH = mattich
};
//sucovetau
foreach (var sucovetauID in sucovetau)
{
var sucovetaus = db.DSUCOVETAU.Find(sucovetauID);
kt_thiethaikhaithac.SUCOVETAU.Add(sucovetaus);
}
//sucovenguoi
foreach (var sucovenguoiID in sucovenguoi)
{
var sucovenguois = db.DSUCOVENGUOI.Find(sucovenguoiID);
kt_thiethaikhaithac.SUCOVENGUOI.Add(sucovenguois);
}
db.KT_THIETHAIKHAITHAC.Add(kt_thiethaikhaithac);
db.SaveChanges();
}
}
