public bool UpdateRoleScreenMap(RoleScreenMap data)
{
bool updated = false;
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("RoleScreenMap_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@GUID", data.GUID);
cmd.Parameters.AddWithValue("@AllowAccess", data.AllowAccess);
cmd.Parameters.AddWithValue("@AllowAction", data.AllowAction);
try
{
con.Open();
cmd.ExecuteNonQuery();
updated = true;
}
catch (Exception e)
{
string error = e.Message;
updated = false;
}
finally
{
con.Close();
}
return(updated);
}
public bool GiveAndTakeAccess(string ScreenGUID, string RoleGUID, string Access)
{
bool access = false;
List <RoleScreenMap> list = new List <RoleScreenMap>();
RoleScreenMap model = new RoleScreenMap();
list = lstFetch.ExcuteObject <RoleScreenMap>("[dbo].[RoleScreenMap_GetAllReal]", true).ToList();
list = list.Where(a => a.ScreenGUID == ScreenGUID && a.RoleGUID == RoleGUID).ToList();
if (list.Count > 0)
{
model = list.FirstOrDefault();
model.AllowAccess = Convert.ToInt32(Access);
model.AllowAction = 1;
this.UpdateRoleScreenMap(model);
access = true;
}
else
{
model.GUID = Guid.NewGuid().ToString();
model.RoleGUID = RoleGUID;
model.ScreenGUID = ScreenGUID;
model.AllowAction = 1;
model.AllowAccess = Convert.ToInt32(Access);
this.AddRoleScreenMap(model);
access = true;
}
return(access);
}