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; }