public HaoPhi_User_ViewModel(ThanhPhanHaoPhi obj)
{
MaHP = obj.MaHP;
MaHieuCV_User = obj.MaHieuCV_User;
Ten = obj.Ten;
DonVi = obj.DonVi;
Gia = obj.Gia;
}
public ActionResult FormSubmit(FormCollection form)
{
if (SessionHandler.User == null)
{
return(RedirectToAction("Login", "Account"));
}
var txtmacongtrinh = form["txt_ma_congtrinh"];
var txtmahangmuc = form["txt_ma_hangmuc"];
var txttenhangmuc = form["txt_ten_hangmuc"];
var txtmahieucv_dmArr = form["txtmahieucv_dm[]"].Split(',');
var txttencvArr = form["txttencv[]"].Split(',');
var txtdonviArr = form["txtdonvi[]"].Split(',');
var txtkhoiluongArr = form["txtkhoiluong[]"].Split(',');
var txtgiavlArr = form["txtgiavl[]"].Split(',');
var txtgiancArr = form["txtgianc[]"].Split(',');
var txtgiamtcArr = form["txtgiamtc[]"].Split(',');
var txtthanhtiencArr = form["txtthanhtien[]"].Split(',');
var txttongtien = form["txt_tongtien"];
if (txtmacongtrinh != "")
{
if (txtmahangmuc == "") //tao hang muc, bao gom cong viec moi
{
//lay dong cuoi cung bang hangmuc
var mahm_last = _db.HangMucs.OrderByDescending(i => i.MaHM).Select(i => i.MaHM).FirstOrDefault();
var mahm_now = (dynamic)null;
int d_hm = 0;
if (mahm_last != null)
{
mahm_now = mahm_last.ToString().Substring(2, mahm_last.ToString().Length - 2);
d_hm = Convert.ToInt32(mahm_now.ToString());
mahm_now = "HM" + Convert.ToString(d_hm + 1);
}
else
{
mahm_now = "HM1";
}
HangMuc hm = new HangMuc();
hm.MaHM = mahm_now;
hm.MaCT = txtmacongtrinh;
hm.TenHM = txttenhangmuc;
hm.MoTa = "";
hm.Gia = Convert.ToDecimal(txttongtien);
_db.HangMucs.InsertOnSubmit(hm);
//lay dong cuoi cung bang congviec
var macv_last = _db.CongViecs.OrderByDescending(i => i.MaHieuCV_User).Select(i => i.MaHieuCV_User).FirstOrDefault();
var macv_now = (dynamic)null;
int d_cv = 0;
if (macv_last != null)
{
macv_now = macv_last.ToString().Substring(3, macv_last.ToString().Length - 3);
d_cv = Convert.ToInt32(macv_now.ToString());
}
else
{
d_cv = 0;
}
//lay dong cuoi cung bang thanhphanhaophi
var mahp_last = _db.ThanhPhanHaoPhis.OrderByDescending(o => o.MaHP).Select(o => o.MaHP).FirstOrDefault();
var mahp_now = (dynamic)null;
int d_hp = 0;
if (mahp_last != null)
{
mahp_now = mahp_last.ToString().Substring(4, mahp_last.ToString().Length - 4);
d_hp = Convert.ToInt32(mahp_now.ToString());
}
else
{
d_hp = 0;
}
for (int i = 0; i < txtmahieucv_dmArr.Length; i++)
{
macv_now = "CV_" + Convert.ToString(d_cv + 1);
CongViec cv_user = new CongViec();
cv_user.MaHM = mahm_now;
cv_user.MaHieuCV_User = macv_now;
cv_user.MaHieuCV_DM = txtmahieucv_dmArr[i];
cv_user.TenCongViec = txttencvArr[i];
cv_user.DonVi = txtdonviArr[i];
cv_user.KhoiLuong = Convert.ToDecimal(txtkhoiluongArr[i]);
cv_user.GiaVL = Convert.ToDecimal(txtgiavlArr[i]);
cv_user.GiaNC = Convert.ToDecimal(txtgiancArr[i]);
cv_user.GiaMTC = Convert.ToDecimal(txtgiamtcArr[i]);
cv_user.ThanhTien = Convert.ToDecimal(txtthanhtiencArr[i]);
//insert thanh phan hao phi
var list_haophi = (from ct in _db.ChiTiet_DinhMucs
join dg in _db.DonGias on ct.MaVL_NC_MTC equals
dg.MaVL_NC_MTC
where ct.MaHieuCV_DM.Equals(cv_user.MaHieuCV_DM)
select new HaoPhi_DM_ViewModel()
{
Ma = ct.MaVL_NC_MTC,
Ten = dg.Ten,
DonVi = dg.DonVi,
Gia = dg.Gia * ct.SoLuong
}).ToList();
foreach (var k in list_haophi)
{
if (k.Ma.ToString().Substring(0, 1) == "V")
{
mahp_now = "V_HP" + Convert.ToString(d_hp + 1);
}
if (k.Ma.ToString().Substring(0, 1) == "N")
{
mahp_now = "N_HP" + Convert.ToString(d_hp + 1);
}
if (k.Ma.ToString().Substring(0, 1) == "M")
{
mahp_now = "M_HP" + Convert.ToString(d_hp + 1);
}
ThanhPhanHaoPhi hp = new ThanhPhanHaoPhi();
hp.MaHP = mahp_now;
hp.MaHieuCV_User = macv_now;
hp.Ten = k.Ten;
hp.DonVi = k.DonVi;
hp.Gia = k.Gia;
d_hp = d_hp + 1;
_db.ThanhPhanHaoPhis.InsertOnSubmit(hp);
}
d_cv = d_cv + 1;
_db.CongViecs.InsertOnSubmit(cv_user);
}
}
else
{
//delete cong viec trong hang muc
var congviecs = _db.CongViecs.Where(i => i.MaHM.Equals(txtmahangmuc));
_db.CongViecs.DeleteAllOnSubmit(congviecs);
var macongviecs = _db.CongViecs.Where(i => i.MaHM.Equals(txtmahangmuc)).Select(i => i.MaHieuCV_User).ToList();
var haophis = _db.ThanhPhanHaoPhis.Where(i => macongviecs.Contains(i.MaHieuCV_User));
_db.ThanhPhanHaoPhis.DeleteAllOnSubmit(haophis);
_db.SubmitChanges();
//lay dong cuoi cung bang congviec
var macv_last = _db.CongViecs.OrderByDescending(i => i.MaHieuCV_User).Select(i => i.MaHieuCV_User).FirstOrDefault();
var macv_now = (dynamic)null;
int d_cv = 0;
if (macv_last != null)
{
macv_now = macv_last.ToString().Substring(3, macv_last.ToString().Length - 3);
d_cv = Convert.ToInt32(macv_now.ToString());
}
else
{
d_cv = 0;
}
//lay dong cuoi cung bang thanhphanhaophi
var mahp_last = _db.ThanhPhanHaoPhis.OrderByDescending(o => o.MaHP).Select(o => o.MaHP).FirstOrDefault();
var mahp_now = (dynamic)null;
int d_hp = 0;
if (mahp_last != null)
{
mahp_now = mahp_last.ToString().Substring(4, mahp_last.ToString().Length - 4);
d_hp = Convert.ToInt32(mahp_now.ToString());
}
else
{
d_hp = 0;
}
for (int i = 0; i < txtmahieucv_dmArr.Length; i++)
{
macv_now = "CV_" + Convert.ToString(d_cv + 1);
CongViec cv_user = new CongViec();
cv_user.MaHM = txtmahangmuc;
cv_user.MaHieuCV_User = macv_now;
cv_user.MaHieuCV_DM = txtmahieucv_dmArr[i];
cv_user.TenCongViec = txttencvArr[i];
cv_user.DonVi = txtdonviArr[i];
cv_user.KhoiLuong = Convert.ToDecimal(txtkhoiluongArr[i]);
cv_user.GiaVL = Convert.ToDecimal(txtgiavlArr[i]);
cv_user.GiaNC = Convert.ToDecimal(txtgiancArr[i]);
cv_user.GiaMTC = Convert.ToDecimal(txtgiamtcArr[i]);
cv_user.ThanhTien = Convert.ToDecimal(txtthanhtiencArr[i]);
//insert thanh phan hao phi
var list_haophi = (from ct in _db.ChiTiet_DinhMucs
join dg in _db.DonGias on ct.MaVL_NC_MTC equals
dg.MaVL_NC_MTC
where ct.MaHieuCV_DM.Equals(cv_user.MaHieuCV_DM)
select new HaoPhi_DM_ViewModel()
{
Ma = ct.MaVL_NC_MTC,
Ten = dg.Ten,
DonVi = dg.DonVi,
Gia = dg.Gia * ct.SoLuong
}).ToList();
foreach (var k in list_haophi)
{
if (k.Ma.ToString().Substring(0, 1) == "V")
{
mahp_now = "V_HP" + Convert.ToString(d_hp + 1);
}
if (k.Ma.ToString().Substring(0, 1) == "N")
{
mahp_now = "N_HP" + Convert.ToString(d_hp + 1);
}
if (k.Ma.ToString().Substring(0, 1) == "M")
{
mahp_now = "M_HP" + Convert.ToString(d_hp + 1);
}
ThanhPhanHaoPhi hp = new ThanhPhanHaoPhi();
hp.MaHP = mahp_now;
hp.MaHieuCV_User = macv_now;
hp.Ten = k.Ten;
hp.DonVi = k.DonVi;
hp.Gia = k.Gia;
d_hp = d_hp + 1;
_db.ThanhPhanHaoPhis.InsertOnSubmit(hp);
}
d_cv = d_cv + 1;
_db.CongViecs.InsertOnSubmit(cv_user);
}
}
}
_db.SubmitChanges();
return(RedirectToAction("Index", "CongTrinh"));
}