//double fi_amount = 0.0; //double amountdt = 0.0; //string date = datenew(); protected void Page_Load(object sender, EventArgs e) { strConnection = obj.ConnectionString(); try { userid = Convert.ToInt32(Session["userid"]); } catch { } if (!Page.IsPostBack) { Title = "Tsunami ARMS - Number of inmates Policy"; strConnection = obj.ConnectionString(); con.ConnectionString = strConnection; LoadPolicyTypes(); OdbcCommand aq3 = new OdbcCommand(); aq3.Parameters.AddWithValue("tblname", "m_sub_room_category"); aq3.Parameters.AddWithValue("attribute", "room_cat_id,room_cat_name"); aq3.Parameters.AddWithValue("conditionv", "rowstatus<>2 "); DataTable dtt1f = new DataTable(); dtt1f = objcls.SpDtTbl("call selectcond(?,?,?)", aq3); DataRow row1 = dtt1f.NewRow(); row1["room_cat_id"] = "-1"; row1["room_cat_name"] = "--Select--"; dtt1f.Rows.InsertAt(row1, 0); cmbcategory.DataSource = dtt1f; cmbcategory.DataBind(); SetFocus(txtdate); gridbind(); } }
protected void Page_Load(object sender, EventArgs e) { strConnection = obj.ConnectionString(); try { userid = Convert.ToInt32(Session["userid"]); } catch { } if (!Page.IsPostBack) { Title = "Tsunami ARMS - HouseKeeping Policy"; strConnection = obj.ConnectionString(); con.ConnectionString = strConnection; LoadPolicyTypes(); OdbcCommand cmdurg = new OdbcCommand(); cmdurg.CommandType = CommandType.StoredProcedure; cmdurg.Parameters.AddWithValue("tblname", "m_sub_cmp_urgency"); cmdurg.Parameters.AddWithValue("attribute", "urg_cmp_id,urgname"); cmdurg.Parameters.AddWithValue("conditionv", "rowstatus<>2 order by urgname asc"); DataTable dtturg = objcls.SpDtTbl("CALL selectcond(?,?,?)", cmdurg); if (dtturg.Rows.Count > 0) { DataRow rowdonor = dtturg.NewRow(); rowdonor["urgname"] = "--Select--"; rowdonor["urg_cmp_id"] = "-1"; dtturg.Rows.InsertAt(rowdonor, 0); cmbUrgency.DataSource = dtturg; cmbUrgency.DataBind(); } gridbind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); con.ConnectionString = strConnection; ViewState["option"] = "NIL"; ViewState["action"] = "NIL"; Title = "Tsunami ARMS - Inherit policy "; check(); con = obje.NewConnection(); try { string username = Session["username"].ToString(); OdbcCommand ccm = new OdbcCommand(); ccm.CommandType = CommandType.StoredProcedure; ccm.Parameters.AddWithValue("tblname", "m_user"); ccm.Parameters.AddWithValue("attribute", "user_id"); ccm.Parameters.AddWithValue("conditionv", "username='******'"); OdbcDataAdapter da3 = new OdbcDataAdapter(ccm); DataTable dtt = new DataTable(); dtt = obje.SpDtTbl("CALL selectcond(?,?,?)", ccm); id = int.Parse(dtt.Rows[0][0].ToString()); Session["userid"] = id; } catch { id = 0; Session["userid"] = id; } con = obje.NewConnection(); OdbcCommand cmd10 = new OdbcCommand("select distinct m_sub_season.seasonname from m_sub_season,m_season where m_sub_season.season_sub_id=m_season.season_sub_id " + " and m_season.rowstatus<>2 and m_season.is_current=1", con); OdbcDataReader rd5 = cmd10.ExecuteReader(); while (rd5.Read()) { lstSeasons.Items.Add(rd5[0].ToString()); } string inhseasons = @"SELECT m_season.season_id AS 'id',CONCAT(m_sub_season.seasonname,' ',DATE_FORMAT(m_season.startdate,'%Y')) AS 'season' FROM m_season INNER JOIN m_sub_season ON m_season.season_sub_id=m_sub_season.season_sub_id AND m_season.startdate < CURDATE() ORDER BY m_season.startdate DESC LIMIT 15"; DataTable dtinherit = obje.DtTbl(inhseasons); if (dtinherit.Rows.Count > 0) { DataRow drinherit = dtinherit.NewRow(); drinherit["id"] = "-1"; drinherit["season"] = "--select--"; dtinherit.Rows.InsertAt(drinherit, 0); ddlinhseasons.DataSource = dtinherit; ddlinhseasons.DataBind(); } else { } rd5.Close(); con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string q_counter = "SELECT counter_id,counter_no FROM m_sub_counter ORDER BY counter_id ASC"; DataTable dt_counter = objcls.DtTbl(q_counter); DataRow dr = dt_counter.NewRow(); dr["counter_no"] = "--Select--"; dr["counter_id"] = "-1"; dt_counter.Rows.InsertAt(dr, 0); cmbCounter.DataSource = dt_counter; cmbCounter.DataBind(); cmbCounter.Enabled = false; string q_status = "SELECT id,receipt_status FROM m_receipt_status WHERE rowstatus=0"; DataTable dt_status = objcls.DtTbl(q_status); DataRow dr_status = dt_status.NewRow(); dr_status["receipt_status"] = "--Select--"; dr_status["id"] = "-1"; dt_status.Rows.InsertAt(dr_status, 0); cmbStatus.DataSource = dt_status; cmbStatus.DataBind(); strConnection = obj.ConnectionString(); } }
Page_Load(object sender, EventArgs e) { clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); if (con.State == ConnectionState.Closed) { con.ConnectionString = strConnection; con.Open(); } // // sethyperlink(); Title = " Tsunami ARMS Non Vecating Room Alert"; if (!Page.IsPostBack) { DateTime dt = DateTime.Now; String timeee = dt.ToShortTimeString(); txtsearchtime.Text = timeee.ToString(); string date = dt.ToString("dd-MM-yyyy"); txtdate.Text = date.ToString(); if (txtsearchtime.Text == timeee.ToString()) { notifyIcon1.Visible = true; notifyIcon1.BalloonTipText = "aa"; notifyIcon1.ShowBalloonTip(40, "hk", "rrr", ToolTipIcon.Info); } } #region Grid commented //OdbcDataAdapter da1 = new OdbcDataAdapter("select b.buildingname 'Building', r.roomno 'Roomno',DATE_FORMAT(a.exp_vecatedate,'%d-%m-%Y') 'ExvecatingDate' from t_roomallocation a,m_sub_building b,m_room r where a.exp_vecatedate = curdate() and a.roomstatus=" + 2 + " and b.build_id=r.build_id and a.room_id=r.room_id", con); //DataSet ds1 = new DataSet(); //da1.Fill(ds1, "nonvecatingroomalert"); //GridView1.DataSource = ds1.Tables["nonvecatingroomalert"]; //GridView1.DataBind(); //OdbcDataAdapter da2 = new OdbcDataAdapter("select b.buildingname,a.room_id,r.roomno,v.actualvecdate from t_roomallocation a,t_roomvacate v,m_room r,m_sub_building b where v.alloc_id=a.alloc_id and r.room_id=a.room_id and r.build_id=b.build_id and a.roomstatus =2 and v.actualvecdate = curdate()", con); //DataSet ds2 = new DataSet(); //da2.Fill(ds2, "nonvecatingroomalert"); //GridView2.DataSource = ds2.Tables["nonvecatingroomalert"]; //GridView2.DataBind(); #endregion }//pageload
protected void Page_Load(object sender, EventArgs e) { strConnection = obj.ConnectionString(); try { userid = Convert.ToInt32(Session["userid"]); } catch { } gridbind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); ViewState["option"] = "NIL"; ViewState["action"] = "NIL"; Title = " Tsunami ARMS - User Privilege Settings "; check(); con = obje.NewConnection(); OdbcCommand cmd = new OdbcCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("tblname", "m_sub_form"); cmd.Parameters.AddWithValue("attribute", "distinct form_id,formname,displayname"); cmd.Parameters.AddWithValue("conditionv", "status<>'2' order by displayname asc"); OdbcDataAdapter dacnt3 = new OdbcDataAdapter(cmd); DataTable dtt3 = new DataTable(); dtt3 = obje.SpDtTbl("CALL selectcond(?,?,?)", cmd); for (int ii = 0; ii < dtt3.Rows.Count; ii++) { lstSelectform.Items.Add(dtt3.Rows[ii][2].ToString()); lstSelectform.Items[ii].Text = dtt3.Rows[ii][2].ToString(); lstSelectform.Items[ii].Value = dtt3.Rows[ii][0].ToString(); } try { string username = Session["username"].ToString(); OdbcCommand ccm = new OdbcCommand(); ccm.CommandType = CommandType.StoredProcedure; ccm.Parameters.AddWithValue("tblname", "m_user"); ccm.Parameters.AddWithValue("attribute", "user_id"); ccm.Parameters.AddWithValue("conditionv", "username='******' and rowstatus<>'2'"); OdbcDataAdapter da3 = new OdbcDataAdapter(ccm); DataTable dtt = new DataTable(); dtt = obje.SpDtTbl("CALL selectcond(?,?,?)", ccm); id = int.Parse(dtt.Rows[0][0].ToString()); Session["userid"] = id; } catch { id = 0; Session["userid"] = id; } con.Close(); dguserlevel(); } this.ScriptManager1.SetFocus(txtUserlevel); }
protected void Page_Load(object sender, EventArgs e) { clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); Title = "Tsunami ARMS-Public display"; Label3.Visible = false; TextBox1.Visible = false; if (!Page.IsPostBack) { flag = 0; ViewState["action"] = "NILL"; check(); Addreports(); AlreadyDisplayingReports(); } }
protected void Page_Load(object sender, EventArgs e) { #region UserId try { useid = int.Parse(Session["userid"].ToString()); } catch { okmessage("Warning", "Login Error"); } #endregion #region PostBack if (!Page.IsPostBack) { ViewState["action"] = "NILL"; ViewState["dateset"] = ""; clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); con.ConnectionString = strConnection; //check(); form name not in DB this.ScriptManager1.SetFocus(txtmalyear); try { OdbcCommand criteria5 = new OdbcCommand(); criteria5.Parameters.AddWithValue("tblname", "t_settings"); criteria5.Parameters.AddWithValue("attribute", "mal_year,start_eng_date,end_eng_date"); criteria5.Parameters.AddWithValue("conditionv", "is_current=1"); OdbcDataReader rd1 = objDAL.SpGetReader("CALL selectcond(?,?,?)", criteria5); while (rd1.Read()) { txtmalyear.Text = rd1["mal_year"].ToString(); st2 = rd1["start_eng_date"].ToString(); st3 = rd1["end_eng_date"].ToString(); DateTime dt7 = new DateTime(); DateTime dt8 = new DateTime(); dt7 = DateTime.Parse(st2); dt8 = DateTime.Parse(st3); txtengstartdate.Text = dt7.ToString("dd/MM/yyyy"); txtengenddate.Text = dt8.ToString("dd/MM/yyyy"); } con.Close(); } catch { }; } #endregion try { OdbcCommand criteria5 = new OdbcCommand(); criteria5.Parameters.AddWithValue("tblname", "t_settings"); criteria5.Parameters.AddWithValue("attribute", "cashier_id"); criteria5.Parameters.AddWithValue("conditionv", "is_current=1"); OdbcDataReader rd621 = objDAL.SpGetReader("CALL selectcond(?,?,?)", criteria5); while (rd621.Read()) { ComboBox1.SelectedValue = rd621["cashier_id"].ToString(); } } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); conn.ConnectionString = strConnection; Title = "Tsunami ARMS - Material Return Note"; ViewState["option"] = "NIL"; ViewState["action"] = "NIL"; check(); conn = obje.NewConnection(); try { string username = Session["username"].ToString(); txtReturningOfficer.Text = username.ToString(); OdbcCommand ccm = new OdbcCommand(); ccm.CommandType = CommandType.StoredProcedure; ccm.Parameters.AddWithValue("tblname", "m_user"); ccm.Parameters.AddWithValue("attribute", "user_id"); ccm.Parameters.AddWithValue("conditionv", "username='******'"); OdbcDataAdapter da3 = new OdbcDataAdapter(ccm); DataTable dtt = new DataTable(); dtt = obje.SpDtTbl("CALL selectcond(?,?,?)", ccm); id = int.Parse(dtt.Rows[0][0].ToString()); Session["userid"] = id; } catch { id = 0; Session["userid"] = id; } DateTime date = DateTime.Now; string dt = date.ToString("dd-MM-yyyy"); txtDate.Text = dt.ToString(); IssueStore(); conn = obje.NewConnection(); OdbcCommand Malayalam = new OdbcCommand("select season_id from m_season s,m_sub_season d where curdate()=enddate and s.rowstatus<>'2' and " + "s.season_sub_id=d.season_sub_id and d.rowstatus<>'2' and s.is_current='1'", conn); OdbcDataReader Malr = Malayalam.ExecuteReader(); if (Malr.Read()) { ReceiveDetails(); } else { ViewState["action"] = "Season"; lblOk.Text = "This form will be activated only at end date of this Season"; lblHead.Text = "Tsunami ARMS - Warning"; pnlOk.Visible = true; pnlYesNo.Visible = false; ModalPopupExtender2.Show(); return; } string strRetNo; DateTime yee = DateTime.Now; string year = yee.ToString("yyyy"); Session["year"] = year; conn = obje.NewConnection(); OdbcCommand RecNo = new OdbcCommand("SELECT max(retno) from t_material_retrun", conn); if (Convert.IsDBNull(RecNo.ExecuteScalar()) == true) { strRetNo = "RetNo/" + year + "/" + "0001"; txtRetrun.Text = strRetNo.ToString(); } else { string o1 = RecNo.ExecuteScalar().ToString(); string ab1 = o1.Substring(11, 4); a4 = Convert.ToInt32(ab1); a4 = a4 + 1; if (a4 >= 1000) { strRetNo = "RetNo/" + year + "/" + a4; txtRetrun.Text = strRetNo.ToString(); } else if (a4 >= 100) { strRetNo = "RetNo/" + year + "/0" + a4; txtRetrun.Text = strRetNo.ToString(); } else if (a4 >= 10) { strRetNo = "RetNo/" + year + "/00" + a4; txtRetrun.Text = strRetNo.ToString(); } else if (a4 < 10) { strRetNo = "RetNo/" + year + "/000" + a4; txtRetrun.Text = strRetNo.ToString(); } } conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { clsCommon obj = new clsCommon(); strConnection = obj.ConnectionString(); conn.ConnectionString = strConnection; ViewState["option"] = "NIL"; ViewState["action"] = "NIL"; Title = " Tsunami ARMS - Room Resource Register "; check(); dtitem = additem(); Session["dtItem"] = dtitem; conn = obje.NewConnection(); OdbcCommand Store1 = new OdbcCommand(); Store1.CommandType = CommandType.StoredProcedure; Store1.Parameters.AddWithValue("tblname", "m_sub_building"); Store1.Parameters.AddWithValue("attribute", "build_id,buildingname "); Store1.Parameters.AddWithValue("conditionv", "rowstatus<>'2'"); OdbcDataAdapter Store16 = new OdbcDataAdapter(Store1); DataTable ds1 = new DataTable(); ds1 = obje.SpDtTbl("CALL selectcond(?,?,?)", Store1); DataRow row = ds1.NewRow(); ds1.Rows.InsertAt(row, 0); row["build_id"] = "-1"; row["buildingname"] = "--Select--"; cmbBuilding.DataSource = ds1; cmbBuilding.DataBind(); dtitem = additem(); Session["dtItem"] = dtitem; try { string username = Session["username"].ToString(); OdbcCommand ccm = new OdbcCommand(); ccm.CommandType = CommandType.StoredProcedure; ccm.Parameters.AddWithValue("tblname", "m_user"); ccm.Parameters.AddWithValue("attribute", "user_id"); ccm.Parameters.AddWithValue("conditionv", "username='******'"); OdbcDataAdapter da3 = new OdbcDataAdapter(ccm); DataTable dtt = new DataTable(); dtt = obje.SpDtTbl("CALL selectcond(?,?,?)", ccm); id = int.Parse(dtt.Rows[0][0].ToString()); Session["userid"] = id; } catch { id = 0; Session["userid"] = id; } itemcat(); if (Session["submaster"] == "yes") { cmbBuilding.SelectedValue = Session["building"].ToString(); cmbRoomNo.SelectedValue = Session["room"].ToString(); cmbName.SelectedValue = Session["name"].ToString(); txtIcode.Text = Session["code"].ToString(); cmbItemCategory.SelectedItem.Text = Session["category"].ToString(); txtClass.Text = Session["class"].ToString(); txtModel.Text = Session["model"].ToString(); txtItemMaker.Text = Session["maker"].ToString(); if (Session["item"] == "resource") { this.ScriptManager1.SetFocus(cmbfloor); } else if (Session["item"] == "floornew") { this.ScriptManager1.SetFocus(cmbRoomNo); } Session["submaster"] = "no"; } } pnlinv.Visible = true; pnlroomdetails.Visible = false; pnlinvdetails.Visible = false; RoomInventory(); conn.Close(); }