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); } }