public JsonResult SaveDuyetChuyenTrungTam(int?A_THDUBAO, int?IDDuyet, string NoiDung)
{
int sc = 0;
try
{
TH_DUYETTHUCHIEN New = new TH_DUYETTHUCHIEN()
{
J_TH_DUBAO = A_THDUBAO,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(New);
sc += db.SaveChanges();
if (sc > 0)
{
sc += db.Database.ExecuteSqlCommand("Update TH_DUBAO set ID_LYDO_TD = 1241 where A_TH_DUBAO =" + A_THDUBAO);
}
return(Json(sc, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveDuyetHuyDangKy(int?A_THHOPDONG, int?IDDuyet, string NoiDung)
{
int sc = 0;
try
{
TH_DUYETTHUCHIEN New = new TH_DUYETTHUCHIEN()
{
J_TH_HOPDONG = A_THHOPDONG,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(New);
sc += db.SaveChanges();
return(Json(sc, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveDuyetChuyenPhi(int?A_THDUBAO, int?IDDuyet, string NoiDung, int?Buoi1, int?Buoi2, int?KhuVuc, int?A_DuBao_XepLopChuyen, int?A_DuBao_XepLopNhan)
{
int sc = 0;
try
{
TH_DUBAO model = db.TH_DUBAO.FirstOrDefault(it => it.A_THUCHIEN == A_THDUBAO); //hoc sinh nhan phi
TH_DUBAO model1 = db.TH_DUBAO.FirstOrDefault(it => it.A_TH_DUBAO == A_THDUBAO); //hoc sinh chuyen phi
if (model1 != null)
{
//them duyet vao hoc sinh chuyen
TH_DUYETTHUCHIEN New = new TH_DUYETTHUCHIEN()
{
J_TH_DUBAO = A_THDUBAO,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(New);
sc += db.SaveChanges();
if (sc > 0)
{
sc += db.Database.ExecuteSqlCommand("Update TH_DUBAO set ID_LYDO_TD = 242 where A_TH_DUBAO =" + A_THDUBAO);
}
//them duyet vao hoc sinh nhan
TH_DUYETTHUCHIEN New1 = new TH_DUYETTHUCHIEN()
{
J_TH_DUBAO = model.A_TH_DUBAO,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(New1);
sc += db.SaveChanges();
if (sc > 1)
{
sc += db.Database.ExecuteSqlCommand("Update TH_DUBAO set ID_LYDO_TD = 242 where A_TH_DUBAO =" + model.A_TH_DUBAO);
}
if (IDDuyet == 1)
{
//update vao du bao xep lop hoc sinh chuyen
TH_DUBAO HSChuyen = db.TH_DUBAO.FirstOrDefault(it => it.A_TH_DUBAO == A_DuBao_XepLopChuyen);
HSChuyen.NGAYTHANHTOAN = model1.NGAYTHANHTOAN;
HSChuyen.SOBUOI = HSChuyen.SOBUOI - model1.SOBUOI;
HSChuyen.TONGTIEN_DH = HSChuyen.TONGTIEN_DH - model1.TONGTIEN_DH;
HSChuyen.ID_TRANGTHAI = 1;
db.Entry(HSChuyen).State = EntityState.Modified;
sc += db.SaveChanges();
//update dubao_sanphamn cho don hang chuyen phi
TH_DUBAO_SANPHAM THDBSPChuyen = db.TH_DUBAO_SANPHAM.FirstOrDefault(k => k.J_TH_DUBAO == A_DuBao_XepLopChuyen);
THDBSPChuyen.SOLUONG = THDBSPChuyen.SOLUONG - (decimal)model1.SOBUOI;
THDBSPChuyen.THANHTIEN = THDBSPChuyen.THANHTIEN - model1.TONGTIEN_DH;
db.Entry(THDBSPChuyen).State = EntityState.Modified;
sc += db.SaveChanges();
//update vao du bao xep lop cua hoc sinh nhan
TH_DUBAO HSNhan = db.TH_DUBAO.FirstOrDefault(it => it.A_TH_DUBAO == A_DuBao_XepLopNhan);
HSNhan.NGAYTHANHTOAN = HSNhan.J_KEHOACH != null?model1.NGAYTHANHTOAN:null;
HSNhan.SOBUOI = HSNhan.SOBUOI + model.SOBUOI;
HSNhan.TONGTIEN_DH = HSNhan.TONGTIEN_DH + model1.TONGTIEN_DH;
db.Entry(HSNhan).State = EntityState.Modified;
sc += db.SaveChanges();
TH_DUBAO_SANPHAM THDBSPNhan = db.TH_DUBAO_SANPHAM.FirstOrDefault(k => k.J_TH_DUBAO == A_DuBao_XepLopNhan);
THDBSPNhan.SOLUONG = THDBSPNhan.SOLUONG + (decimal)model.SOBUOI;
THDBSPNhan.THANHTIEN = THDBSPNhan.THANHTIEN + model1.TONGTIEN_DH;
db.Entry(THDBSPNhan).State = EntityState.Modified;
sc += db.SaveChanges();
}
}
return(Json(sc, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveDuyetChuyenLop(int?A_THDUBAO, int?IDDuyet, string NoiDung)
{
int sc = 0;
try
{
//lớp cũ
var modelLopCu = db.TH_DUBAO.FirstOrDefault(t => t.A_TH_DUBAO == A_THDUBAO);
var a_th_dubao_lopcu = modelLopCu.A_TH_DUBAO;
TH_DUYETTHUCHIEN OldClass = new TH_DUYETTHUCHIEN()
{
J_TH_DUBAO = a_th_dubao_lopcu,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(OldClass);
sc += db.SaveChanges();
if (sc > 0)
{
sc += db.Database.ExecuteSqlCommand("Update TH_DUBAO set ID_LYDO_TD = 242 where A_TH_DUBAO =" + a_th_dubao_lopcu);
}
//lớp mới
var modelDuBaoLopMoi = db.TH_DUBAO.FirstOrDefault(t => t.A_THUCHIEN == A_THDUBAO);
var a_th_dubao_lopmoi = modelDuBaoLopMoi.A_TH_DUBAO;
TH_DUYETTHUCHIEN NewClass = new TH_DUYETTHUCHIEN()
{
J_TH_DUBAO = a_th_dubao_lopmoi,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(NewClass);
sc += db.SaveChanges();
if (sc > 0)
{
sc += db.Database.ExecuteSqlCommand("Update TH_DUBAO set ID_LYDO_TD = 242 where A_TH_DUBAO =" + a_th_dubao_lopmoi);
}
if (IDDuyet == 1)
{
//Update dubao xếp lớp
var modelDuBaoXepLopCu = db.TH_DUBAO.FirstOrDefault(
t => t.ID_LYDO_HV == 97 &&
t.ID_LYDO_TD == 238 &&
t.J_KEHOACH == modelLopCu.J_KEHOACH &&
t.J_HOSOKHACHHANG == modelLopCu.J_HOSOKHACHHANG);
if (modelDuBaoXepLopCu != null)
{
var sobuoiconlaithucte = modelDuBaoXepLopCu.SOBUOI - modelLopCu.SOBUOI;
modelDuBaoXepLopCu.SOBUOI = sobuoiconlaithucte;
modelDuBaoXepLopCu.TONGTIEN_DH = sobuoiconlaithucte * modelDuBaoXepLopCu.DONGIA;
modelDuBaoXepLopCu.NGAYTHANHTOAN = modelLopCu.NGAYTHANHTOAN;
sc += db.SaveChanges();
var modelDuBaoSanPhamXepLop = db.TH_DUBAO_SANPHAM.FirstOrDefault(t => t.J_TH_DUBAO == modelDuBaoXepLopCu.A_TH_DUBAO);
modelDuBaoSanPhamXepLop.SOLUONG = decimal.Parse(sobuoiconlaithucte.ToString());
modelDuBaoSanPhamXepLop.THANHTIEN = sobuoiconlaithucte * modelDuBaoXepLopCu.DONGIA;
sc += db.SaveChanges();
}
//Insert dubao xếp lớp mới
db.TH_DUBAO.Add(new TH_DUBAO()
{
J_HOSOKHACHHANG = modelDuBaoLopMoi.J_HOSOKHACHHANG,
J_KEHOACH = modelDuBaoLopMoi.J_KEHOACH,
J_TH_HOPDONG = modelDuBaoLopMoi.J_TH_HOPDONG,
SOBUOI = modelDuBaoLopMoi.SOBUOI,
DONGIA = modelDuBaoLopMoi.DONGIA,
TONGTIEN_DH = modelDuBaoLopMoi.TONGTIEN_DH,
NGAYLAM = DateTime.Now,
NGAYGIAOHANG = modelDuBaoLopMoi.NGAYGIAOHANG,
NGAYTHANHTOAN = modelDuBaoLopMoi.NGAYTHANHTOAN,
ID_DTTC = clsFunctions.GetUserID(),
ID_LYDO_HV = 97,
ID_LYDO_TD = 238,
TK_EC = modelDuBaoXepLopCu.TK_EC,
TK_EC_LEADER = modelDuBaoXepLopCu.TK_EC_LEADER,
TK_CM = modelDuBaoXepLopCu.TK_CM,
TK_CM_LEADER = modelDuBaoXepLopCu.TK_CM_LEADER,
TK_GDTT = modelDuBaoXepLopCu.TK_GDTT,
TK_GDV = modelDuBaoXepLopCu.TK_GDV,
SODONHANG = "1111",
});
sc += db.SaveChanges();
var a_th_dubao_xeplopmoi = db.TH_DUBAO.OrderByDescending(t => t.A_TH_DUBAO).FirstOrDefault().A_TH_DUBAO;
db.TH_DUBAO_SANPHAM.Add(new TH_DUBAO_SANPHAM()
{
J_TH_DUBAO = a_th_dubao_xeplopmoi,
J_SANPHAM = db.TH_DUBAO_SANPHAM.FirstOrDefault(t => t.J_TH_DUBAO == modelDuBaoLopMoi.A_TH_DUBAO).J_SANPHAM,
SOLUONG = decimal.Parse(modelDuBaoLopMoi.SOBUOI.ToString()),
DONGIA = modelDuBaoLopMoi.DONGIA,
THANHTIEN = modelDuBaoLopMoi.TONGTIEN_DH
});
sc += db.Database.ExecuteSqlCommand("Update TH_HOSOKHACHHANG set SOBUOIHOC = " + modelDuBaoLopMoi.SOBUOI + " where A_HOSOKHACHHANG = " + modelDuBaoLopMoi.J_HOSOKHACHHANG);
sc += db.SaveChanges();
}
return(Json(sc, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveDuyetXepLop(int?A_THDUBAO, int?IDDuyet, string NoiDung)
{
int sc = 0;
try
{
TH_DUYETTHUCHIEN New = new TH_DUYETTHUCHIEN()
{
J_TH_DUBAO = A_THDUBAO,
ID_DTTC = clsFunctions.GetUserID(),
NGAYDUYET = DateTime.Now,
ID_DUYET = IDDuyet,
YKIENBOSUNG = NoiDung
};
db.Set <TH_DUYETTHUCHIEN>().Add(New);
sc += db.SaveChanges();
if (sc > 0)
{
sc += db.Database.ExecuteSqlCommand("Update TH_DUBAO set ID_LYDO_TD = 242 where A_TH_DUBAO =" + A_THDUBAO);
TH_DUBAO model = db.TH_DUBAO.FirstOrDefault(it => it.A_TH_DUBAO == A_THDUBAO);
if (sc > 1 && IDDuyet == 1 && model != null)
{
TH_DUBAO Moi = new TH_DUBAO()
{
J_KEHOACH = model.J_KEHOACH,
J_TH_HOPDONG = model.J_TH_HOPDONG,
J_HOSOKHACHHANG = model.J_HOSOKHACHHANG,
SOBUOI = model.SOBUOI,
NGAYLAM = DateTime.Now,
NGAYGIAOHANG = model.NGAYGIAOHANG,
NGAYTHANHTOAN = model.NGAYTHANHTOAN,
ID_LYDO_HV = 97,
ID_LYDO_TD = 238,
SODONHANG = "123",
ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
TK_EC = model.TK_EC,
TK_EC_LEADER = model.TK_EC_LEADER,
TK_CM = model.TK_CM,
TK_CM_LEADER = model.TK_CM_LEADER,
TK_GDTT = model.TK_GDTT,
TK_GDV = model.TK_GDV,
ID_TRUNGTAM_DI = model.ID_TRUNGTAM_DI,
ID_TRUNGTAM_DEN = model.ID_TRUNGTAM_DEN,
DULIEUNHOM = true
};
db.Set <TH_DUBAO>().Add(Moi);
sc += db.SaveChanges();
if (sc > 2)
{
int th_dubao = db.TH_DUBAO.OrderByDescending(x => x.A_TH_DUBAO).FirstOrDefault().A_TH_DUBAO;
TH_DUBAO_SANPHAM dbsp = db.TH_DUBAO_SANPHAM.FirstOrDefault(it => it.J_TH_DUBAO == A_THDUBAO);
TH_DUBAO_SANPHAM newdubaosp = new TH_DUBAO_SANPHAM()
{
J_TH_DUBAO = th_dubao,
J_SANPHAM = dbsp.J_SANPHAM,
SOLUONG = dbsp.SOLUONG,
DONGIA = dbsp.DONGIA,
THANHTIEN = dbsp.DONGIA
};
db.Set <TH_DUBAO_SANPHAM>().Add(newdubaosp);
sc += db.SaveChanges();
}
}
}
return(Json(sc, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
