protected bool UpdateData()
{
bool result = false;
DbConnection connection = null;
DbTransaction transaction = null;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
Role RolesObj = new Role();
RolesObj.RoleId = new Guid(this.hdnRoleId.Value);
RolesObj.RoleName = txtRoleName.Text.Trim();
RolesObj.RoleDescription = txtRoleDescription.Text.Trim();
RolesObj.UpdatedBy = Master.LoggedUser.UserId.Value;
if (RolesObj.Save(db, transaction))
{
//Delete exiting role rights
RolesObj.DeleteByRoleId(db, transaction);
List<object> myList = gvRights.GetSelectedFieldValues("RightId");
if (myList.Count > 0)
{
for (int i = 0; i <= myList.Count - 1; i++)
{
RolesObj.RightId = Convert.ToInt32(myList[i].ToString());
RolesObj.SaveRoleRights(db, transaction);
}
}
}
transaction.Commit();
result = true;
this.DisplayData();
System.Web.UI.ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMessage", "javascript:ShowSuccessMessage('" + Messages.Save_Success + "')", true);
}
catch (System.Exception)
{
}
return result;
}
protected bool SaveData()
{
bool result = false;
DbConnection connection = null;
DbTransaction transaction = null;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
Role RolesObj = new Role();
RolesObj.RoleName = txtRoleName.Text.Trim();
if (!RolesObj.IsDuplicateRoleName(RolesObj.RoleName))
{
RolesObj.RoleDescription = txtRoleDescription.Text.Trim();
RolesObj.CreatedBy = Master.LoggedUser.UserId.Value;
RolesObj.UpdatedBy = Master.LoggedUser.UserId.Value;
if (RolesObj.Save(db, transaction))
{
List<object> myList = gvRights.GetSelectedFieldValues("RightId");
if (myList.Count > 0)
{
for (int i = 0; i <= myList.Count - 1; i++)
{
RolesObj.RightId = Convert.ToInt32(myList[i].ToString());
RolesObj.SaveRoleRights(db, transaction);
}
}
else
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMessage", "javascript:ShowSuccessMessage('" + Messages.Select_Role + "')", true);
transaction.Rollback();
}
}
transaction.Commit();
result = true;
hdnRoleId.Value = RolesObj.RoleId.HasValue ? RolesObj.RoleId.Value.ToString() : string.Empty;
this.DisplayData();
System.Web.UI.ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMessage", "javascript:ShowSuccessMessage('" + Messages.Save_Success + "')", true);
}
else
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMessage", "javascript:ShowInfoMessage('" + Messages.Duplicate_Rolename + "')", true);
}
}
catch (System.Exception ex)
{
transaction.Rollback();
throw ex;
}
return result;
}
