protected void dgUserMst_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dtPermis = PermisManager.GetPermiss(dgUserMst.SelectedRow.Cells[1].Text.Trim());
dgUserMst.Visible = false;
dgPermis.Visible = true;
txtUserName.Text = dgUserMst.SelectedRow.Cells[1].Text.ToString().Trim();
txtDesc.Text = dgUserMst.SelectedRow.Cells[2].Text.ToString().Trim();
DataTable dtModules = PermisManager.getModules();
DataTable dtModule = PermisManager.getModulesUser(dgUserMst.SelectedRow.Cells[1].Text.Trim());
if (dtPermis.Rows.Count == 0 | dtModules.Rows.Count != dtPermis.Rows.Count)
{
DataRow drPermis;
string add = "", edit = "", view = "", delete = "", print = "", autho = "";
foreach (DataRow dr in dtModule.Rows)
{
add = "N"; edit = "N"; view = "Y"; delete = "N"; print = "Y"; autho = "N";
drPermis = dtPermis.NewRow();
drPermis["user_name"] = dgUserMst.SelectedRow.Cells[1].Text.Trim();
drPermis["mod_id"] = dr["mod_id"].ToString();
drPermis["mod_name"] = dr["description"].ToString();
if (dgUserMst.SelectedRow.Cells[3].Text.ToString().Trim() == "Operator")
{
add = "N"; edit = "N"; view = "N"; delete = "N"; print = "N"; autho = "N";
}
else if (dgUserMst.SelectedRow.Cells[3].Text.ToString().Trim() == "Supervisor")
{
add = "N"; edit = "N"; view = "Y"; delete = "N"; print = "Y"; autho = "Y";
}
else if (dgUserMst.SelectedRow.Cells[3].Text.ToString().Trim() == "Evaluator")
{
add = "N"; edit = "N"; view = "Y"; delete = "N"; print = "Y"; autho = "Y";
}
else if (dgUserMst.SelectedRow.Cells[3].Text.ToString().Trim() == "Administrator")
{
add = "Y"; edit = "Y"; view = "Y"; delete = "Y"; print = "Y"; autho = "Y";
}
else
{
add = "N"; edit = "N"; view = "Y"; delete = "N"; print = "Y"; autho = "N";
}
drPermis["allow_add"] = add;
drPermis["allow_edit"] = edit;
drPermis["allow_view"] = view;
drPermis["allow_delete"] = delete;
drPermis["allow_print"] = print;
drPermis["allow_autho"] = autho;
dtPermis.Rows.Add(drPermis);
}
ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('No or Some permission was created previously!!');", true);
}
dgPermis.Visible = true;
dgPermis.DataSource = dtPermis;
dgPermis.DataBind();
Session["perm"] = dtPermis;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtUserName.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('Nothing to save!!');", true);
}
else
{
Permis per;
DataTable dtPermis = (DataTable)Session["perm"];
foreach (DataRow dr in dtPermis.Rows)
{
per = PermisManager.getPermis(txtUserName.Text.ToString().Trim(), dr["mod_id"].ToString());
if (per == null)
{
per = new Permis();
per.UserName = txtUserName.Text.ToString().Trim();
per.ModId = dr["mod_id"].ToString();
per.AllowAdd = dr["allow_add"].ToString();
per.AllowEdit = dr["allow_Edit"].ToString();
per.AllowView = dr["allow_View"].ToString();
per.AllowDelete = dr["allow_delete"].ToString();
per.AllowPrint = dr["allow_print"].ToString();
per.AllowAutho = dr["allow_autho"].ToString();
PermisManager.CreatePermis(per);
}
else
{
if (per.AllowAdd != dr["allow_add"].ToString() | per.AllowEdit != dr["allow_Edit"].ToString() |
per.AllowView != dr["allow_View"].ToString() | per.AllowDelete != dr["allow_delete"].ToString() |
per.AllowPrint != dr["allow_print"].ToString() | per.AllowAutho != dr["allow_autho"].ToString())
{
per.AllowAdd = dr["allow_add"].ToString();
per.AllowEdit = dr["allow_Edit"].ToString();
per.AllowView = dr["allow_View"].ToString();
per.AllowDelete = dr["allow_delete"].ToString();
per.AllowPrint = dr["allow_print"].ToString();
per.AllowAutho = dr["allow_autho"].ToString();
PermisManager.UpdatePermis(per);
}
}
}
ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('Saved successfully!!');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["user"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
string pageName = DataManager.GetCurrentPageName();
string modid = PermisManager.getModuleId(pageName);
per = PermisManager.getUsrPermis(Session["user"].ToString().Trim().ToUpper(), modid);
if (per != null && per.AllowView == "Y")
{
((Label)Page.Master.FindControl("lblLogin")).Text = Session["wnote"].ToString();
((LinkButton)Page.Master.FindControl("lbLogout")).Visible = true;
}
else
{
Response.Redirect("Default.aspx");
}
}
}
catch
{
Response.Redirect("Default.aspx");
}
txtOpenDate.Attributes.Add("onBlur", "formatdate('" + txtOpenDate.ClientID + "')");
if (!IsPostBack)
{
DataTable dtLvl = LvlManager.GetLevels();
dgLevel.DataSource = dtLvl;
dgLevel.DataBind();
dgGlCoaGen.DataSource = LvlManager.GetLevelsGrid();
dgGlCoaGen.DataBind();
Populate();
TreeView1.CollapseAll();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
if (Session.SessionID != "" | Session.SessionID != null)
{
clsSession ses = clsSessionManager.getSession(Session.SessionID);
if (ses != null)
{
Session["user"] = ses.UserId; Session["wnote"] = UsersManager.getUserName(ses.UserId);
Session["book"] = "AMB";
string connectionString = DataManager.OraConnString();
SqlDataReader dReader;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select ID,user_grp,description from utl_userinfo where upper(user_name)=upper('" + Session["user"].ToString().ToUpper() + "') and status='A'";
conn.Open();
dReader = cmd.ExecuteReader();
string wnot = "";
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["userlevel"] = int.Parse(dReader["user_grp"].ToString());
wnot = dReader["description"].ToString();
}
Session["wnote"] = wnot;
Session["USER_ID"] = dReader["ID"].ToString();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select book_desc,company_address1,company_address2,separator_type from gl_set_of_books where book_name='" + Session["book"].ToString() + "' ";
if (dReader.IsClosed == false)
{
dReader.Close();
}
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["septype"] = dReader["separator_type"].ToString();
Session["org"] = dReader["book_desc"].ToString();
Session["add1"] = dReader["company_address1"].ToString();
Session["add2"] = dReader["company_address2"].ToString();
}
}
}
dReader.Close();
conn.Close();
}
}
}
try
{
string pageName = DataManager.GetCurrentPageName();
string modid = PermisManager.getModuleId(pageName);
per = PermisManager.getUsrPermis(Session["user"].ToString().Trim().ToUpper(), modid);
if (per != null & per.AllowView == "Y")
{
((Label)Page.Master.FindControl("lblLogin")).Text = Session["wnote"].ToString();
((LinkButton)Page.Master.FindControl("lbLogout")).Visible = true;
}
else
{
Response.Redirect("Home.aspx?sid=sam");
}
}
catch
{
Response.Redirect("Default.aspx?sid=sam");
}
if (!IsPostBack)
{
RefreshAll();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
if (Session.SessionID != "" | Session.SessionID != null)
{
clsSession ses = clsSessionManager.getSession(Session.SessionID);
if (ses != null)
{
Session["user"] = ses.UserId;
Session["book"] = "AMB";
string connectionString = DataManager.OraConnString();
SqlDataReader dReader;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select user_grp,description from utl_userinfo where upper(user_name)=upper('" + Session["user"].ToString().ToUpper() + "') and status='A'";
conn.Open();
dReader = cmd.ExecuteReader();
string wnot = "";
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["userlevel"] = int.Parse(dReader["user_grp"].ToString());
wnot = "KHSC Mr. " + dReader["description"].ToString();
}
Session["wnote"] = wnot;
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select book_desc,company_address1,company_address2,separator_type from gl_set_of_books where book_name='" + Session["book"].ToString() + "' ";
if (dReader.IsClosed == false)
{
dReader.Close();
}
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["septype"] = dReader["separator_type"].ToString();
Session["org"] = dReader["book_desc"].ToString();
Session["add1"] = dReader["company_address1"].ToString();
Session["add2"] = dReader["company_address2"].ToString();
}
}
}
dReader.Close();
conn.Close();
}
}
}
try
{
//ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('" + Session.SessionID + "');", true);
string pageName = DataManager.GetCurrentPageName();
string modid = PermisManager.getModuleId(pageName);
per = PermisManager.getUsrPermis(Session["user"].ToString().Trim().ToUpper(), modid);
if (per != null & per.AllowView == "Y")
{
((Label)Page.Master.FindControl("lblLogin")).Text = Session["wnote"].ToString();
((LinkButton)Page.Master.FindControl("lbLogout")).Visible = true;
}
else
{
Response.Redirect("Home.aspx?sid=sam");
}
}
catch
{
Response.Redirect("Default.aspx?sid=sam");
}
if (!Page.IsPostBack)
{
DataTable dt = clsDesigManager.getDesigDetails("");
dgDesig.DataSource = dt;
dgDesig.DataBind();
ddlMgrCode.Items.Clear();
string queryDesig = "select '' desig_code, '' desig_name union select desig_code,dbo.initcap(desig_name) desig_name from pmis_desig_code order by 2 desc";
util.PopulationDropDownList(ddlMgrCode, "Designation", queryDesig, "desig_name", "desig_code");
/*ddlGradeCode.Items.Clear();
* string queryScale = "select '' scale_detail_id, '' scale union select convert(scale_detail_id),scale from v_scale order by 2 desc";
* util.PopulationDropDownList(ddlGradeCode, "Scale", queryScale, "scale", "scale_detail_id");
*/
ddlClass.Items.Clear();
string queryClass = "select '' class_id, '' class_name union select convert(varchar,class_id),class_name from pmis_class order by 2 desc";
util.PopulationDropDownList(ddlClass, "Scale", queryClass, "class_name", "class_id");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
if (Session.SessionID != "" | Session.SessionID != null)
{
clsSession ses = clsSessionManager.getSession(Session.SessionID);
if (ses != null)
{
Session["user"] = ses.UserId;
Session["book"] = "AMB";
string connectionString = DataManager.OraConnString();
SqlDataReader dReader;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select user_grp,description from utl_userinfo where upper(user_name)=upper('" + Session["user"].ToString().ToUpper() + "') and status='A'";
conn.Open();
dReader = cmd.ExecuteReader();
string wnot = "";
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["userlevel"] = int.Parse(dReader["user_grp"].ToString());
wnot = dReader["description"].ToString();
}
Session["wnote"] = wnot;
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select book_desc,company_address1,company_address2,separator_type from gl_set_of_books where book_name='" + Session["book"].ToString() + "' ";
if (dReader.IsClosed == false)
{
dReader.Close();
}
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["septype"] = dReader["separator_type"].ToString();
Session["org"] = dReader["book_desc"].ToString();
Session["add1"] = dReader["company_address1"].ToString();
Session["add2"] = dReader["company_address2"].ToString();
}
}
}
dReader.Close();
conn.Close();
}
}
}
try
{
string pageName = DataManager.GetCurrentPageName();
string modid = PermisManager.getModuleId(pageName);
per = PermisManager.getUsrPermis(Session["user"].ToString().Trim().ToUpper(), modid);
if (per != null && per.AllowView == "Y")
{
((Label)Page.Master.FindControl("lblLogin")).Text = Session["wnote"].ToString();
((LinkButton)Page.Master.FindControl("lbLogout")).Visible = true;
}
else
{
Response.Redirect("Default.aspx?sid=sam");
}
}
catch
{
Response.Redirect("Default.aspx?sid=sam");
}
if (!IsPostBack)
{
try
{
DataTable dt = StudentManager.GetStudentAllCurrentStatus("", "", "", "");
dgPayHistory.DataSource = dt;
dgPayHistory.DataBind();
}
catch (FormatException fex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true);
}
catch (Exception ex)
{
if (ex.Message.Contains("Database"))
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
if (Session.SessionID != "" | Session.SessionID != null)
{
clsSession ses = clsSessionManager.getSession(Session.SessionID);
if (ses != null)
{
Session["user"] = ses.UserId; Session["book"] = "AMB";
string connectionString = DataManager.OraConnString();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string query = "Select user_grp,description from utl_userinfo where upper(user_name)=upper('" + Session["user"].ToString().ToUpper() + "') and status='A'";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
using (SqlDataReader dreader = cmd.ExecuteReader())
{
if (dreader.HasRows == true)
{
while (dreader.Read())
{
Session["userlevel"] = int.Parse(dreader["user_grp"].ToString());
Session["wnote"] = "Welcome Mr. " + dreader["description"].ToString();
}
}
}
}
}
using (SqlConnection conn = new SqlConnection(connectionString))
{
string query = "Select book_desc,company_address1,company_address2,separator_type from gl_set_of_books where book_name='" + Session["book"].ToString() + "' ";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
using (SqlDataReader dreader = cmd.ExecuteReader())
{
if (dreader.HasRows == true)
{
while (dreader.Read())
{
Session["septype"] = dreader["separator_type"].ToString();
Session["org"] = dreader["book_desc"].ToString();
Session["add1"] = dreader["company_address1"].ToString();
Session["add2"] = dreader["company_address2"].ToString();
}
}
}
}
}
}
}
}
try
{
//ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('" + ViewState.ViewStateID + "');", true);
string pageName = DataManager.GetCurrentPageName();
string modid = PermisManager.getModuleId(pageName);
per = PermisManager.getUsrPermis(Session["user"].ToString().Trim().ToUpper(), modid);
if (per != null && per.AllowView == "Y")
{
((Label)Page.Master.FindControl("lblLogin")).Text = Session["wnote"].ToString();
((LinkButton)Page.Master.FindControl("lbLogout")).Visible = true;
}
else
{
Response.Redirect("Default.aspx?sid=sam");
}
}
catch
{
//ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('"+ex.Message+"!!');", true);
Response.Redirect("Default.aspx?sid=sam");
}
if (!IsPostBack)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
if (Session.SessionID != "" | Session.SessionID != null)
{
clsSession ses = clsSessionManager.getSession(Session.SessionID);
if (ses != null)
{
Session["user"] = ses.UserId;
Session["book"] = "AMB";
string connectionString = DataManager.OraConnString();
SqlDataReader dReader;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select user_grp,description from utl_userinfo where upper(user_name)=upper('" + Session["user"].ToString().ToUpper() + "') and status='A'";
conn.Open();
dReader = cmd.ExecuteReader();
string wnot = "";
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["userlevel"] = int.Parse(dReader["user_grp"].ToString());
wnot = "KHSC Mr. " + dReader["description"].ToString();
}
Session["wnote"] = wnot;
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select book_desc,company_address1,company_address2,separator_type from gl_set_of_books where book_name='" + Session["book"].ToString() + "' ";
if (dReader.IsClosed == false)
{
dReader.Close();
}
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
{
Session["septype"] = dReader["separator_type"].ToString();
Session["org"] = dReader["book_desc"].ToString();
Session["add1"] = dReader["company_address1"].ToString();
Session["add2"] = dReader["company_address2"].ToString();
}
}
}
dReader.Close();
conn.Close();
}
}
}
try
{
//ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('" + Session.SessionID + "');", true);
string pageName = DataManager.GetCurrentPageName();
string modid = PermisManager.getModuleId(pageName);
per = PermisManager.getUsrPermis(Session["user"].ToString().Trim().ToUpper(), modid);
if (per != null & per.AllowView == "Y")
{
((Label)Page.Master.FindControl("lblLogin")).Text = Session["wnote"].ToString();
((LinkButton)Page.Master.FindControl("lbLogout")).Visible = true;
}
else
{
Response.Redirect("Home.aspx?sid=sam");
}
}
catch
{
Response.Redirect("Default.aspx?sid=sam");
}
if (!Page.IsPostBack)
{
//string queryBank = "select '' BANK_ID, '' BANK_NAME union select BANK_ID,BANK_NAME from BANK_INFO order by 1";
//util.PopulationDropDownList(ddlBankNo, "Bank", queryBank, "BANK_NAME", "BANK_ID");
}
}
