public async Task <JsonResult> Save_PhanQuyen(string ma, string quyen)
{
try
{
var model = await db.DM_DTTC.FirstOrDefaultAsync(it => it.MADTTC.Equals(ma.Trim()));
if (model != null)
{
model.MANGUOIQUANLY = quyen;
db.Entry(model).State = EntityState.Modified;
}
return(Json(await db.SaveChangesAsync(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
public int UpdateChuyenPhi(
int A_HOSOKHACHHANG_CHUYEN,
int?A_KEHOACH_CHUYEN,
int A_HOSOKHACHHANG_NHAN,
int?A_KEHOACH_NHAN,
decimal?SOTIEN,
int?SOBUOICON,
decimal DONGIABUOI,
int?A_SANPHAM_NHAN,
int A_TH_HOPDONG_NHAN,
int?A_SANPHAM_CHUYEN,
int A_TH_HOPDONG_CHUYEN,
DateTime?NGAYBATDAU_CHUYEN,
DateTime?NGAYCHUYEN,
DateTime?NGAYBATDAU_NHAN,
DateTime?NHAYKETTHUC_NHAN,
int?SOBUOINHAN,
decimal?DONGIACHUYEN,
decimal?DONGIANHAN,
decimal?ThanhTien,
int?HinhThucChuyenPhi,
int?A_DUBAO_XEPLOP)
{
try
{
int sc = 0, ec = 0;
APAXEntities3 db = new APAXEntities3();
db.TH_DUBAO.Add(new TH_DUBAO()
{
J_HOSOKHACHHANG = A_HOSOKHACHHANG_CHUYEN,
J_TH_HOPDONG = A_TH_HOPDONG_CHUYEN,
ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
DULIEUNHOM = true,
J_KEHOACH = A_KEHOACH_CHUYEN,
NGAYLAM = DateTime.Now,
NGAYGIAOHANG = NGAYBATDAU_CHUYEN,
NGAYTHANHTOAN = NGAYCHUYEN,
SOBUOI = SOBUOICON,
TONGTIEN_DH = SOTIEN,
ID_LYDO_HV = 99,
ID_THAIDO = HinhThucChuyenPhi,
ID_LYDO_TD = 241
});
sc += db.SaveChanges();
if (sc > 0)
{
int a_th_dubao = 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,
J_SANPHAM = A_SANPHAM_CHUYEN > 0?(int)A_SANPHAM_CHUYEN:0,
SOLUONG = SOBUOICON == null ? 0 : decimal.Parse(SOBUOICON.ToString()),
DONGIA = SOTIEN,
THANHTIEN = SOTIEN * (SOBUOICON == null ? 0 : decimal.Parse(SOBUOICON.ToString())),
});
sc += db.SaveChanges();
if (sc >= 2)
{
db.TH_DUBAO.Add(new TH_DUBAO()
{
J_HOSOKHACHHANG = A_HOSOKHACHHANG_NHAN,
J_TH_HOPDONG = A_TH_HOPDONG_NHAN,
ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
DULIEUNHOM = true,
J_KEHOACH = A_KEHOACH_NHAN,
NGAYLAM = DateTime.Now,
NGAYGIAOHANG = NGAYBATDAU_NHAN,
NGAYTHANHTOAN = NHAYKETTHUC_NHAN,
SOBUOI = SOBUOICON,
TONGTIEN_DH = SOTIEN,
ID_THAIDO = HinhThucChuyenPhi,
ID_LYDO_HV = 1103,
ID_LYDO_TD = 241,
A_THUCHIEN = a_th_dubao
});
ec += db.SaveChanges();
if (ec > 0)
{
int a_th_dubaonhan = 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_dubaonhan,
J_SANPHAM = A_SANPHAM_NHAN > 0?(int)A_SANPHAM_NHAN:0,
SOLUONG = SOBUOINHAN == null ? 0 : decimal.Parse(SOBUOINHAN.ToString()),
DONGIA = DONGIANHAN,
THANHTIEN = DONGIANHAN * (SOBUOINHAN == null ? 0 : decimal.Parse(SOBUOINHAN.ToString())),
});
ec += db.SaveChanges();
TH_DUBAO DUBAO = db.TH_DUBAO.FirstOrDefault(st => st.A_TH_DUBAO == A_DUBAO_XEPLOP);
DUBAO.ID_TRANGTHAI = 1;
db.Entry(DUBAO).State = EntityState.Modified;
sc += db.SaveChanges();
}
}
else
{
return(0);
}
}
//db.TH_THUTIEN.Add(new TH_THUTIEN()
//{
// J_HOSOKHACHHANG = A_HOSOKHACHHANG_NHAN,
// J_TH_HOPDONG = A_TH_HOPDONG_NHAN,
// NGAYTHUTIEN = DateTime.Now,
// SOTIENTHU = SOTIEN,
// ID_LOAIPHIEUTHU = 3,
// ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
// MATHUTIEN = "1111",
// DULIEUNHOM = true
//});
//sc += db.Database.ExecuteSqlCommand("UPDATE dbo.TH_DUBAO SET NGAYTHANHTOAN = GETDATE(), ID_LYDO_TD = 240 WHERE J_HOSOKHACHHANG= '" + A_HOSOKHACHHANG_CHUYEN + "' AND J_KEHOACH = '" + A_KEHOACH_CHUYEN + "'");
//db.SaveChanges();
return(sc);
}
catch
{
return(0);
}
}
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 CapNhatDangKyChuyenLopCungTrungTam(
int J_HOSOKHACHHANG,
int?J_KEHOACH,
DateTime?NGAYGIAOHANG,
decimal?TONGTIEN_DH,
int?SOBUOI,
decimal?DONGIA,
int?ID_BOPHAN,
string GHICHU,
int?J_SANPHAM,
DateTime?NGAYDUKIENHOC,
int?J_HOPDONG,
string TK_EC,
string TK_EC_LEADER,
string TK_CM,
string TK_CM_LEADER,
string TK_GDTT,
string TK_GDV,
int?ID_TRUNGTAM_DI,
int?ID_TRUNGTAM_DEN,
int?A_DuBao
)
{
int sc = 0;
var thdubao = new TH_DUBAO();
thdubao.J_KEHOACH = J_KEHOACH;
thdubao.J_TH_HOPDONG = J_HOPDONG;
thdubao.SOBUOI = SOBUOI;
thdubao.NGAYLAM = DateTime.Now;
thdubao.NGAYGIAOHANG = NGAYDUKIENHOC;
thdubao.NGAYTHANHTOAN = NGAYGIAOHANG != null ? NGAYGIAOHANG : null;
thdubao.ID_LYDO_HV = 101;
thdubao.ID_LYDO_TD = 241;
thdubao.ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name);
thdubao.TK_EC = TK_EC;
thdubao.TK_EC_LEADER = TK_EC_LEADER;
thdubao.TK_CM = TK_CM;
thdubao.TK_CM_LEADER = TK_CM_LEADER;
thdubao.TK_GDTT = TK_GDTT;
thdubao.TK_GDV = TK_GDV;
thdubao.ID_TRUNGTAM_DI = ID_TRUNGTAM_DI;
thdubao.ID_TRUNGTAM_DEN = ID_TRUNGTAM_DEN;
thdubao.J_HOSOKHACHHANG = J_HOSOKHACHHANG;
thdubao.DULIEUNHOM = true;
thdubao.TONGTIEN_DH = TONGTIEN_DH;
thdubao.DONGIA = DONGIA;
thdubao.ID_BOPHAN = ID_BOPHAN;
thdubao.GHICHU = !string.IsNullOrEmpty(GHICHU) ? GHICHU : "";
thdubao.A_THUCHIEN = A_DuBao;
db.TH_DUBAO.Add(thdubao);
sc += db.SaveChanges();
if (sc > 0)
{
int model = db.TH_DUBAO.OrderByDescending(x => x.A_TH_DUBAO).FirstOrDefault().A_TH_DUBAO;
var thdubaosanpham = new TH_DUBAO_SANPHAM();
thdubaosanpham.J_TH_DUBAO = model;
thdubaosanpham.J_SANPHAM = J_SANPHAM > 0 ? (int)J_SANPHAM : 0;
thdubaosanpham.SOLUONG = SOBUOI > 0 ? (int)SOBUOI : 0;
thdubaosanpham.DONGIA = DONGIA;
thdubaosanpham.CHIETKHAU = 0;
thdubaosanpham.THANHTIEN = TONGTIEN_DH;
//thdubaosanpham.DATENOTE1 = NGAYDUKIENHOC != null ? NGAYDUKIENHOC : DateTime.Now;
//thdubaosanpham.DATENOTE2 = NGAYGIAOHANG != null ? NGAYGIAOHANG : DateTime.Now;
db.TH_DUBAO_SANPHAM.Add(thdubaosanpham);
sc += db.SaveChanges();
TH_DUBAO DUBAO = db.TH_DUBAO.FirstOrDefault(st => st.A_TH_DUBAO == A_DuBao);
DUBAO.ID_TRANGTHAI = 1;
db.Entry(DUBAO).State = EntityState.Modified;
sc += db.SaveChanges();
}
if (sc > 0)
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
