public bool AddRole(RoleBE role)
{
CommonDAL commondal = new CommonDAL();
SqlConnection con = commondal.Connection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Sp_UM_RolesInsert";
cmd.Parameters.Add("@RoleShortDesc", SqlDbType.VarChar).Value = role.RoleShortDesc;
cmd.Parameters.Add("@RoleLongDesc", SqlDbType.VarChar).Value = role.RoleLongDesc;
cmd.Parameters.Add("@LastModifiedBy", SqlDbType.Int).Value = role.LastModifiedBy;
cmd.Connection = con;
//con.Open();
int count = cmd.ExecuteNonQuery();
con.Close();
if (count > 0)
{
return true;
}
else
{
return false;
}
}
public bool DeleteRole(RoleBE role)
{
int msg = 0;
SqlCommand cmd = new SqlCommand();
CommonDAL commondal = new CommonDAL();
SqlConnection con = commondal.Connection();
cmd = new SqlCommand("Sp_UM_RolesDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoleId", SqlDbType.Int).Value = role.RoleId;
cmd.Parameters.Add("@ReturnCode", System.Data.SqlDbType.Int);
cmd.Parameters["@ReturnCode"].Direction = ParameterDirection.Output;
//con.Open();
int count = cmd.ExecuteNonQuery();
msg = Convert.ToInt32(cmd.Parameters["@ReturnCode"].Value);
con.Close();
if (msg==0)
{
return true;
}
else
{
return false;
}
}
public bool ModifyRole(RoleBE role)
{
RoleDAL roleDAL = new RoleDAL();
if (roleDAL.ModifyRole(role))
{
return true;
}
else
{
return false;
}
}
public bool DeleteRole(RoleBE role)
{
RoleDAL roleDAL = new RoleDAL();
if (roleDAL.DeleteRole(role))
{
return true;
}
else
{
return false;
}
}
protected void btnAddRole_Click(object sender, EventArgs e)
{
if (!commonBAL.isUserAuthorisedForPageFunc(LoggedInUser.UserId, thisPageName, "add"))
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("You are not authorised to Perform any operation on this page. Please contact system administrator.", false);
// Server.Transfer("UM_BlankPage.aspx"); //?? send Message through Query String to the BlankPage
// string cat = Request.QueryString["Message"];
// Response.Redirect("UM_BlankPage.aspx?Message=You are not authorised to Perform any operation on this page. Please contact system administrator.");
return;
}
if (ValidData())
{
}
else
{
UserBE user = (UserBE)Session["LoggedInUser"];
RoleBE addRoleBE = new RoleBE();
RoleDAL addRoleDal = new RoleDAL();
RoleBAL addRoleBal = new RoleBAL();
addRoleBE.RoleShortDesc = txtRoleShortDesc.Text;
addRoleBE.RoleLongDesc = txtRoleLongDesc.Text;
addRoleBE.LastModifiedBy = user.UserId;
if (addRoleBal.AddRole(addRoleBE))
{
txtRoleShortDesc.Text = "";
txtRoleLongDesc.Text = "";
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Record Inserted Successfully.", true);
}
else
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Unsuccessful.", false);
}
}
}
public bool ViewRole(RoleBE role)
{
CommonDAL commondal = new CommonDAL();
SqlConnection con = commondal.Connection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("Sp_UM_GetAllRolesByRoleID", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@RoleId ", SqlDbType.Int);
p1.Direction = ParameterDirection.Input;
p1.Value = role.RoleId;
da.SelectCommand.Parameters.Add(p1);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
//string title = ds.Tables[0].Rows[0]["Title"].ToString();
role.RoleShortDesc = dt.Rows[0]["RoleLongDesc"].ToString();
return true;
}
else
{
return false;
}
}
//protected void btnUpdate_Click(object sender, EventArgs e)
//{
// RoleBE role = new RoleBE();
// RoleBAL roleBAL = new RoleBAL();
// role.RoleId = Convert.ToInt32(hdnRoleUpdateId.Value);
// //role.RoleShortDesc = txtRoleShortDesc.Text;
// //role.RoleLongDesc = txtRolelongDesc.Text;
// role.LastModifiedBy = ((UserBE)Session["LoggedInUser"]).UserId;
// if (roleBAL.ModifyRole(role))
// {
// LvRoleItems.EditIndex = -1;
// bind();
// recalcNoOfPages();
// LoggedIn master = (LoggedIn)this.Master;
// master.ShowMessage("Role successfully Updated.", true);
// }
// else
// {
// LoggedIn master = (LoggedIn)this.Master;
// master.ShowMessage("Unsuccessful", true);
// }
//}
//protected void btnCancel_Click(object sender, EventArgs e)
//{
// LvRoleItems.EditIndex = -1;
// bind();
// recalcNoOfPages();
//}
protected void btnDeleteYes_Click(object sender, EventArgs e)
{
RoleBE role = new RoleBE();
RoleBAL roleBAL = new RoleBAL();
int RoleId = Convert.ToInt32(hdnRoleId.Value);
role.RoleId = Convert.ToInt32(RoleId);
if (roleBAL.DeleteRole(role))
{
if (LvRoleItems.Items.Count == 1)
{
RoleDataPager.SetPageProperties(RoleDataPager.TotalRowCount - RoleDataPager.PageSize - 1,
RoleDataPager.PageSize, true);
bind();
recalcNoOfPages();
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Role successfully deleted.", true);
}
else
{
LvRoleItems.EditIndex = -1;
bind();
recalcNoOfPages();
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Role successfully deleted.", true);
}
}
else
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Sorry You cannot delete Role because it is already in use", false);
recalcNoOfPages();
}
}
void UCRoleAddList_btnUpdateClick(object sender, EventArgs e)
{
RoleBE role = new RoleBE();
RoleBAL roleBAL = new RoleBAL();
role.RoleId = Convert.ToInt32(hdnRoleUpdateId.Value);
role.RoleShortDesc = UCRoleAddList.ShortDesc;
role.RoleLongDesc = UCRoleAddList.LongDesc;
role.LastModifiedBy = ((UserBE)Session["LoggedInUser"]).UserId;
if (roleBAL.ModifyRole(role))
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Role successfully Updated.", true);
LvRoleItems.EditIndex = -1;
bind();
recalcNoOfPages();
}
else
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Unsuccessful", true);
}
}
protected void LvRoleItems_OnItemCommand(object sender, ListViewCommandEventArgs e)
{
UM_UC_RoleAdd roleAdd = new UM_UC_RoleAdd();
HtmlTableRow SelectedRow;
if (e.Item.DisplayIndex % 2 == 0) //even
{
SelectedRow = e.Item.FindControl("trItemTemplate") as HtmlTableRow;
}
else //odd
{
SelectedRow = e.Item.FindControl("trAltItemTemplate") as HtmlTableRow;
}
SelectedRow.BgColor = "Red";
if (String.Equals(e.CommandName, "Delete"))
{
if (!commonBAL.isUserAuthorisedForPageFunc(LoggedInUser.UserId, thisPageName, "delete"))
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("You are not authorised to perform this function. Please contact system administrator.", false);
return;
}
RoleBE role = new RoleBE();
string[] arg = new string[3];
arg = e.CommandArgument.ToString().Split(',');
hdnRoleId.Value = arg[0].ToString();
role.RoleShortDesc = arg[1].ToString();
role.RoleLongDesc = arg[2].ToString();
RoleShortDescText.Text = role.RoleShortDesc;
RoleLongDescText.Text = role.RoleLongDesc;
mpe_DeleteRole.Show();
}
if (String.Equals(e.CommandName, "Edit"))
{
if (!commonBAL.isUserAuthorisedForPageFunc(LoggedInUser.UserId, thisPageName, "edit"))
{
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("You are not authorised to perform this function. Please contact system administrator.", false);
return;
}
RoleBE role = new RoleBE();
string[] arg = new string[5];
arg = e.CommandArgument.ToString().Split(',');
hdnRoleUpdateId.Value = arg[0].ToString();
role.RoleShortDesc = arg[1].ToString();
role.RoleLongDesc = arg[2].ToString();
string lastModifiedBy = arg[3].ToString();
string lastModifiedAt = arg[4].ToString();
UCRoleAddList.RoleId = Convert.ToInt32(hdnRoleUpdateId.Value);
UCRoleAddList.ShortDesc = role.RoleShortDesc;
UCRoleAddList.LongDesc = role.RoleLongDesc;
UCRoleAddList.LastModifiedBy = lastModifiedBy;
UCRoleAddList.LastModifiedAt = lastModifiedAt;
mpe_EditRole.Show();
}
}
