public virtual void Remove(int id)
{
try
{
MER_PHULUC_GIAHAN b = this.GetById(id);
this.Remove(b);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Remove(MER_PHULUC_GIAHAN b)
{
try
{
db.MER_PHULUC_GIAHANs.DeleteOnSubmit(b);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(MER_PHULUC_GIAHAN cus)
{
try
{
this.db.MER_PHULUC_GIAHANs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Remove(MER_PHULUC_GIAHAN b)
{
try
{
db.MER_PHULUC_GIAHANs.DeleteOnSubmit(b);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(MER_PHULUC_GIAHAN cus)
{
try
{
this.db.MER_PHULUC_GIAHANs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Update(MER_PHULUC_GIAHAN cus)
{
try
{
MER_PHULUC_GIAHAN cusOld = this.GetById(cus.ID);
cusOld = cus;
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Update(MER_PHULUC_GIAHAN cus)
{
try
{
MER_PHULUC_GIAHAN cusOld = this.GetById(cus.ID);
cusOld = cus;
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
private void Save_Data(string strLink = "")
{
try
{
if (_id == 0)
{
int _idUser = Utils.CIntDef(HttpContext.Current.Request.Cookies["PITM_INFO"]["PITM_USER_ID"]);
MER_PHULUC_GIAHAN i = new MER_PHULUC_GIAHAN();
i.USER_ID = _idUser;
i.MER_POS01 = txtMerPos01.Text.Trim();
i.MER_POS02 = txtMerPos02.Text.Trim();
i.MER_POS03 = txtMerPos03.Text.Trim();
i.MER_POS04 = txtMerPos04.Text.Trim();
i.MER_POS05 = txtMerPos05.Text.Trim();
i.MER_POS06 = txtMerPos06.Text.Trim();
i.MER_POS07 = txtMerPos07.Text.Trim();
i.MER_POS08 = txtMerPos08.Text.Trim();
i.MER_POS09 = txtMerPos09.Text.Trim();
i.MER_POS10 = txtMerPos10.Text.Trim();
i.MER_NAME = ConvertString(txtMerName.Text.ToUpper().Trim());
i.MER_ADDRESS = txtMerAddress.Text.Trim();
i.MER_PHONE = txtMerPhone.Text.Trim();
i.MER_TAXCODE = txtMerTaxCode.Text.Trim();
i.MER_EMAIL = txtMerEmail.Text.Trim();
i.MER_NX = ddlDanhXung.SelectedValue;
string sNguoiDD = ToFirstUpper(txtMerRepresent.Text.Trim());
i.MER_REPRESENT = ConvertStringNDD(sNguoiDD);
i.MER_POSITION = ToFirstUpper(txtMerPosition.Text.Trim());
i.MER_POSBODY01 = txtMerPosBody01.Text.Trim();
i.MER_POSBODY02 = txtMerPosBody02.Text.Trim();
i.MER_POSBODY03 = txtMerPosBody03.Text.Trim();
i.MER_POSBODY04 = txtMerPosBody04.Text.Trim();
i.MER_POSBODY05 = txtMerPosBody05.Text.Trim();
i.MER_POSBODY06 = txtMerPosBody06.Text.Trim();
i.MER_POSBODY07 = txtMerPosBody07.Text.Trim();
i.MER_POSBODY08 = txtMerPosBody08.Text.Trim();
i.MER_POSBODY09 = txtMerPosBody09.Text.Trim();
i.MER_POSBODY10 = txtMerPosBody10.Text.Trim();
i.MER_COST_TITLE = txtMerCostTitle.Text.Trim();
i.MER_COST_DETAIL = txtMerCostDetail.Text.Trim();
i.MER_POSFO01 = txtMerPosFo01.Text.Trim();
i.MER_POSFO02 = txtMerPosFo02.Text.Trim();
i.MER_POSFO03 = txtMerPosFo03.Text.Trim();
i.MER_POSFO04 = txtMerPosFo04.Text.Trim();
i.MER_POSFO05 = txtMerPosFo05.Text.Trim();
i.MER_POSFO06 = txtMerPosFo06.Text.Trim();
i.MER_POSFO07 = txtMerPosFo07.Text.Trim();
i.MER_DATE = DateTime.Now;
i.MER_STATUS = 0;
_MerPhuLucGiaHanData.Create(i);
db.SubmitChanges();
var getlink = db.MER_PHULUC_GIAHANs.OrderByDescending(n => n.ID).Take(1).ToList();
if (getlink.Count > 0)
{
strLink = string.IsNullOrEmpty(strLink) ? "phu-luc-gia-han-hop-dong-ke-toan.aspx?id=" + getlink[0].ID : strLink;
Save_FileDoc(getlink[0].ID);
}
//Gửi mail
string _nameUser = HttpContext.Current.Request.Cookies["PITM_INFO"]["PITM_USER_NAME"];
SendEmail(24, _nameUser, ConvertString(txtMerName.Text.ToUpper().Trim()));
if (!string.IsNullOrEmpty(strLink))
{
string strScript = "<script>";
strScript += "alert('Hợp đồng dịch vụ kế toán đã cập nhật thành công!');";
strScript += "window.location='" + strLink + "';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
else
{
var obj = db.MER_PHULUC_GIAHANs.Where(n => n.ID == _id).ToList();
foreach (var i in obj)
{
i.MER_POS01 = txtMerPos01.Text.Trim();
i.MER_POS02 = txtMerPos02.Text.Trim();
i.MER_POS03 = txtMerPos03.Text.Trim();
i.MER_POS04 = txtMerPos04.Text.Trim();
i.MER_POS05 = txtMerPos05.Text.Trim();
i.MER_POS06 = txtMerPos06.Text.Trim();
i.MER_POS07 = txtMerPos07.Text.Trim();
i.MER_POS08 = txtMerPos08.Text.Trim();
i.MER_POS09 = txtMerPos09.Text.Trim();
i.MER_POS10 = txtMerPos10.Text.Trim();
i.MER_NAME = ConvertString(txtMerName.Text.ToUpper().Trim());
i.MER_ADDRESS = txtMerAddress.Text.Trim();
i.MER_PHONE = txtMerPhone.Text.Trim();
i.MER_TAXCODE = txtMerTaxCode.Text.Trim();
i.MER_EMAIL = txtMerEmail.Text.Trim();
i.MER_NX = ddlDanhXung.SelectedValue;
string sNguoiDD = ToFirstUpper(txtMerRepresent.Text.Trim());
i.MER_REPRESENT = ConvertStringNDD(sNguoiDD);
i.MER_POSITION = ToFirstUpper(txtMerPosition.Text.Trim());
i.MER_POSBODY01 = txtMerPosBody01.Text.Trim();
i.MER_POSBODY02 = txtMerPosBody02.Text.Trim();
i.MER_POSBODY03 = txtMerPosBody03.Text.Trim();
i.MER_POSBODY04 = txtMerPosBody04.Text.Trim();
i.MER_POSBODY05 = txtMerPosBody05.Text.Trim();
i.MER_POSBODY06 = txtMerPosBody06.Text.Trim();
i.MER_POSBODY07 = txtMerPosBody07.Text.Trim();
i.MER_POSBODY08 = txtMerPosBody08.Text.Trim();
i.MER_POSBODY09 = txtMerPosBody09.Text.Trim();
i.MER_POSBODY10 = txtMerPosBody10.Text.Trim();
i.MER_COST_TITLE = txtMerCostTitle.Text.Trim();
i.MER_COST_DETAIL = txtMerCostDetail.Text.Trim();
i.MER_POSFO01 = txtMerPosFo01.Text.Trim();
i.MER_POSFO02 = txtMerPosFo02.Text.Trim();
i.MER_POSFO03 = txtMerPosFo03.Text.Trim();
i.MER_POSFO04 = txtMerPosFo04.Text.Trim();
i.MER_POSFO05 = txtMerPosFo05.Text.Trim();
i.MER_POSFO06 = txtMerPosFo06.Text.Trim();
i.MER_POSFO07 = txtMerPosFo07.Text.Trim();
if (i.MER_STATUS == 2)
{
i.MER_STATUS = 0;
i.MER_CHI_CHU = "Đã sửa lại hợp đồng";
}
_MerPhuLucGiaHanData.Update(i);
db.SubmitChanges();
}
strLink = string.IsNullOrEmpty(strLink) ? "phu-luc-gia-han-hop-dong-ke-toan.aspx?id=" + _id : strLink;
Save_FileDoc(_id);
if (!string.IsNullOrEmpty(strLink))
{
string strScript = "<script>";
strScript += "alert('Phụ lục gia hạn dịch vụ kế toán đã cập nhật thành công!');";
strScript += "window.location='" + strLink + "';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
}
catch (Exception) { throw; }
}
private void Save_Data(string strLink = "")
{
try
{
if (_id == 0)
{
int _idUser = Utils.CIntDef(HttpContext.Current.Request.Cookies["PITM_INFO"]["PITM_USER_ID"]);
MER_PHULUC_GIAHAN i = new MER_PHULUC_GIAHAN();
i.USER_ID = _idUser;
i.MER_POS01 = txtMerPos01.Text.Trim();
i.MER_POS02 = txtMerPos02.Text.Trim();
i.MER_POS03 = txtMerPos03.Text.Trim();
i.MER_POS04 = txtMerPos04.Text.Trim();
i.MER_POS05 = txtMerPos05.Text.Trim();
i.MER_POS06 = txtMerPos06.Text.Trim();
i.MER_POS07 = txtMerPos07.Text.Trim();
i.MER_POS08 = txtMerPos08.Text.Trim();
i.MER_POS09 = txtMerPos09.Text.Trim();
i.MER_POS10 = txtMerPos10.Text.Trim();
i.MER_NAME = ConvertString(txtMerName.Text.ToUpper().Trim());
i.MER_ADDRESS = txtMerAddress.Text.Trim();
i.MER_PHONE = txtMerPhone.Text.Trim();
i.MER_TAXCODE = txtMerTaxCode.Text.Trim();
i.MER_EMAIL = txtMerEmail.Text.Trim();
i.MER_NX = ddlDanhXung.SelectedValue;
string sNguoiDD = ToFirstUpper(txtMerRepresent.Text.Trim());
i.MER_REPRESENT = ConvertStringNDD(sNguoiDD);
i.MER_POSITION = ToFirstUpper(txtMerPosition.Text.Trim());
i.MER_POSBODY01 = txtMerPosBody01.Text.Trim();
i.MER_POSBODY02 = txtMerPosBody02.Text.Trim();
i.MER_POSBODY03 = txtMerPosBody03.Text.Trim();
i.MER_POSBODY04 = txtMerPosBody04.Text.Trim();
i.MER_POSBODY05 = txtMerPosBody05.Text.Trim();
i.MER_POSBODY06 = txtMerPosBody06.Text.Trim();
i.MER_POSBODY07 = txtMerPosBody07.Text.Trim();
i.MER_POSBODY08 = txtMerPosBody08.Text.Trim();
i.MER_POSBODY09 = txtMerPosBody09.Text.Trim();
i.MER_POSBODY10 = txtMerPosBody10.Text.Trim();
i.MER_COST_TITLE = txtMerCostTitle.Text.Trim();
i.MER_COST_DETAIL = txtMerCostDetail.Text.Trim();
i.MER_POSFO01 = txtMerPosFo01.Text.Trim();
i.MER_POSFO02 = txtMerPosFo02.Text.Trim();
i.MER_POSFO03 = txtMerPosFo03.Text.Trim();
i.MER_POSFO04 = txtMerPosFo04.Text.Trim();
i.MER_POSFO05 = txtMerPosFo05.Text.Trim();
i.MER_POSFO06 = txtMerPosFo06.Text.Trim();
i.MER_POSFO07 = txtMerPosFo07.Text.Trim();
i.MER_DATE = DateTime.Now;
i.MER_STATUS = 0;
_MerPhuLucGiaHanData.Create(i);
db.SubmitChanges();
var getlink = db.MER_PHULUC_GIAHANs.OrderByDescending(n => n.ID).Take(1).ToList();
if (getlink.Count > 0)
{
strLink = string.IsNullOrEmpty(strLink) ? "phu-luc-gia-han-hop-dong-ke-toan.aspx?id=" + getlink[0].ID : strLink;
Save_FileDoc(getlink[0].ID);
}
//Gửi mail
string _nameUser = HttpContext.Current.Request.Cookies["PITM_INFO"]["PITM_USER_NAME"];
SendEmail(24, _nameUser, ConvertString(txtMerName.Text.ToUpper().Trim()));
if (!string.IsNullOrEmpty(strLink))
{
string strScript = "<script>";
strScript += "alert('Hợp đồng dịch vụ kế toán đã cập nhật thành công!');";
strScript += "window.location='" + strLink + "';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
else
{
var obj = db.MER_PHULUC_GIAHANs.Where(n => n.ID == _id).ToList();
foreach (var i in obj)
{
i.MER_POS01 = txtMerPos01.Text.Trim();
i.MER_POS02 = txtMerPos02.Text.Trim();
i.MER_POS03 = txtMerPos03.Text.Trim();
i.MER_POS04 = txtMerPos04.Text.Trim();
i.MER_POS05 = txtMerPos05.Text.Trim();
i.MER_POS06 = txtMerPos06.Text.Trim();
i.MER_POS07 = txtMerPos07.Text.Trim();
i.MER_POS08 = txtMerPos08.Text.Trim();
i.MER_POS09 = txtMerPos09.Text.Trim();
i.MER_POS10 = txtMerPos10.Text.Trim();
i.MER_NAME = ConvertString(txtMerName.Text.ToUpper().Trim());
i.MER_ADDRESS = txtMerAddress.Text.Trim();
i.MER_PHONE = txtMerPhone.Text.Trim();
i.MER_TAXCODE = txtMerTaxCode.Text.Trim();
i.MER_EMAIL = txtMerEmail.Text.Trim();
i.MER_NX = ddlDanhXung.SelectedValue;
string sNguoiDD = ToFirstUpper(txtMerRepresent.Text.Trim());
i.MER_REPRESENT = ConvertStringNDD(sNguoiDD);
i.MER_POSITION = ToFirstUpper(txtMerPosition.Text.Trim());
i.MER_POSBODY01 = txtMerPosBody01.Text.Trim();
i.MER_POSBODY02 = txtMerPosBody02.Text.Trim();
i.MER_POSBODY03 = txtMerPosBody03.Text.Trim();
i.MER_POSBODY04 = txtMerPosBody04.Text.Trim();
i.MER_POSBODY05 = txtMerPosBody05.Text.Trim();
i.MER_POSBODY06 = txtMerPosBody06.Text.Trim();
i.MER_POSBODY07 = txtMerPosBody07.Text.Trim();
i.MER_POSBODY08 = txtMerPosBody08.Text.Trim();
i.MER_POSBODY09 = txtMerPosBody09.Text.Trim();
i.MER_POSBODY10 = txtMerPosBody10.Text.Trim();
i.MER_COST_TITLE = txtMerCostTitle.Text.Trim();
i.MER_COST_DETAIL = txtMerCostDetail.Text.Trim();
i.MER_POSFO01 = txtMerPosFo01.Text.Trim();
i.MER_POSFO02 = txtMerPosFo02.Text.Trim();
i.MER_POSFO03 = txtMerPosFo03.Text.Trim();
i.MER_POSFO04 = txtMerPosFo04.Text.Trim();
i.MER_POSFO05 = txtMerPosFo05.Text.Trim();
i.MER_POSFO06 = txtMerPosFo06.Text.Trim();
i.MER_POSFO07 = txtMerPosFo07.Text.Trim();
if (i.MER_STATUS == 2)
{
i.MER_STATUS = 0;
i.MER_CHI_CHU = "Đã sửa lại hợp đồng";
}
_MerPhuLucGiaHanData.Update(i);
db.SubmitChanges();
}
strLink = string.IsNullOrEmpty(strLink) ? "phu-luc-gia-han-hop-dong-ke-toan.aspx?id=" + _id : strLink;
Save_FileDoc(_id);
if (!string.IsNullOrEmpty(strLink))
{
string strScript = "<script>";
strScript += "alert('Phụ lục gia hạn dịch vụ kế toán đã cập nhật thành công!');";
strScript += "window.location='" + strLink + "';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
}
catch (Exception) { throw; }
}
