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