public MainUI () : base ("MainUI", null) { cPerson oUser; oUser = new cPerson (); cDeathCalculator dCalc; dCalc = new cDeathCalculator (); oUser.Age = 28; oUser.CigPerDay = 0; dCalc. }
// This is the main entry point of the application. static void Main (string[] args) { // if you want to use a different Application Delegate class from "AppDelegate" // you can specify it here. UIApplication.Main (args, null, "AppDelegate"); cPerson oUser; oUser = new cPerson (); cDeathCalculator dCalc; dCalc = new cDeathCalculator (); oUser.Age = 28; oUser.CigPerDay = 0; dCalc.FindTimeLeft (oUser); }
public static void InsertPerson(cPerson person) { using (AppDbContext db = new AppDbContext()) { /* * db.Add(new cPerson{ * Name = "Tania", * Email = "*****@*****.**", * Salary = 1234, * Birthday = new DateTime(1875,11,12), * Gender = 'F' * }); */ db.Add(person); // State 01: ShowStates(db.ChangeTracker.Entries()); db.SaveChanges(); // State 02: ShowStates(db.ChangeTracker.Entries()); } }
public cPhysicalVC(cPerson oUser) : base("cPhysicalVC", null) { _User = oUser; }
private void BindGridView(int nPageNo) { cPerson oPerson = new cPerson(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strperson_group_code = string.Empty; string strdirector_code = string.Empty; string strunit_code = string.Empty; string strperson_code = string.Empty; string strperson_name = string.Empty; string strperson_work_status_code = string.Empty; string struser_group_code = string.Empty; string struser_group_list = string.Empty; strperson_group_code = cboPerson_group.SelectedValue; strdirector_code = cboDirector.SelectedValue; strunit_code = cboUnit.SelectedValue; strperson_work_status_code = cboPerson_work_status.SelectedValue; strperson_code = txtperson_code.Text.Replace("'", "''").Trim(); strperson_name = txtperson_name.Text.Replace("'", "''").Trim(); struser_group_list = cboUserGroup.SelectedValue; var strperson_id = txtperson_id.Text.Replace("'", "''").Trim(); if (!strperson_id.Equals("")) { strCriteria = strCriteria + " And (person_id like '%" + strperson_id + "%') "; } if (Request.Form[strPrefixCtr + "cboPerson_work_status"] != null) { strperson_work_status_code = Request.Form[strPrefixCtr + "cboPerson_work_status"].ToString(); } if (!strperson_group_code.Equals("")) { strCriteria = strCriteria + " And (person_group_code like '%" + strperson_group_code + "%') "; } if (!strdirector_code.Equals("")) { strCriteria = strCriteria + " And (director_code = '" + strdirector_code + "') "; } if (!strunit_code.Equals("")) { strCriteria = strCriteria + " And (unit_code= '" + strunit_code + "') "; } if (!strperson_code.Equals("")) { strCriteria = strCriteria + " And (person_code= '" + strperson_code + "') "; } if (!strperson_name.Equals("")) { strCriteria = strCriteria + " And (person_thai_name like '%" + strperson_name + "%' " + " OR person_thai_surname like '%" + strperson_name + "%' " + " OR person_eng_name like '%" + strperson_name + "%' " + " OR person_eng_surname like '%" + strperson_name + "%')"; } if (!strperson_work_status_code.Equals("")) { strCriteria = strCriteria + " And (person_work_status_code= '" + strperson_work_status_code + "') "; } if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } if (!struser_group_list.Equals("")) { if (struser_group_list == "User") { strCriteria = strCriteria + " And (user_group_list is null or user_group_list = '') "; } else { strCriteria = strCriteria + " And (user_group_list Like '%" + struser_group_list + "%') "; } } try { if (!oPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { try { GridView1.PageIndex = nPageNo; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch { GridView1.PageIndex = 0; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oPerson.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
private void BindGridView() { InitcboWork_status(); InitcboPerson_group(); cPerson oPerson = new cPerson(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strYear = string.Empty; string strActive = string.Empty; string strperson_group_code = string.Empty; string strperson_group_name = string.Empty; string strunit_code = string.Empty; string strdirector_code = string.Empty; string strperson_code = string.Empty; string strperson_name = string.Empty; string strperson_manage_name = string.Empty; string strperson_work_status_code = string.Empty; strperson_group_code = cboPerson_group.Text; strdirector_code = cboDirector.SelectedValue; strunit_code = cboUnit.SelectedValue; strperson_code = txtperson_code.Text.Replace("'", "''").Trim(); strperson_name = txtperson_name.Text.Replace("'", "''").Trim(); strperson_manage_name = txtperson_manage_name.Text.Replace("'", "''").Trim(); strperson_work_status_code = cboPerson_work_status.SelectedValue; if (!strYear.Equals("")) { strCriteria = strCriteria + " And (budget_plan_year = '" + strYear + "') "; } if (!strperson_group_code.Equals("")) { strCriteria = strCriteria + " And (person_group_code like '%" + strperson_group_code + "%') "; } if (!strdirector_code.Equals("")) { strCriteria = strCriteria + " And (director_code = '" + strdirector_code + "') "; } if (!strunit_code.Equals("")) { strCriteria = strCriteria + " And (unit_code= '" + strunit_code + "') "; } if (!strperson_code.Equals("")) { strCriteria = strCriteria + " And (person_code= '" + strperson_code + "') "; } if (!strperson_manage_name.Equals("")) { strCriteria = strCriteria + " And (person_manage_name like '%" + strperson_manage_name + "%') "; } if (!strperson_name.Equals("")) { strCriteria = strCriteria + " And (person_thai_name like '%" + strperson_name + "%' " + " OR person_thai_surname like '%" + strperson_name + "%' " + " OR person_eng_name like '%" + strperson_name + "%' " + " OR person_eng_surname like '%" + strperson_name + "%'" + " OR '" + strperson_name + "' like ('%'+person_thai_name+'%'+person_thai_surname+'%')) "; } if (!strperson_work_status_code.Equals("")) { strCriteria = strCriteria + " And (person_work_status_code= '" + strperson_work_status_code + "') "; } if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } //strCriteria += " and person_group_code IN (" + PersonGroupList + ") "; //if (DirectorLock == "Y") //{ // strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) "; //} try { if (!oPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { if (ds.Tables[0].Rows.Count == 1) { string strScript = string.Empty; strperson_code = ds.Tables[0].Rows[0]["person_code"].ToString(); strperson_name = ds.Tables[0].Rows[0]["person_thai_name"].ToString() + " " + ds.Tables[0].Rows[0]["person_thai_surname"].ToString(); if (!ViewState["show"].ToString().Equals("1")) { strScript = "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl1"].ToString() + "').value='" + strperson_code + "';\n " + "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl2"].ToString() + "').value='" + strperson_name + "';\n" + "ClosePopUp('" + ViewState["show"].ToString() + "');"; } else { strScript = "window.parent.document.getElementById('" + ViewState["ctrl1"].ToString() + "').value='" + strperson_code + "';\n " + "window.parent.document.getElementById('" + ViewState["ctrl2"].ToString() + "').value='" + strperson_name + "';\n" + "ClosePopUp('" + ViewState["show"].ToString() + "');"; } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "close", strScript, true); } else { ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oPerson.Dispose(); ds.Dispose(); } }
public cLifeStyleVC(cPerson voUser) : base("cLifeStyleVC", null) { _User = voUser; //imgLifestyle.Image = UIImage.FromBundle ("Images/life.png"); //imgLogo.Image = UIImage.FromBundle ("Images/apple.jpg"); }
private void BindGridView(int nPageNo) { InitcboYear(); InitcboWork_status(); InitcboPerson_group(); //InitcboDirector(); // InitcboUnit(); cPerson oPerson = new cPerson(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strYear = string.Empty; string strActive = string.Empty; string strperson_group_code = string.Empty; string strperson_group_name = string.Empty; string strdirector_code = string.Empty; string strunit_code = string.Empty; string strperson_code = string.Empty; string strperson_name = string.Empty; string strperson_work_status_code = string.Empty; strperson_group_code = cboPerson_group.SelectedValue; strdirector_code = cboDirector.SelectedValue; strunit_code = cboUnit.SelectedValue; strperson_work_status_code = cboPerson_work_status.SelectedValue; strYear = cboYear.SelectedValue; strperson_code = txtperson_code.Text.Replace("'", "''").Trim(); strperson_name = txtperson_name.Text.Replace("'", "''").Trim(); if (Request.Form[strPrefixCtr + "cboPerson_work_status"] != null) { strperson_work_status_code = Request.Form[strPrefixCtr + "cboPerson_work_status"].ToString(); } //if (!strYear.Equals("")) //{ // strCriteria = strCriteria + " And (budget_plan_year = '" + strYear + "') "; //} if (!strperson_group_code.Equals("")) { strCriteria = strCriteria + " And (person_group_code like '%" + strperson_group_code + "%') "; } if (!strdirector_code.Equals("")) { strCriteria = strCriteria + " And (director_code = '" + strdirector_code + "') "; } if (!strunit_code.Equals("")) { strCriteria = strCriteria + " And (unit_code= '" + strunit_code + "') "; } if (!strperson_code.Equals("")) { strCriteria = strCriteria + " And (person_code= '" + strperson_code + "') "; } if (!strperson_name.Equals("")) { strCriteria = strCriteria + " And (person_thai_name like '%" + strperson_name + "%' " + " OR person_thai_surname like '%" + strperson_name + "%' " + " OR person_eng_name like '%" + strperson_name + "%' " + " OR person_eng_surname like '%" + strperson_name + "%')"; } if (!strperson_work_status_code.Equals("")) { strCriteria = strCriteria + " And (person_work_status_code= '" + strperson_work_status_code + "') "; } if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } strCriteria += " and person_group_code IN (" + PersonGroupList + ",'') "; if (DirectorLock == "Y") { strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) "; } try { if (!oPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { try { GridView1.PageIndex = nPageNo; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch { GridView1.PageIndex = 0; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oPerson.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
public cResultsVC(cPerson voUser) { _User = voUser; oCalc = new cDeathCalculator(); }
public override void OnCreate() { base.OnCreate(); _oUser = new cPerson(); }
private void BindGridView() { InitcboWork_status(); InitcboPerson_group(); cPerson oPerson = new cPerson(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strYear = string.Empty; string strActive = string.Empty; string strperson_group_code = string.Empty; string strperson_group_name = string.Empty; string strmajor_code = string.Empty; string strperson_code = string.Empty; string strperson_name = string.Empty; string strperson_work_status_code = string.Empty; strperson_group_code = cboPerson_group.Text; strmajor_code = cboMajor.SelectedValue; strperson_code = txtperson_code.Text.Replace("'", "''").Trim(); strperson_name = txtperson_name.Text.Replace("'", "''").Trim(); strperson_work_status_code = cboPerson_work_status.SelectedValue; if (!strYear.Equals("")) { strCriteria = strCriteria + " And (budget_plan_year = '" + strYear + "') "; } if (!strperson_group_code.Equals("")) { strCriteria = strCriteria + " And (person_group_code like '%" + strperson_group_code + "%') "; } if (!strmajor_code.Equals("")) { strCriteria = strCriteria + " And (major_code= '" + strmajor_code + "') "; } if (!strperson_code.Equals("")) { strCriteria = strCriteria + " And (person_code= '" + strperson_code + "') "; } if (!strperson_name.Equals("")) { strCriteria = strCriteria + " And (person_thai_name like '%" + strperson_name + "%' " + " OR person_thai_surname like '%" + strperson_name + "%' " + " OR (person_thai_surname + ' ' +person_eng_surname) like '%" + strperson_name + "%')"; } if (!strperson_work_status_code.Equals("")) { strCriteria = strCriteria + " And (person_work_status_code= '" + strperson_work_status_code + "') "; } if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } strCriteria += " and person_group_code IN (" + PersonGroupList + ") "; if (DirectorLock == "Y") { strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) "; } try { if (!oPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oPerson.Dispose(); ds.Dispose(); } }
private void GotoUserMode(string user_group_code) { //if (user_group_code == "001") //{ // if (SetPersonUserProfile(txtUser.Text, ref _strMessage)) // { // Response.Redirect("Menu_control.aspx"); // } //} //else //{ cUser_group objUserGroup = new cUser_group(); DataTable dt = new DataTable(); DataSet ds = new DataSet(); string strCriteria = " and user_group_code = '" + user_group_code + "' "; string strMessage = string.Empty; objUserGroup.sp_USER_GROUP_SEL(strCriteria, ref ds, ref strMessage); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { this.IsLogin = "******"; this.DirectorLock = Helper.CStr(dt.Rows[0]["director_lock"]); try { this.UnitLock = Helper.CStr(dt.Rows[0]["unit_lock"]); } catch { this.UnitLock = "N"; } if (this.UnitLock == "Y") { this.UnitCodeList = string.Empty; string[] strunit_code_list = Helper.CStr(dt.Rows[0]["unit_code_list"]).Split(','); for (int i = 0; i <= (strunit_code_list.GetUpperBound(0)); i++) { this.UnitCodeList += "'" + strunit_code_list[i].Substring(3, 5) + "',"; } this.UnitCodeList = this.UnitCodeList.Substring(0, this.UnitCodeList.Length - 1); } string[] strperson_group_list = Helper.CStr(dt.Rows[0]["person_group_list"]).Split(','); for (int i = 0; i <= (strperson_group_list.GetUpperBound(0)); i++) { PersonGroupList = PersonGroupList + "'" + strperson_group_list[i] + "',"; } PersonGroupList = PersonGroupList.Substring(0, PersonGroupList.Length - 1); cPerson objPerson = new cPerson(); strCriteria = " And person_code='" + this.PersonCode + "' "; objPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { this.UserLoginName = Helper.CStr(dt.Rows[0]["person_thai_name"]) + " " + Helper.CStr(dt.Rows[0]["person_thai_surname"]); this.DirectorCode = Helper.CStr(dt.Rows[0]["director_code"]); this.DirectorName = Helper.CStr(dt.Rows[0]["director_name"]); Session["username"] = Helper.CStr(dt.Rows[0]["person_thai_name"]) + " " + Helper.CStr(dt.Rows[0]["person_thai_surname"]); } Response.Redirect("Menu_control.aspx"); } // } }
public cResultsVC(cPerson voUser) : base("cResultsVC", null) { _User = voUser; oCalc = new cDeathCalculator(); }
public NavViewController() { oUser = new cPerson(); PhysicalViewController = new cPhysicalVC(oUser); PushViewController(PhysicalViewController, true); }