private void SaveStatus()
{
var _getobj = db.WORKFLOW_STATUS.Where(n => n.PROF_ID == _id && n.ST_STATUS == status).ToList();
if (rdbStatus.SelectedValue != "2")
{
if (_getobj.Count > 0)
{
_getobj[0].ST_STATUS1 = Utils.CIntDef(rdbStatus.SelectedValue);
db.SubmitChanges();
}
else
{
WORKFLOW_STATUS _obj = new WORKFLOW_STATUS();
_obj.ST_STATUS1 = Utils.CIntDef(rdbStatus.SelectedValue);
_obj.ST_STATUS = status;
_obj.PROF_ID = _id;
db.WORKFLOW_STATUS.InsertOnSubmit(_obj);
db.SubmitChanges();
}
}
else
{
Save_Employ();
SaveStatusMain();
//Remove Status Temp
if (_getobj.Count > 0)
{
var _obj = db.WORKFLOW_STATUS.Single(n => n.ID == _getobj[0].ID);
db.WORKFLOW_STATUS.DeleteOnSubmit(_obj);
db.SubmitChanges();
}
}
}
private void Save_Data()
{
try
{
List <ListItem> ilist = multiselect_to.Items.Cast <ListItem>().ToList();
if (ilist.Count > 0)
{
foreach (var i in ilist)
{
USER_PERMISSION u = new USER_PERMISSION();
u.PER_TYPE = Utils.CIntDef(ddlMenu.SelectedValue);
u.PER_GROUP = _UnitData.GetIdGroupByUser(Utils.CIntDef(i.Value));
u.PER_USER = Utils.CIntDef(i.Value);
u.PER_VIEW = chkFuntion.Items[0].Selected == true ? true : false;
u.PER_ADD = chkFuntion.Items[1].Selected == true ? true : false;
u.PER_EDIT = chkFuntion.Items[2].Selected == true ? true : false;
u.PER_DELE = chkFuntion.Items[3].Selected == true ? true : false;
_UserPermissionData.Create(u);
db.SubmitChanges();
}
}
}
catch (Exception) { throw; }
}
private void Save(string strLink = "")
{
try
{
int _idroot = Utils.CIntDef(Drmenu_parent.SelectedValue);
int rank = 1;
int _idpar = 0;
var getrank = db.MENU_PARENTs.Where(n => n.MENU_PAR_ID == _idroot).ToList();
if (getrank.Count > 0)
{
rank += Utils.CIntDef(getrank[0].MENU_RANK);
_idpar = getrank[0].MENU_PAR_ID;
}
if (_menuid == 0)
{
MENU_PARENT menu = new MENU_PARENT();
menu.MENU_PARENT1 = _idpar;
menu.MENU_RANK = rank;
menu.MENU_NAME = Txtname.Text;
menu.MENU_PARENT_LINK = txtlinkmenu.Text;
menu.ORDERBY = Utils.CIntDef(txtOrderby.Text);
menu.MENU_PAR_ACTIVE = Utils.CIntDef(rblActive.SelectedValue);
db.MENU_PARENTs.InsertOnSubmit(menu);
db.SubmitChanges();
var getlink = db.MENU_PARENTs.OrderByDescending(n => n.MENU_PAR_ID).Take(1).ToList();
if (getlink.Count > 0)
{
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-menu-cha.aspx?menuid=" + getlink[0].MENU_PAR_ID : strLink;
}
}
else
{
var list = db.MENU_PARENTs.Where(n => n.MENU_PAR_ID == _menuid).ToList();
foreach (var i in list)
{
i.MENU_RANK = rank;
i.MENU_PARENT1 = _idpar;
i.MENU_NAME = Txtname.Text;
i.MENU_PARENT_LINK = txtlinkmenu.Text;
i.ORDERBY = Utils.CIntDef(txtOrderby.Text);
i.MENU_PAR_ACTIVE = Utils.CIntDef(rblActive.SelectedValue);
}
db.SubmitChanges();
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-menu-cha.aspx?menuid=" + _menuid : strLink;
}
}
catch (Exception)
{
throw;
}
finally
{
if (!string.IsNullOrEmpty(strLink))
{
Response.Redirect(strLink);
}
}
}
private void SaveStatusMain(int _status)
{
var _obj = db.PROFILE_NEWs.Where(n => n.ID == _id).ToList();
if (_obj.Count > 0)
{
_obj[0].PROF_STATUS = _status;
}
db.SubmitChanges();
SendEmail(Utils.CIntDef(_obj[0].USER_ID), _type, "Hồ sơ đã hoàn thành");
}
public virtual bool DeleteMemberByProf(int _id_prof)
{
try
{
var _obj = db.PROFILE_MEMBERs.Where(n => n.PROF_ID == _id_prof).ToList();
db.PROFILE_MEMBERs.DeleteAllOnSubmit(_obj);
db.SubmitChanges();
return(true);
}
catch (Exception) { return(false); }
}
public virtual void Create(MER_THANHLY_HOPDONG cus)
{
try
{
this.db.MER_THANHLY_HOPDONGs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(LOAI_HSO LOAI_HSO)
{
try
{
this.db.LOAI_HSOs.InsertOnSubmit(LOAI_HSO);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(CONG_NO_CK cus)
{
try
{
this.db.CONG_NO_CKs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(CONG_NO_WEB CONG_NO_WEB)
{
try
{
this.db.CONG_NO_WEBs.InsertOnSubmit(CONG_NO_WEB);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(NOP_THUE NOP_THUE)
{
try
{
this.db.NOP_THUEs.InsertOnSubmit(NOP_THUE);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(USER_PERMISSION cus)
{
try
{
this.db.USER_PERMISSIONs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(LUONG_DANHSACH cus)
{
try
{
this.db.LUONG_DANHSACHes.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(CKS_NHACUNGCAP cus)
{
try
{
this.db.CKS_NHACUNGCAPs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(NV_GIAONHAN cus)
{
try
{
this.db.NV_GIAONHANs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(PROFILE_TRADE cus)
{
try
{
this.db.PROFILE_TRADEs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(USER user)
{
try
{
this.db.USERs.InsertOnSubmit(user);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
private void Delete_group_menu()
{
try
{
var list = db.GROUP_MENUs.Where(n => n.GROUP_ID == _groupid);
db.GROUP_MENUs.DeleteAllOnSubmit(list);
db.SubmitChanges();
}
catch (Exception)
{
throw;
}
}
protected void btnDone_Click(object sender, EventArgs e)
{
if (id > 0)
{
var obj = db.MER_HOPDONG_DVs.Where(n => n.ID == Utils.CIntDef(id, 0)).Single();
if (obj != null)
{
int _trangThai = Utils.CIntDef(ddlTrangThai.SelectedValue, 0);
obj.MER_STATUS = _trangThai;
if (_trangThai == 2)
{
obj.MER_CHI_CHU = txtGhiChu.Text;
//Gửi mail cho nhân viên kinh doanh nếu hồ sơ bị hủy
SendEmailNV(Utils.CIntDef(obj.USER_ID), obj.MER_NAME, txtGhiChu.Text);
}
else
{
obj.MER_CHI_CHU = "";
}
if (_trangThai == 3 && obj.MER_NGAY_HT == null)
{
obj.MER_NGAY_HT = DateTime.Now;
}
db.SubmitChanges();
}
}
ClientScript.RegisterStartupScript(GetType(), "Load", "<script type='text/javascript'>parent.emailwindow.close(); parent.GetCurrentTime()</script>");
}
private void Save_Info()
{
try
{
if (CheckError())
{
var _vChangePass = db.GetTable <USER>().Where(a => a.USER_EMAIL == txtEmail.Value.Trim());
if (_vChangePass.ToList().Count > 0)
{
string _sNewPassword = Create_Random(6);
_vChangePass.First().USER_PW = clsUtility.Common.Encrypt(_sNewPassword, _vChangePass.First().SALT);
db.SubmitChanges();
string strEmailBody = "";
strEmailBody = "<html><body>";
strEmailBody += "Xin chào, " + _vChangePass.First().USER_NAME + "!<br />";
strEmailBody += "Mật khẩu mới của bạn tại atlaslogistics là: " + _sNewPassword + "<br />";
strEmailBody += "Sau khi đăng nhập lại vui lòng đổi lại mật khẩu để việc đăng nhập trở nên thuận tiện hơn<br />";
strEmailBody += "</body></html>";
SendEmailSMTP("Mật khẩu mới của bạn tại atlaslogistics", txtEmail.Value, "", "", strEmailBody, true, false);
Response.Write("<script LANGUAGE='JavaScript' >alert('Thông báo: Mật khẩu mới đã được gửi vào mail của bạn. Sau khi đăng nhập lại vui lòng đổi lại mật khẩu để việc đăng nhập trở nên thuận tiện hơn!');document.location='" + ResolveClientUrl("/Pages/dang-nhap.aspx") + "';</script>");
}
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
private void Save(string strLink = "")
{
try
{
if (_id == 0)
{
if (_NhaCungCapData.CheckCodeExists(txtMaNCC.Text.Trim()))
{
CKS_NHACUNGCAP i = new CKS_NHACUNGCAP();
i.NCC_MA = txtMaNCC.Text;
i.NCC_TEN = txtTenNCC.Text;
i.NCC_HOA_HONG = Utils.CDecDef(txtHoaHong.Text.Replace(",", ""));
i.NCC_ORDER = Utils.CIntDef(txtThuTu.Text);
i.NCC_ACTIVE = Utils.CIntDef(rblActive.SelectedValue);
i.NCC_TYPE = Utils.CIntDef(rdoType.SelectedValue);
_NhaCungCapData.Create(i);
var getlink = db.CKS_NHACUNGCAPs.OrderByDescending(n => n.ID).Take(1).ToList();
if (getlink.Count > 0)
{
strLink = string.IsNullOrEmpty(strLink) ? "nha-cung-cap.aspx?id=" + getlink[0].ID : strLink;
}
}
else
{
string strScript = "<script>";
strScript += "alert('Cập nhật thất bại. Mã nhà cung cấp này đã tồn tại!');";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
else
{
var i = _NhaCungCapData.GetById(_id);
if (i != null)
{
i.NCC_MA = txtMaNCC.Text;
i.NCC_TEN = txtTenNCC.Text;
i.NCC_HOA_HONG = Utils.CDecDef(txtHoaHong.Text.Replace(",", ""));
i.NCC_ORDER = Utils.CIntDef(txtThuTu.Text);
i.NCC_ACTIVE = Utils.CIntDef(rblActive.SelectedValue);
i.NCC_TYPE = Utils.CIntDef(rdoType.SelectedValue);
_NhaCungCapData.Update(i);
}
db.SubmitChanges();
strLink = string.IsNullOrEmpty(strLink) ? "nha-cung-cap.aspx?id=" + _id : strLink;
}
}
catch (Exception)
{
throw;
}
finally
{
if (!string.IsNullOrEmpty(strLink))
{
Response.Redirect(strLink);
}
}
}
private void Delete()
{
try
{
var obj = _BangLuongData.GetById(_id);
if (obj != null)
{
db.LUONG_DANHSACHes.DeleteOnSubmit(obj);
db.SubmitChanges();
Response.Redirect("bang-luong.aspx");
}
}
catch (Exception)
{
throw;
}
}
private bool SaveStatus()
{
var _getobj = db.WORKFLOW_STATUS.Where(n => n.PROF_ID == _id && n.ST_STATUS == status).ToList();
if (rdbStatus.SelectedValue != "2")
{
if (_getobj.Count > 0)
{
_getobj[0].ST_STATUS1 = Utils.CIntDef(rdbStatus.SelectedValue);
db.SubmitChanges();
return(true);
}
else
{
WORKFLOW_STATUS _obj = new WORKFLOW_STATUS();
_obj.ST_STATUS1 = Utils.CIntDef(rdbStatus.SelectedValue);
_obj.ST_STATUS = status;
_obj.PROF_ID = _id;
db.WORKFLOW_STATUS.InsertOnSubmit(_obj);
db.SubmitChanges();
return(true);
}
}
else
{
if (Save_Employ())
{
SaveStatusMain();
//Remove Status Temp
if (_getobj.Count > 0)
{
var _obj = db.WORKFLOW_STATUS.Single(n => n.ID == _getobj[0].ID);
db.WORKFLOW_STATUS.DeleteOnSubmit(_obj);
db.SubmitChanges();
}
return(true);
}
else
{
lblMsg.Text = "Xin chọn tên nhân viên nhận!";
return(false);
}
}
}
protected void lbtnDelete_Click1(object sender, EventArgs e)
{
List <object> fieldValues = ASPxGridView1_group.GetSelectedFieldValues(new string[] { "GROUP_ID" });
var list = db.GROUPs.Where(n => fieldValues.Contains(n.GROUP_ID.ToString()));
db.GROUPs.DeleteAllOnSubmit(list);
db.SubmitChanges();
//Loadgroup();
Response.Redirect("danh-sach-nhom-quan-tri.aspx");
}
protected void lbtnDelete_Click1(object sender, EventArgs e)
{
foreach (TreeListNode node in ASPxTreeList_menu.GetSelectedNodes())
{
int _idmenu = Utils.CIntDef(node.Key, 0);
var list = db.TYPE_COMPANies.Where(n => n.TYPE_ID == _idmenu);
db.TYPE_COMPANies.DeleteAllOnSubmit(list);
db.SubmitChanges();
}
//Loadmenu();
Response.Redirect("danh-sach-loai-hinh-doanh-nghiep.aspx");
}
private void Save_Employ()
{
List <ListItem> EmpSelected = ListUser.Items.Cast <ListItem>().Where(li => li.Selected).ToList();
if (EmpSelected.Count > 0)
{
foreach (var i in EmpSelected)
{
int _i = Utils.CIntDef(i.Value);
WORKFLOW_USER b = new WORKFLOW_USER();
b.USER_ID = _i;
b.PROF_ID = _id;
b.DATE = DateTime.Now;
b.WORK_STATUS = 2;
b.WORK_FIELD1 = txtNote.Text;
db.WORKFLOW_USERs.InsertOnSubmit(b);
db.SubmitChanges();
SendEmail(Utils.CIntDef(i.Value), _type, "Giai đoạn 2: Soạn HS");
}
}
}
protected void lbtnDelete_Click1(object sender, EventArgs e)
{
foreach (TreeListNode node in ASPxTreeList_menu.GetSelectedNodes())
{
int _idmenu = Utils.CIntDef(node.Key, 0);
var list = db.MENU_PARENTs.Where(n => n.MENU_PAR_ID == _idmenu);
db.MENU_PARENTs.DeleteAllOnSubmit(list);
db.SubmitChanges();
}
//Loadmenu();
Response.Redirect("danh-sach-menu-cha.aspx");
}
private void Delete()
{
try
{
List <object> fieldValues = ASPxGridView1_request.GetSelectedFieldValues(new string[] { "USER_ID" });
foreach (var item in fieldValues)
{
//_NhanVienGiaoNhanData.Remove(Utils.CIntDef(item));
var gcdel = (from gp in db.NV_GIAONHANs
where gp.USER_ID == Utils.CIntDef(item, 0)
select gp);
db.NV_GIAONHANs.DeleteAllOnSubmit(gcdel);
db.SubmitChanges();
}
}
catch (Exception)
{
throw;
}
}
private void SaveStatus()
{
var _getobj = db.WORKFLOW_STATUS.Where(n => n.PROF_ID == _id && n.ST_STATUS == status).ToList();
if (rdbStatus.SelectedValue != "2")
{
if (_getobj.Count > 0)
{
_getobj[0].ST_STATUS1 = Utils.CIntDef(rdbStatus.SelectedValue);
db.SubmitChanges();
}
else
{
WORKFLOW_STATUS _obj = new WORKFLOW_STATUS();
_obj.ST_STATUS1 = Utils.CIntDef(rdbStatus.SelectedValue);
_obj.ST_STATUS = status;
_obj.PROF_ID = _id;
db.WORKFLOW_STATUS.InsertOnSubmit(_obj);
db.SubmitChanges();
}
}
else
{
Save_EmployManager(status + 1);
SaveStatusMain();
//Gửi cho kinh doanh
var _getuser = db.PROFILE_NEWs.Where(n => n.ID == _id).ToList();
if (_getuser.Count > 0)
{
SendEmail(Utils.CIntDef(_getuser[0].USER_ID), _type, "Hồ sơ đã nhận dấu");
}
//Remove Status Temp
if (_getobj.Count > 0)
{
var _obj = db.WORKFLOW_STATUS.Single(n => n.ID == _getobj[0].ID);
db.WORKFLOW_STATUS.DeleteOnSubmit(_obj);
db.SubmitChanges();
}
}
}
private void Save_File()
{
/*--------------File-------------*/
string img = string.Empty;
string pathfile = string.Empty;
string fullpathfile = string.Empty;
//string path = string.Empty;
img = FileUpload1.PostedFile.FileName;
/*------------------------------*/
var _obj = db.PROFILE_ATTACHes.Where(n => n.ID == _id).ToList();
if (_obj.Count > 0)
{
_obj[0].ATT_LINK = img;
_obj[0].ATT_NAME = txtTitleFile.Text;
if (Utils.CIntDef(Session["Userid"], 0) > 0)
{
_obj[0].ATT_USER = Utils.CIntDef(Session["Userid"]);
}
db.SubmitChanges();
}
if (_id > 0)
{
if (!string.IsNullOrEmpty(FileUpload1.PostedFile.FileName))
{
pathfile = Server.MapPath("/File/Profile/" + _id_prof + "/" + Utils.CStrDef(_id));
//path = System.Configuration.ConfigurationManager.AppSettings["URLWebsite"] + "/File/Profile/" + _id_prof + "/" + Utils.CStrDef(_id + "/" + img);
fullpathfile = pathfile + "/" + img;
DeleteAllFilesInFolder(pathfile);
if (!Directory.Exists(pathfile))
{
Directory.CreateDirectory(pathfile);
}
FileUpload1.PostedFile.SaveAs(fullpathfile);
}
}
}
private void SaveStatusMain(int _status)
{
var _obj = db.PROFILE_NEWs.Where(n => n.ID == _id).ToList();
if (_obj.Count > 0)
{
_obj[0].PROF_STATUS = _status;
db.SubmitChanges();
SendEmail(Utils.CIntDef(_obj[0].USER_ID), _type, "Hồ sơ đã hoàn thành");
SendEmailNVKeToanCongNo(_obj[0].PROF_TAXCODE, _CongNoData.GetIdKeToan(_obj[0].PROF_TAXCODE));
SendEmailChangeCongNo(_obj[0].PROF_TAXCODE);
}
}