protected void btnSave_Click(object sender, EventArgs e)
{
var userID = ddlUsers.SelectedValue.ToString();
foreach (GridViewRow row in gvFormRights.Rows)
{
var lblFormID = (Label)row.FindControl("lblFormID");
var chkInsertRight = (CheckBox)row.FindControl("chkInsertRight");
var chkUpdateRight = (CheckBox)row.FindControl("chkUpdateRight");
var chkDeleteRight = (CheckBox)row.FindControl("chkDeleteRight");
var chkSelectRight = (CheckBox)row.FindControl("chkSelectRight");
FormRights fright = new FormRights();
fright.UserID = userID;
fright.FormID = int.Parse(lblFormID.Text);
fright.SelectRight = chkSelectRight.Checked == true ? true : false;
fright.InsertRight = chkInsertRight.Checked == true ? true : false;
fright.UpdateRight = chkUpdateRight.Checked == true ? true : false;
fright.DeleteRight = chkDeleteRight.Checked == true ? true : false;
bool result = FormRightsManager.UpdateFormRights(fright);
if (userID != "0")
{
gvFormRights.DataSource = FormRightsManager.GetFormByUserID(userID);
}
gvFormRights.DataBind();
}
}
public void SetPermission()
{
MembershipUser currentUser;
currentUser = Membership.GetUser();
if (currentUser == null)
{
Response.Redirect("~/login.aspx");
}
var clientID = currentUser.ProviderUserKey.ToString();
string pageName = "AddCustomer";
if (fright != null)
{
fright = FormRightsManager.GetFormRightsByUserIDFormID(pageName, clientID);
//update option
btnAddAppointment.Visible = fright.UpdateRight == true ? true : false;
btnAddAppointment.Visible = fright.InsertRight == true ? true : false;
}
//GlobalFunction gf = new GlobalFunction();
//GlobalFunction.SetFormPermission(this, fright);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.User.Identity.IsAuthenticated)
{
Response.Redirect("~/login.aspx");
}
MembershipUser currentUser;
currentUser = Membership.GetUser();
if (currentUser == null)
Response.Redirect("~/login.aspx");
var clientID = currentUser.ProviderUserKey.ToString();
string pageName = "AdminDisplayClient";
fright = FormRightsManager.GetFormRightsByUserIDFormID(pageName, clientID);
string name = HttpContext.Current.User.Identity.Name;
if (!string.IsNullOrEmpty(name))
{
if (name.Equals("admin"))
{
//HyperLink1.NavigateUrl = "Admin.aspx";
}
else
{
//HyperLink1.NavigateUrl = "SalesAgent.aspx";
}
}
}
public static FormRights GetFormRightsByFormRightsID(int FormRightsID)
{
FormRights formRights = new FormRights();
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
formRights = sqlFormRightsProvider.GetFormRightsByFormRightsID(FormRightsID);
return formRights;
}
public static FormRights GetFormRightsByUserIDFormID(string FormID, string userID)
{
FormRights formRights = new FormRights();
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
formRights = sqlFormRightsProvider.GetFormRightsByUserIDFormID(FormID, userID);
return(formRights);
}
public static FormRights GetFormRightsByFormRightsID(int FormRightsID)
{
FormRights formRights = new FormRights();
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
formRights = sqlFormRightsProvider.GetFormRightsByFormRightsID(FormRightsID);
return(formRights);
}
public void SetPermission()
{
MembershipUser currentUser;
currentUser = Membership.GetUser();
if (currentUser == null)
{
Response.Redirect("~/login.aspx");
}
var clientID = currentUser.ProviderUserKey.ToString();
string pageName = "AdminDisplayClient";
fright = FormRightsManager.GetFormRightsByUserIDFormID(pageName, clientID);
}
public bool UpdateFormRights(FormRights formRights)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateFormRights", connection);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@FormRightsID", SqlDbType.Int).Value = formRights.FormRightsID;
cmd.Parameters.Add("@FormID", SqlDbType.Int).Value = formRights.FormID;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = formRights.UserID;
cmd.Parameters.Add("@InsertRight", SqlDbType.Bit).Value = formRights.InsertRight;
cmd.Parameters.Add("@UpdateRight", SqlDbType.Bit).Value = formRights.UpdateRight;
cmd.Parameters.Add("@DeleteRight", SqlDbType.Bit).Value = formRights.DeleteRight;
cmd.Parameters.Add("@SelectRight", SqlDbType.Bit).Value = formRights.SelectRight;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser;
currentUser = Membership.GetUser();
if (currentUser == null)
{
Response.Redirect("~/login.aspx");
}
if (currentUser.UserName != "admin")
{
dvUserManagement.Visible = false;
}
var clientID = currentUser.ProviderUserKey.ToString();
string pageName = "AdminDisplayClient";
fright = FormRightsManager.GetFormRightsByUserIDFormID(pageName, clientID);
}
public FormRights GetFormRightsFromReader(IDataReader reader)
{
try
{
FormRights formRights = new FormRights
(
DataAccessObject.IsNULL <int>(reader["FormRightsID"]),
DataAccessObject.IsNULL <int>(reader["FormID"]),
DataAccessObject.IsNULL <string>(reader["UserID"].ToString()),
DataAccessObject.IsNULL <bool>(reader["InsertRight"]),
DataAccessObject.IsNULL <bool>(reader["UpdateRight"]),
DataAccessObject.IsNULL <bool>(reader["DeleteRight"]),
DataAccessObject.IsNULL <bool>(reader["SelectRight"])
);
return(formRights);
}
catch (Exception ex)
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.User.Identity.IsAuthenticated)
{
Response.Redirect("~/login.aspx");
}
MembershipUser currentUser;
currentUser = Membership.GetUser();
if (currentUser == null)
{
Response.Redirect("~/login.aspx");
}
var clientID = currentUser.ProviderUserKey.ToString();
string pageName = "AdminDisplayClient";
fright = FormRightsManager.GetFormRightsByUserIDFormID(pageName, clientID);
string name = HttpContext.Current.User.Identity.Name;
if (!string.IsNullOrEmpty(name))
{
if (name.Equals("admin"))
{
//HyperLink1.NavigateUrl = "Admin.aspx";
}
else
{
//HyperLink1.NavigateUrl = "SalesAgent.aspx";
}
}
}
public bool UpdateFormRights(FormRights formRights)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateFormRights", connection);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@FormRightsID", SqlDbType.Int).Value = formRights.FormRightsID;
cmd.Parameters.Add("@FormID", SqlDbType.Int).Value = formRights.FormID;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = formRights.UserID;
cmd.Parameters.Add("@InsertRight", SqlDbType.Bit).Value = formRights.InsertRight;
cmd.Parameters.Add("@UpdateRight", SqlDbType.Bit).Value = formRights.UpdateRight;
cmd.Parameters.Add("@DeleteRight", SqlDbType.Bit).Value = formRights.DeleteRight;
cmd.Parameters.Add("@SelectRight", SqlDbType.Bit).Value = formRights.SelectRight;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public FormRights GetFormRightsFromReader(IDataReader reader)
{
try
{
FormRights formRights = new FormRights
(
DataAccessObject.IsNULL<int>(reader["FormRightsID"]),
DataAccessObject.IsNULL<int>(reader["FormID"]),
DataAccessObject.IsNULL<string>(reader["UserID"].ToString()),
DataAccessObject.IsNULL<bool>(reader["InsertRight"]),
DataAccessObject.IsNULL<bool>(reader["UpdateRight"]),
DataAccessObject.IsNULL<bool>(reader["DeleteRight"]),
DataAccessObject.IsNULL<bool>(reader["SelectRight"])
);
return formRights;
}
catch(Exception ex)
{
return null;
}
}
public static int InsertFormRights(FormRights formRights)
{
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
return(sqlFormRightsProvider.InsertFormRights(formRights));
}
public static int InsertFormRights(FormRights formRights)
{
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
return sqlFormRightsProvider.InsertFormRights(formRights);
}
public static FormRights GetFormRightsByUserIDFormID(string FormID, string userID)
{
FormRights formRights = new FormRights();
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
formRights = sqlFormRightsProvider.GetFormRightsByUserIDFormID(FormID, userID);
return formRights;
}
public static bool UpdateFormRights(FormRights formRights)
{
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
return sqlFormRightsProvider.UpdateFormRights(formRights);
}
private void SaveProfile(string username)
{
ProfileCommon p = (ProfileCommon)ProfileCommon.Create(username, true);
Profile.FirstName = txtFirstName.Text;
Profile.LastName = txtLastName.Text;
Profile.Address = txtAddress.Text;
Profile.City = txtCity.Text;
Profile.PostalCode = txtZipcode.Text;
Profile.State = txtState.Text;
Profile.Country = "USA";
Profile.Save();
MembershipUser myObject = Membership.GetUser(username);
if (chckCopyPermission.Checked)
{
var uName = ddlUserList.SelectedItem.Value;
DataSet userRight = FormRightsManager.GetFormByUserID(uName);
foreach (DataRow dr in userRight.Tables[0].Rows)
{
var chkInsertRight = bool.Parse(dr["InsertRight"].ToString());
var chkUpdateRight = bool.Parse(dr["UpdateRight"].ToString());
var chkDeleteRight = bool.Parse(dr["DeleteRight"].ToString());
var chkSelectRight = bool.Parse(dr["SelectRight"].ToString());
var FormID = int.Parse(dr["FormID"].ToString());
FormRights fright = new FormRights();
fright.UserID = myObject.ProviderUserKey.ToString();
fright.FormID = FormID;
fright.SelectRight = chkSelectRight;
fright.InsertRight = chkInsertRight;
fright.UpdateRight = chkUpdateRight;
fright.DeleteRight = chkDeleteRight;
bool result = FormRightsManager.UpdateFormRights(fright);
}
}
else
{
var chkInsertRight = false;
var chkUpdateRight = false;
var chkDeleteRight = false;
var chkSelectRight = false;
DataSet formName = FormsManager.GetAllFormss();
foreach (DataRow dr in formName.Tables[0].Rows)
{
FormRights fright = new FormRights();
fright.UserID = myObject.ProviderUserKey.ToString();
fright.FormID = int.Parse(dr["FormsID"].ToString());;
fright.SelectRight = chkSelectRight;
fright.InsertRight = chkInsertRight;
fright.UpdateRight = chkUpdateRight;
fright.DeleteRight = chkDeleteRight;
bool result = FormRightsManager.UpdateFormRights(fright);
}
}
}
public static bool UpdateFormRights(FormRights formRights)
{
SqlFormRightsProvider sqlFormRightsProvider = new SqlFormRightsProvider();
return(sqlFormRightsProvider.UpdateFormRights(formRights));
}
