public bool SaveDMQLConnectQL(List <QuanLy> quanLies, DMQuanLy dMQuanLies)
{
using (DbContextTransaction transaction = Context.Database.BeginTransaction())
{
try
{
long seq = DMQLConnectQLDAO.GetDMQLConnectQLSEQ();
foreach (QuanLy data in quanLies)
{
#region chuẩn bị dữ liệu cho DMQLConnectQL
//Khi insert Quan Lý thì Quản Lý sẽ thuộc một Danh mục quản lý được chọn trước đó.
//Đảm bảo rằng khi thay đổi năm quyết toán của QuanLy thì dữ liệu quyết toán năm cũ không thay đổi.
DMQLConnectQL dMQLConnectQL = new DMQLConnectQL();
dMQLConnectQL.DMQuanLyID = dMQuanLies.DMQuanLyID;
dMQLConnectQL.QLID = data.QLID;
dMQLConnectQL.QLMa = data.QLMa;
dMQLConnectQL.QLTen = data.QLTen;
dMQLConnectQL.QLNamQT = data.QLNamQT;
dMQLConnectQL.QLNgayHopDong = data.QLNgayHopDong;
dMQLConnectQL.QLSoHopDong = data.QLSoHopDong;
dMQLConnectQL.QLSoLuongHD = data.QLSoLuongHD;
dMQLConnectQL.QLDoanhThu = data.QLDoanhThu;
dMQLConnectQL.QLVAT = data.QLVAT;
dMQLConnectQL.QLNgayKhoiCong = data.QLNgayKhoiCong;
dMQLConnectQL.QLNgayKetThuc = data.QLNgayKetThuc;
dMQLConnectQL.QLHopDong = data.QLHopDong;
dMQLConnectQL.QLDuToan = data.QLDuToan;
dMQLConnectQL.QLQuyetToan = data.QLQuyetToan;
dMQLConnectQL.QLKLHoanThanh = data.QLKLHoanThanh;
dMQLConnectQL.QLBBNghiemThu = data.QLBBNghiemThu;
dMQLConnectQL.QLBBThanhLy = data.QLBBThanhLy;
dMQLConnectQL.QLHSChuan = data.QLHSChuan;
dMQLConnectQL.QLNhatKy = data.QLNhatKy;
dMQLConnectQL.QLYCBoSung = data.QLYCBoSung;
dMQLConnectQL.QLNo = data.QLNo;
dMQLConnectQL.QLStatus = data.QLStatus;
dMQLConnectQL.UserCreate = UserInfo.UserID;
dMQLConnectQL.CompanyID = CommonInfo.CompanyInfo.CompanyID;
#endregion chuẩn bị dữ liệu cho DMQLConnectQL
seq++;
dMQLConnectQL.DMQLConnectQLID = GenerateID.DMQLConnectQLID(seq);
this.DMQLConnectQLDAO.InsertDMQLConnectQL(dMQLConnectQL);
}
transaction.Commit();
return(true);
}
catch (Exception e)
{
transaction.Rollback();
Console.WriteLine("Update data fail.\r\n" + e.Message);
return(false);
}
}
}
public bool DeleteDMQLConnectQL(DMQLConnectQL data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@DMQLConnectQLID", data.DMQLConnectQLID),
new SqlParameter("@UserCreate", UserInfo.UserID),
new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
};
this.Context.ExecuteDataFromProcedure("DMQLConnectQLDELETE", sqlParameters);
return(true);
}
//UpdateDMQLConnectQL
public bool UpdateDMQLConnectQL(DMQLConnectQL dMQLConnectQL)
{
using (DbContextTransaction transaction = Context.Database.BeginTransaction())
{
try
{
switch (dMQLConnectQL.Status)
{
// update
case ModifyMode.Update:
this.DMQLConnectQLDAO.UpdateDMQLConnectQL(dMQLConnectQL);
break;
}
transaction.Commit();
return(true);
}
catch (Exception e)
{
transaction.Rollback();
Console.WriteLine("Update data fail.\r\n" + e.Message);
return(false);
}
}
}
public bool UpdateDMQLConnectQL(DMQLConnectQL data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@DMQLConnectQLID", data.DMQLConnectQLID),
new SqlParameter("@DMQuanLyID", data.DMQuanLyID),
new SqlParameter("@QLID", data.QLID),
new SqlParameter("@QLMa", data.QLMa),
new SqlParameter("@QLTen", data.QLTen),
new SqlParameter("@QLNamQT", data.QLNamQT),
new SqlParameter("@QLNgayHopDong", data.QLNgayHopDong),
new SqlParameter("@QLSoHopDong", data.QLSoHopDong),
new SqlParameter("@QLSoLuongHD", data.QLSoLuongHD),
new SqlParameter("@QLDoanhThu", data.QLDoanhThu),
new SqlParameter("@QLVAT", data.QLVAT),
new SqlParameter("@QLNgayKhoiCong", data.QLNgayKhoiCong),
new SqlParameter("@QLNgayKetThuc", data.QLNgayKetThuc),
new SqlParameter("@QLHopDong", data.QLHopDong),
new SqlParameter("@QLDuToan", data.QLDuToan),
new SqlParameter("@QLQuyetToan", data.QLQuyetToan),
new SqlParameter("@QLKLHoanThanh", data.QLKLHoanThanh),
new SqlParameter("@QLBBNghiemThu", data.QLBBNghiemThu),
new SqlParameter("@QLBBThanhLy", data.QLBBThanhLy),
new SqlParameter("@QLHSChuan", data.QLHSChuan),
new SqlParameter("@QLNhatKy", data.QLNhatKy),
new SqlParameter("@QLYCBoSung", data.QLYCBoSung),
new SqlParameter("@QLNo", data.QLNo),
new SqlParameter("@QLStatus", data.QLStatus),
new SqlParameter("@UserCreate", UserInfo.UserID),
new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
};
this.Context.ExecuteDataFromProcedure("DMQLConnectQLUPDATE", sqlParameters);
return(true);
}
public bool UpdateDMQLConnectQL(DMQLConnectQL dMQLConnectQLs)
{
return(this.DMQLConnectQLLogic.UpdateDMQLConnectQL(dMQLConnectQLs));
}
public bool SaveQuanLy(QuanLy data, DMQuanLy dMQuanLy, int status)
{
#region chuẩn bị dữ liệu cho DMQLConnectQL
//Khi insert Quan Lý thì Quản Lý sẽ thuộc một Danh mục quản lý được chọn trước đó.
//Đảm bảo rằng khi thay đổi năm quyết toán của QuanLy thì dữ liệu quyết toán năm cũ không thay đổi.
DMQLConnectQL dMQLConnectQL = new DMQLConnectQL
{
DMQuanLyID = dMQuanLy.DMQuanLyID,
QLMa = data.QLMa,
QLTen = data.QLTen,
QLNamQT = data.QLNamQT,
QLNgayHopDong = data.QLNgayHopDong,
QLSoHopDong = data.QLSoHopDong,
QLSoLuongHD = data.QLSoLuongHD,
QLDoanhThu = data.QLDoanhThu,
QLVAT = data.QLVAT,
QLNgayKhoiCong = data.QLNgayKhoiCong,
QLNgayKetThuc = data.QLNgayKetThuc,
QLHopDong = data.QLHopDong,
QLDuToan = data.QLDuToan,
QLQuyetToan = data.QLQuyetToan,
QLKLHoanThanh = data.QLKLHoanThanh,
QLBBNghiemThu = data.QLBBNghiemThu,
QLBBThanhLy = data.QLBBThanhLy,
QLHSChuan = data.QLHSChuan,
QLNhatKy = data.QLNhatKy,
QLYCBoSung = data.QLYCBoSung,
QLNo = 1,
QLStatus = data.QLStatus,
UserCreate = UserInfo.UserID,
CompanyID = CommonInfo.CompanyInfo.CompanyID
};
#endregion chuẩn bị dữ liệu cho DMQLConnectQL
using (DbContextTransaction transaction = Context.Database.BeginTransaction())
{
try
{
long seq = QuanLyDAO.GetQuanLySEQ();
long seqConnect = DMQLConnectQLDAO.GetDMQLConnectQLSEQ();
switch (data.Status)
{
// Add new
case ModifyMode.Insert:
seq++;
data.QLID = GenerateID.QuanLyID(seq);
this.QuanLyDAO.InsertQuanLy(data);
//after insert QuanLy was successfull then insert DMQuanLyConnectQuanLy
seqConnect++;
dMQLConnectQL.DMQLConnectQLID = GenerateID.DMQLConnectQLID(seqConnect);
dMQLConnectQL.QLID = data.QLID;
this.DMQLConnectQLDAO.InsertDMQLConnectQL(dMQLConnectQL);
break;
// Update
case ModifyMode.Update:
this.QuanLyDAO.UpdateQuanLy(data, status);
break;
// Delete
case ModifyMode.Delete:
this.QuanLyDAO.DeleteQuanLy(data);
break;
}
transaction.Commit();
return(true);
}
catch (Exception e)
{
transaction.Rollback();
Console.WriteLine("Update data fail.\r\n" + e.Message);
return(false);
}
}
}
