protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { IsLoginBackOffice(); _UserList = new List <Viewuserlogin>(); using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { //แสดง file ที่มีการ upload ไปแล้ว _UserList = (from t1 in dbc.mst_user_logins where t1.mul_user_login != "Admin" select new Viewuserlogin { Userlogin = t1.mul_user_login, FirstName = t1.mul_fname, Lastname = t1.mul_lname, Market = (t1.mut_id == 1) ? true : false, HPC = (t1.mut_id == 2) ? true : false, Collection = (t1.mut_id == 3) ? true : false, ContactCenter = (t1.mut_id == 4) ? true : false, IsEdit = t1.mul_permit.ToString().Trim(), IsActive = (t1.mut_status != null && t1.mut_status == 'A') ? true : false, Status = "O" }).ToList(); showGridUser(); } } }
private void LoadType() { try { List <CompType> result = new List <CompType> { new CompType { id = 0, name = "" } }; DDType.DataTextField = "name"; DDType.DataValueField = "id"; DDType.DataSource = result; using (InhToDoListDataContext context = new InhToDoListDataContext()) { result.AddRange(context.mst_types .Where(x => x.mst_status == 'A') .Select(x => new CompType { id = x.mst_id, name = x.mst_tname }).ToList()); } DDType.DataBind(); } catch (Exception ex) { } //var objmstid = (from tid in dbc.mst_types select new { id = tid.mst_id, name = tid.mst_tname }).ToList(); //DDType.DataTextField = "name"; //DDType.DataValueField = "id"; //DDType.DataSource = objmstid; //DDType.DataBind(); //DDType.Items.Insert(0, String.Empty); //DDType.SelectedIndex = 0; }
public static void CheckPolicy(string TypeCode) { if (Constant.CurrentUserLogin != "") {//ถ้ายังไม่ได้ login ให้ ไปหน้า login using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objpolicy = (from t1 in dbc.mst_user_logins where t1.mul_user_login == Constant.CurrentUserLogin && t1.mst_user_type.mut_code == TypeCode select t1).Count(); if (objpolicy > 0) { return; } else { if (Constant.CurrentUserLogin == "Admin") { return; } HttpContext.Current.Response.Redirect("frmHome.aspx"); } } } else { string[] strpath = HttpContext.Current.Request.Url.AbsolutePath.Split('/'); string pagename = strpath[strpath.Length - 1]; string qs = HttpContext.Current.Request.Url.Query; HttpContext.Current.Response.Redirect(Constant.DefaultPageLogin + "?backurl=" + Constant.URLEnCode(pagename + qs)); } }
private void LoadLacation() { try { List <Location> result = new List <Location> { new Location { id = 0, name = "" } }; DDLocation.DataTextField = "name"; DDLocation.DataValueField = "id"; DDLocation.DataSource = result; using (InhToDoListDataContext context = new InhToDoListDataContext()) { result.AddRange(context.mst_checkup_locations .Where(x => x.mcl_status == 'A') .Select(x => new Location { id = x.mcl_id, name = x.mcl_ename }).ToList()); } DDLocation.DataBind(); } catch (Exception ex) { } //var objloc = (from loc in dbc.mst_checkup_locations select new { id = loc.mcl_id, name = loc.mcl_tname + "/" + loc.mcl_ename }).ToList(); //DDLocation.DataTextField = "name"; //DDLocation.DataValueField = "id"; //DDLocation.DataSource = objloc; //DDLocation.DataBind(); //DDLocation.Items.Insert(0, String.Empty); //DDLocation.SelectedIndex = 0; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["username"]) && !string.IsNullOrEmpty(Request.QueryString["otp"])) { string username = Request.QueryString["username"].ToString(); string otp = Request.QueryString["otp"].ToString(); using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var user = dbc.mst_user_logins .Where(x => x.mul_user_login.ToUpper() == username.ToUpper() && x.mut_status == 'A') .Select(x => new { x.mst_user_type.mut_code, x.mul_fname }).FirstOrDefault(); var mst_otp = dbc.mst_user_otps.Where(x => x.mul_user_login == username && x.mul_otp == otp).FirstOrDefault(); if (user != null && mst_otp != null) { mst_otp.mul_expire = funcCls.GetServerDateTime(); dbc.SubmitChanges(); Constant.CurrentUserLogin = username; Constant.CurrentPageLogin = user.mut_code; Constant.CurrentUserLoginName = user.mul_fname; switch (Constant.CurrentPageLogin) { case "MKT": Response.Redirect(this.Page.ResolveClientUrl("~/frmmktNew.aspx")); break; case "HPC": Response.Redirect(this.Page.ResolveClientUrl("~/frm_hpc.aspx")); break; case "CLT": Response.Redirect(this.Page.ResolveClientUrl("~/frm_collection.aspx")); break; case "CTC": Response.Redirect(this.Page.ResolveClientUrl("~/frm_contact_center.aspx")); break; } } else { lbalertmsg.Text = "UserName & Password incorrect. Please try again"; txtUser.Text = username; txtpass.Text = ""; txtUser.Focus(); } } } } }
public static List <string> GetMasterCompanyListEng(string cname) { try { string strSearch = cname.Trim().ToLower(); if (strSearch.Length >= 2) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { List <string> result = dbc.mst_companies .Where(x => x.mco_ename.ToLower().Contains(strSearch)) .Select(x => x.mco_tname).Distinct().ToList(); //var objcomp = (from comp in dbc.mst_companies // where // comp.mco_ename.ToLower().Contains(cname.ToLower()) && comp.mco_status == 'A' // select new { cname = comp.mco_ename }).ToList(); return(result); } } else { return(new List <string>()); } } catch { return(new List <string>()); } }
private void showReadOnly(string StatusPage) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objpolicy = (from t1 in dbc.mst_user_logins where t1.mul_user_login == Constant.CurrentUserLogin && t1.mst_user_type.mut_code == StatusPage select t1); if (objpolicy.Count() > 0) { var currentuser = objpolicy.FirstOrDefault(); if (currentuser.mul_permit == 'W') { btnEdit.Visible = true; } } else { if (Constant.CurrentUserLogin == "Admin") { return; } } } }
public static List <string> AutoCompletePayor(string txt) { try { string strSearch = txt.Trim().ToLower(); if (strSearch.Length >= 2) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { List <string> result = dbc.mst_payors .Where(x => x.msp_name.ToLower().Contains(strSearch)) .Select(x => x.msp_name).Distinct().ToList(); //List<string> result = (from msp in dbc.mst_payors // where msp.msp_name.ToLower().Contains(txt.ToLower()) // select msp.msp_name).ToList(); return(result); } } else { return(new List <string>()); } } catch { return(new List <string>()); } }
public static List <mst_checkup_location> getListHpcSite() { List <mst_checkup_location> site = new List <mst_checkup_location>(); InhToDoListDataContext tdc = new InhToDoListDataContext(); site = tdc.mst_checkup_locations.ToList(); return(site); }
public List <string> AutoCompleteCompanyCode(string txt) { InhToDoListDataContext tdc = new InhToDoListDataContext(); List <string> payor = (from msc in tdc.mst_companies where msc.mco_code.Contains(txt) select msc.mco_code).ToList(); return(payor); }
public List <string> AutoCompletePayor(string txt) { InhToDoListDataContext tdc = new InhToDoListDataContext(); List <string> payor = (from msp in tdc.mst_payors where msp.msp_name.ToLower().Contains(txt.ToLower()) select msp.msp_name).ToList(); return(payor); }
public static DateTime GetServerDateTime() { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { //var EnCulture = CultureInfo.CreateSpecificCulture("en-US"); DateTime nowdatetime = dbc.ExecuteQuery <DateTime>("select GetDate()").FirstOrDefault();//.ToString(EnCulture)); return(nowdatetime); } }
public trn_company_detail getCompanyDetail(string code) { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { trn_company_detail tcd = tdc.trn_company_details .Where(x => x.tcd_code == code) .OrderByDescending(x => x.tcd_create_date).FirstOrDefault(); return(tcd); } }
public List <string> getListDep(string code) { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { int tcd_id = tdc.trn_company_details .Where(x => x.tcd_code == code) .OrderByDescending(x => x.tcd_create_date) .Select(x => x.tcd_id).FirstOrDefault(); List <string> tmp = tdc.trn_name_checks .Where(x => x.tcd_id == tcd_id) .OrderBy(x => x.tnc_department) .Select(x => x.tnc_department).Distinct().ToList(); tmp.Insert(0, ""); return(tmp); } }
public trn_name_check getNameCheck(string hn_no) { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient tpt = cdc.trn_patients.Where(x => x.tpt_hn_no == hn_no).FirstOrDefault(); if (tpt != null) { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { trn_name_check tnc = tdc.trn_name_checks.Where(x => x.tnc_fname == tpt.tpt_first_name && x.tnc_lname == tpt.tpt_last_name).OrderByDescending(x => x.tnc_create_date).FirstOrDefault(); return(tnc); } } } return(null); }
public List <ObjCompany> getListCompany() { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { List <ObjCompany> obj = tdc.sp_get_company() .Select(x => new ObjCompany { code = x.tcd_code, name = x.tcd_tname }).ToList(); obj.Insert(0, new ObjCompany { code = "", name = "" }); return(obj); } }
protected void Page_Load(object sender, EventArgs e) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objcurrentuser = (from t1 in dbc.mst_user_logins where t1.mul_user_login == Constant.CurrentUserLogin select t1).FirstOrDefault(); if (objcurrentuser != null) { //Convert1.ToString(objcurrentuser.mul_lname) lbllogin_detail.Text = String.Format(Convert1.ToString(objcurrentuser.mul_fname) + " " + Constant.CurrentUserLoginName + " : เข้าสู่ระบบเมื่อ {0:dd/MM/yyyy HH:mm}", DateTime.Now); } } }
protected void btnSearch_Click(object sender, EventArgs e) { txtSearch.Text = txtSearch.Text.Trim(); txtUserLogin.Enabled = true; string strsearch = txtSearch.Text.ToLower(); //_UserList = new List<Viewuserlogin>(); using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { //แสดง file ที่มีการ upload ไปแล้ว _UserList = (from t1 in dbc.mst_user_logins where t1.mul_user_login != "Admin" && (t1.mul_user_login.ToLower().Contains(strsearch) || t1.mul_fname.ToLower().Contains(strsearch) || t1.mul_lname.ToLower().Contains(strsearch) || (t1.mul_fname + " " + t1.mul_lname).ToLower().Contains(strsearch) ) select new Viewuserlogin { Userlogin = t1.mul_user_login, FirstName = t1.mul_fname, Lastname = t1.mul_lname, FullName = Constant.MargeString(t1.mul_fname, t1.mul_lname, " "), Market = (t1.mut_id == 1) ? true : false, HPC = (t1.mut_id == 2) ? true : false, Collection = (t1.mut_id == 3) ? true : false, ContactCenter = (t1.mut_id == 4) ? true : false, IsEdit = t1.mul_permit.ToString().Trim(), IsActive = (t1.mut_status != null && t1.mut_status == 'A') ? true : false, Status = "O" }).ToList(); //if (strsearch != null) //{ // _UserList = _UserList.Where(x => x.Userlogin.ToLower().Contains(strsearch) // || x.FirstName.ToLower().Contains(strsearch) // || x.Lastname.ToLower().Contains(strsearch) // || x.FullName.ToLower().Contains(strsearch)).ToList(); //} showGridUser(); } lbmsgAlert.Text = ""; lbmsgAlertAdd.Text = ""; }
public static void addListSiteToControl(DropDownList dropDown) { InhToDoListDataContext tdc = new InhToDoListDataContext(); var dataobj = (from s in tdc.mst_checkup_locations.ToList() where s.mcl_status == 'A' select new DropdowData { code = s.mcl_id, name = MargeString(s.mcl_tname, s.mcl_ename) }).ToList(); DropdowData newitem = new DropdowData(); newitem.code = 0; newitem.name = String.Empty; dataobj.Insert(0, newitem); dropDown.DataSource = dataobj; dropDown.DataValueField = "code"; dropDown.DataTextField = "name"; dropDown.DataBind(); }
public static void addListDocCateToControl(DropDownList dropDown) { InhToDoListDataContext tdc = new InhToDoListDataContext(); var dataobj = (from s in tdc.mst_doctor_cats.ToList() where s.mdc_status == 'A' select new DropdowData { code = s.mdc_id, name = s.mdc_ename }).ToList(); DropdowData newitem = new DropdowData(); newitem.code = 0; newitem.name = String.Empty; dataobj.Insert(0, newitem); dropDown.DataSource = dataobj; dropDown.DataValueField = "code"; dropDown.DataTextField = "name"; dropDown.DataBind(); }
private bool Login1(string strUsername, string strPassword) { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); DataTable dt = ws.LogonTrakcare(strUsername, strPassword); if (dt.Rows.Count > 0) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objcurrentuser = (from t1 in dbc.mst_user_logins where t1.mul_user_login == strUsername select t1).FirstOrDefault(); if (objcurrentuser != null && (objcurrentuser.mul_user_login == "Admin" && strPassword == "nimd@")) { Constant.CurrentUserLogin = strUsername; return(true); } else { Constant.CurrentUserLogin = ""; return(false); } } } else { if (strUsername == "Admin" && strPassword == "nimd@") { Constant.CurrentUserLogin = strUsername; return(true); } else { Constant.CurrentUserLogin = ""; return(false); } } }
public List <CompResult> GetListComp(DateTime dateArrived) { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { var clist = tdc.GetCompByArrived(dateArrived) .Select(x => new CompResult { tcd_id = x.tcd_id, doc_no = x.tcd_document_no, comName = x.tcd_tname }).ToList(); //var clist = tdc.test_document_nos // .Where(x => x.tcd_date_from.Value.Date <= dateArrived.Date && // x.tcd_date_to.Value.Date >= dateArrived.Date) // .Select(x => new CompResult // { // doc_no = x.tcd_document_no, // comName = x.tcd_tname // }).OrderBy(x => x.comName).ToList(); return(clist); } }
protected void btnsubmit_Click(object sender, ImageClickEventArgs e) { if (txtUser.Text == "" || txtpass.Text == "") { lbalertmsg.Text = "input UserName & Password try again"; txtUser.Focus(); return; } if (Login1(txtUser.Text.Trim(), txtpass.Text.Trim())) { //Defualt Page Current using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objpolicy = (from t1 in dbc.mst_user_logins where t1.mul_user_login == Constant.CurrentUserLogin select t1).FirstOrDefault(); if (objpolicy != null) { Constant.CurrentPageLogin = objpolicy.mul_user_login; } } switch (Constant.CurrentPageLogin) { case "Admin": Response.Redirect(this.Page.ResolveClientUrl("~/BackOffice/AdminControlPage.aspx")); break; } } else { lbalertmsg.Text = "UserName & Password incorrect. Please try again"; txtUser.Text = ""; txtpass.Text = ""; txtUser.Focus(); } }
public static List <fileclass> GetObjAttachFile(int tcd_id, string site) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { //List<fileclass> objattachfile = (from file in dbc.trn_attach_files // where file.mst_user_type.mut_code == site // && file.mst_path_file.tcd_id == tcd_id // select new fileclass // { // file_name = file.mst_path_file.mpf_file_name, // file_path = Constant.HttpUrl + file.mst_path_file.mpf_path_name // }).ToList(); List <fileclass> objattachfile = (from t1 in dbc.mst_path_files where t1.tcd_id == tcd_id && t1.trn_attach_files.Where(x => x.mst_user_type.mut_code == site).Count() > 0 select new fileclass { file_name = t1.mpf_file_name, file_path = Constant.HttpUrl + t1.mpf_path_name, }).ToList(); return(objattachfile); } }
private void IsLoginBackOffice() { if (Constant.CurrentUserLogin != "") {//ถ้ายังไม่ได้ login ให้ ไปหน้า login using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objpolicy = (from t1 in dbc.mst_user_logins where t1.mul_user_login == Constant.CurrentUserLogin select t1).Count(); if (objpolicy == 1 && Constant.CurrentUserLogin == "Admin") { return; } else { HttpContext.Current.Response.Redirect("BOLogin.aspx"); } } } else { HttpContext.Current.Response.Redirect("BOLogin.aspx"); } }
public static List <string> GetMasterCompanyList(string cname) { try { string strSearch = cname.Trim().ToLower(); if (strSearch.Length >= 2) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { List <string> result = dbc.mst_companies .Where(x => x.mco_tname.ToLower().Contains(strSearch) || x.mco_ename.ToLower().Contains(strSearch)) .Select(x => x.mco_tname).Distinct().ToList(); //List<string> result = new List<string>(); //var objcomp = (from comp in dbc.mst_companies // where comp.mco_tname.ToLower().Contains(cname.ToLower()) || // comp.mco_ename.ToLower().Contains(cname.ToLower()) // select new { cname = comp.mco_tname }).ToList(); //foreach (var data in objcomp) //{ // result.Add(data.cname.ToString()); //} return(result); } } else { return(new List <string>()); } } catch { return(new List <string>()); } }
private void _book_cover_PropertyChanged(object sender, PropertyChangedEventArgs e) { if (e.PropertyName == "tpbc_patient_type") { if (_book_cover != null) { if (_book_cover.tpbc_patient_type == "G") { _book_cover.tpbc_emp_id = ""; _book_cover.tcd_document_no = ""; _book_cover.tpbc_position = ""; _book_cover.tpbc_department = ""; autoCompleteComName.DataSource = null; autoCompleteComName.ReadOnly = true; txtEmpID.ReadOnly = true; txtPosition.ReadOnly = true; txtDepart.ReadOnly = true; } else if (_book_cover.tpbc_patient_type == "C") { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { DateTime dateArrived = _book_cover.trn_patient_regi.trn_patient_regis_detail.tpr_real_arrived_date.Value; var clist = new Class.CompanyCls().GetListComp(dateArrived); autoCompleteComName.DataSource = clist; autoCompleteComName.DisplayMember = "comName"; autoCompleteComName.ValueMember = "doc_no"; if (string.IsNullOrEmpty(_book_cover.tcd_document_no)) { var list_tcd = clist.Select(x => x.doc_no).ToList(); var res = new Class.CompanyCls().MappingPatient(_book_cover.tpr_id, list_tcd); _book_cover.tcd_document_no = res.document_no; if (string.IsNullOrEmpty(_book_cover.tpbc_emp_id)) { _book_cover.tpbc_emp_id = res.emp_id; } if (string.IsNullOrEmpty(_book_cover.tpbc_position)) { _book_cover.tpbc_position = res.position; } if (string.IsNullOrEmpty(_book_cover.tpbc_department)) { _book_cover.tpbc_department = res.department; } //var list_tcd = clist.Select(x => x.tcd_id).ToList(); //var pers_id = _book_cover.trn_patient_regi.trn_patient.tpt_id_card; //string doc_no = null; //string emp_id = null; //if (!string.IsNullOrEmpty(pers_id) && !string.IsNullOrEmpty(pers_id.Trim())) //{ // var person = tdc.trn_name_checks // .Where(x => list_tcd.Contains(x.tcd_id) && // x.tnc_personal_id == pers_id) // .Select(x => new // { // doc_no = x.trn_company_detail.tcd_document_no, // emp_id = x.tnc_emp_id // }).FirstOrDefault(); // if (person != null) // { // doc_no = person.doc_no; // emp_id = person.emp_id; // } //} //if (doc_no == null) //{ // var fname = _book_cover.trn_patient_regi.trn_patient.tpt_first_name; // var lname = _book_cover.trn_patient_regi.trn_patient.tpt_last_name; // var person = tdc.trn_name_checks // .Where(x => list_tcd.Contains(x.tcd_id) && // x.tnc_fname == fname && // x.tnc_lname == lname) // .Select(x => new // { // doc_no = x.trn_company_detail.tcd_document_no, // emp_id = x.tnc_emp_id // }).FirstOrDefault(); // if (person != null) // { // doc_no = person.doc_no; // emp_id = person.emp_id; // } //} //if (doc_no != null) //{ // _book_cover.tcd_document_no = doc_no; // _book_cover.tpbc_emp_id = emp_id; //} } } autoCompleteComName.ReadOnly = false; txtEmpID.ReadOnly = false; txtPosition.ReadOnly = false; txtDepart.ReadOnly = false; } } } else if (e.PropertyName == "tpbc_cover_lang") { if (_book_cover != null) { if (_book_cover.tpbc_cover_lang == "TH") { _book_cover.tpbc_patient_name = Address.nameTH; } else if (_book_cover.tpbc_cover_lang == "EN") { _book_cover.tpbc_patient_name = Address.nameEN; } } } else if (e.PropertyName == "tpbc_address") { if (_book_cover != null) { if (_book_cover.tpbc_address == "H") { txtAddress.ReadOnly = true; var addHome = Address.listAddress.Where(x => x.type == "H").FirstOrDefault(); _book_cover.tpbc_patient_address = addHome.address; } else if (_book_cover.tpbc_address == "C") { txtAddress.ReadOnly = true; var addCom = Address.listAddress.Where(x => x.type == "C").FirstOrDefault(); _book_cover.tpbc_patient_address = addCom.address; } else if (_book_cover.tpbc_address == "O") { txtAddress.ReadOnly = false; } } } else if (e.PropertyName == "tcd_document_no") { if (_book_cover != null) { if (string.IsNullOrEmpty(_book_cover.tcd_document_no)) { _book_cover.tcd_document_no = ""; //_book_cover.tpbc_emp_id = ""; //-- Still Staff id var addCom = Address.listAddress.Where(x => x.type == "C").FirstOrDefault(); addCom.contactPerson = ""; addCom.address = ""; addCom.phone = ""; addCom.fax = ""; } else { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { var com = tdc.trn_company_details .Where(x => x.tcd_document_no == _book_cover.tcd_document_no) .OrderByDescending(x => x.tcd_create_date) .Select(x => new { tcd_id = x.tcd_id, contacts = x.trn_contact_persons, adress = x.tcd_address == null ? "" : x.tcd_address.Trim(), subArea = x.tcd_tambon == null ? "" : x.tcd_tambon.Trim(), area = x.tcd_district == null ? "" : x.tcd_district.Trim(), province = x.tcd_province == null ? "" : x.tcd_province.Trim(), postal = x.tcd_postcode == null ? "" : x.tcd_postcode.Trim(), phone = x.tcd_tel == null ? "" : x.tcd_tel.Trim(), fax = x.tcd_fax == null ? "" : x.tcd_fax.Trim(), sendRptMst = x.tcd_send_rep_real == "Y" ? "E" : x.tcd_send_rep_flag, sendRptCopy = x.tcd_send_rep_copy, legel = x.tcd_legal }).FirstOrDefault(); var addCom = Address.listAddress.Where(x => x.type == "C").FirstOrDefault(); addCom.contactPerson = com.contacts.Select(x => x.tcp_name).FirstOrDefault(); addCom.address = CheckAddress(new Models.AddressModels { address = com.adress, subArea = com.subArea, area = com.area, province = com.province, postal = com.postal }); addCom.phone = com.phone; addCom.fax = com.fax; addCom.legel = com.legel; Medical.Clear(); ClearMed(); Medical.rptMst = com.sendRptMst; Medical.rptCopy = com.sendRptCopy; var rpt = tdc.trn_medical_reports .Where(x => x.tcd_id == com.tcd_id) .Select(x => new { x.mmr_id, x.tmr_rep_remark }) .ToList(); foreach (var r in rpt) { switch (r.mmr_id) { case 1: checkBoxBinding1.Checked = true; break; case 2: checkBoxBinding2.Checked = true; break; case 3: checkBoxBinding3.Checked = true; break; case 4: checkBoxBinding4.Checked = true; break; case 5: checkBoxBinding6.Checked = true; break; case 6: checkBoxBinding7.Checked = true; break; case 7: checkBoxBinding5.Checked = true; Medical.remarkOther = r.tmr_rep_remark; break; } } } } AddressComBS.ResetCurrentItem(); MedReportBS.ResetCurrentItem(); _book_cover_PropertyChanged(_book_cover, new PropertyChangedEventArgs("tpbc_address")); } } }
private void LoadCompany() { //var objcomp = (from comp in dbc.sp_search_company() // where ChSearch.Checked == true ? (funcCls.GetServerDateTime().Date >= comp.tcd_date_from.Value.Date && funcCls.GetServerDateTime().Date <= comp.tcd_date_to.Value.Date) : (comp.tcd_date_from.Value.Date > funcCls.GetServerDateTime().Date && comp.tcd_date_to.Value.Date > funcCls.GetServerDateTime().Date) || (comp.tcd_date_to.Value.Date < funcCls.GetServerDateTime().Date) // select comp).ToList(); //if (Convert.ToInt16(DDLocation.SelectedIndex) != 0) //{ // //objcomp = objcomp.Where(c => c.tcd_id == LoadLocationId(Convert.ToInt16(DDLocation.SelectedValue))).ToList(); // List<int> tcdid = LoadLocationId(Convert.ToInt32(DDLocation.SelectedValue)); // objcomp = (from data in objcomp where tcdid.Contains(data.tcd_id) select data).ToList(); //} //if (Convert.ToInt16(ddltypeofcomp.SelectedIndex) != 0) //{ // string typecode = ddltypeofcomp.Text; // objcomp = (from data in objcomp where data.tcd_type.ToLower().Contains(typecode.ToLower()) select data).ToList(); // //objmstcomp.Where(c => c.tcd_type.ToLower() == typecode.ToLower()).ToList(); //} //if (txtlegal.Text != String.Empty) //{ // objcomp = objcomp.Where(c => c.tcd_legal == txtlegal.Text).ToList(); //} //if (txtsearch.Text != String.Empty) //{ // objcomp = objcomp.Where(c => c.tcd_tname.Contains(txtsearch.Text)).ToList(); //} //if (Convert.ToInt16(DDType.SelectedIndex) != 0) //{ // using (InhToDoListDataContext tdc = new InhToDoListDataContext()) // { // List<int?> new_tcd_id = (from tpm in tdc.trn_payments // where tpm.mst_id == Convert.ToInt32(DDType.SelectedValue) // select tpm.tcd_id).ToList(); // objcomp = objcomp.Where(x => new_tcd_id.Contains(x.tcd_id)).ToList(); // } // //objcomp = objcomp.Where(c => c.mst_id == Convert.ToInt16(DDType.SelectedValue)).ToList(); //} //if (txtstart.Text != String.Empty && txtEndDate.Text != String.Empty) //{ // objcomp = objcomp.Where(c => (c.tcd_date_from >= Constant.ConvertStringToDate(txtstart.Text)) && c.tcd_date_to <= Constant.ConvertStringToDate(txtEndDate.Text)).ToList(); //} //var result = (from comp in objcomp // select new // { // tcd_id = comp.tcd_id, // tcd_tname = comp.tcd_tname, // tcd_document_no = comp.tcd_document_no, // tcd_date_from = comp.tcd_date_from, // tcd_date_to = comp.tcd_date_to, // status = LoadCheckCompanyMaster(comp.tcd_code), // mul_user_login = comp.mul_user_login // }); //RepeaterCompany.DataSource = result; //RepeaterCompany.DataBind(); try { string strSearch = (string.IsNullOrEmpty(txtsearch.Text) ? "" : txtsearch.Text).Trim().ToLower(); bool? active = ChSearch.Checked == true ? true : false; int mcl_id = Convert.ToInt32(DDLocation.SelectedValue); int mst_id = Convert.ToInt32(DDType.SelectedValue); DateTime?fromDate = string.IsNullOrEmpty(txtstart.Text) ? (DateTime?)null : Constant.ConvertStringToDate(txtstart.Text); DateTime?endDate = string.IsNullOrEmpty(txtEndDate.Text) ? (DateTime?)null : Constant.ConvertStringToDate(txtEndDate.Text); string strTypeComp = ddltypeofcomp.Text; string strLegal = txtlegal.Text; using (InhToDoListDataContext context = new InhToDoListDataContext()) { var result = context.sp_search_company2(strSearch, active, mcl_id, mst_id, fromDate, endDate, strTypeComp, strLegal) .Select(x => new { tcd_id = x.tcd_id, tcd_tname = x.tcd_tname, tcd_document_no = x.tcd_document_no, tcd_date_from = x.tcd_date_from, tcd_date_to = x.tcd_date_to, status = LoadCheckCompanyMaster(x.tcd_code), mul_user_login = x.mul_user_login }).ToList(); RepeaterCompany.DataSource = result; RepeaterCompany.DataBind(); } } catch (Exception ex) { } }
//save final protected void btnSave_Click(object sender, EventArgs e) { lbmsgAlertAdd.Text = ""; DateTime dtnow = funcCls.GetServerDateTime(); for (int i = _UserList.Count - 1; i >= 0; i--) { if (_UserList[i].Status == "N") { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { mst_user_login newitem = new mst_user_login(); newitem.mul_user_login = _UserList[i].Userlogin; newitem.mul_fname = _UserList[i].FirstName; newitem.mul_lname = _UserList[i].Lastname; if (_UserList[i].Market == true) { newitem.mut_id = 1; } if (_UserList[i].HPC == true) { newitem.mut_id = 2; } if (_UserList[i].Collection == true) { newitem.mut_id = 3; } if (_UserList[i].ContactCenter == true) { newitem.mut_id = 4; } newitem.mul_permit = Convert1.ToChar(_UserList[i].IsEdit); newitem.mut_status = (_UserList[i].IsActive == true) ? 'A' : 'I'; newitem.mul_create_by = Constant.CurrentUserLogin; newitem.mul_create_date = dtnow; newitem.mul_user_login_update = Constant.CurrentUserLogin; newitem.mul_update_date = dtnow; dbc.mst_user_logins.InsertOnSubmit(newitem); dbc.SubmitChanges(); _UserList[i].Status = "O"; } } else if (_UserList[i].Status == "D") { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var currentUser = (from t1 in dbc.mst_user_logins where t1.mul_user_login == _UserList[i].Userlogin select t1).FirstOrDefault(); if (currentUser != null) { dbc.mst_user_logins.DeleteOnSubmit(currentUser); } dbc.SubmitChanges(); } } else { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var currentUser = (from t1 in dbc.mst_user_logins where t1.mul_user_login == _UserList[i].Userlogin select t1).FirstOrDefault(); if (currentUser != null) { currentUser.mul_permit = Convert1.ToChar(_UserList[i].IsEdit); currentUser.mul_user_login = _UserList[i].Userlogin; currentUser.mul_fname = _UserList[i].FirstName; currentUser.mul_lname = _UserList[i].Lastname; if (_UserList[i].Market == true) { currentUser.mut_id = 1; } if (_UserList[i].HPC == true) { currentUser.mut_id = 2; } if (_UserList[i].Collection == true) { currentUser.mut_id = 3; } if (_UserList[i].ContactCenter == true) { currentUser.mut_id = 4; } currentUser.mut_status = (_UserList[i].IsActive == true) ? 'A' : 'I'; currentUser.mul_user_login_update = Constant.CurrentUserLogin; currentUser.mul_update_date = dtnow; dbc.SubmitChanges(); } } } }//end for each lbmsgAlert.Text = "Save data completed."; }
//Add Userlogin protected void btnAddnew_Click(object sender, EventArgs e) { lbmsgAlertAdd.Text = ""; if (txtUserLogin.Text == "" || txtFirstName.Text == "" || txtLastName.Text == "") { lbmsgAlertAdd.Text = "Please input Username, FirstName or LastName."; return; } string userlo = txtUserLogin.Text.Trim(); string fname = txtFirstName.Text.Trim(); string lname = txtLastName.Text.Trim(); if (btnAddnew.Text == "Add") { //Check UserLogin ซ้ำในtemp using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objuser = (from t1 in dbc.mst_user_logins where t1.mul_user_login.ToLower() == userlo.ToLower() select t1).Count(); if (objuser > 0) { lbmsgAlertAdd.Text = "User login had in system. please change user login."; txtUserLogin.Text = ""; return; } } Viewuserlogin newitem = new Viewuserlogin(); newitem.Userlogin = txtUserLogin.Text; newitem.FirstName = txtFirstName.Text; newitem.Lastname = txtLastName.Text; newitem.IsActive = chActive.Checked; newitem.Market = false; newitem.HPC = false; newitem.Collection = false; newitem.ContactCenter = false; newitem.Status = "N"; if (RDDepartment.SelectedValue != null) { var departmentvalue = RDDepartment.SelectedValue; if (departmentvalue == "1") { newitem.Market = true; } if (departmentvalue == "2") { newitem.HPC = true; } if (departmentvalue == "3") { newitem.Collection = true; } if (departmentvalue == "4") { newitem.ContactCenter = true; } } newitem.IsEdit = RDPolicyEdit.SelectedValue; _UserList.Add(newitem); } else if (btnAddnew.Text == "SAVE") { var objcurrent = (from t1 in _UserList where t1.Userlogin.ToLower() == txtUserLogin.Text.ToLower() select t1).FirstOrDefault(); if (objcurrent != null) { objcurrent.FirstName = txtFirstName.Text; objcurrent.Lastname = txtLastName.Text; objcurrent.IsActive = chActive.Checked; objcurrent.Market = false; objcurrent.HPC = false; objcurrent.Collection = false; objcurrent.ContactCenter = false; objcurrent.IsEdit = RDPolicyEdit.SelectedValue; string st = objcurrent.Status; if (st == "N") { //แก้รายการที่เพิ่ง insert ไป แต่ ยังไม่ได้ Save objcurrent.Status = "N"; } else { objcurrent.Status = "E"; } if (RDDepartment.SelectedValue != null) { var departmentvalue = RDDepartment.SelectedValue; if (departmentvalue == "1") { objcurrent.Market = true; } if (departmentvalue == "2") { objcurrent.HPC = true; } if (departmentvalue == "3") { objcurrent.Collection = true; } if (departmentvalue == "4") { objcurrent.ContactCenter = true; } } txtUserLogin.Enabled = true; btnAddnew.Text = "Add"; } } showGridUser(); //clear text txtFirstName.Text = ""; txtLastName.Text = ""; txtUserLogin.Text = ""; RDDepartment.ClearSelection(); RDPolicyEdit.ClearSelection(); chActive.Checked = false; }