/// <summary> /// Insert Role detail. /// </summary> /// <param name="object">Data that converted into xml format.</param> /// <returns>Returns 1 and 0; (1 indicates successful operation).</returns> public int InsertAccess(RoleGadgetMappingBDto GadgetBdto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_GADGET_ACCESS_MAPPING_INSERT); db.AddInParameter(dbCmd, "@ROLE_ID", DbType.Int32, GadgetBdto.RoleID); db.AddInParameter(dbCmd, "@MODULE_ID", DbType.Int32, GadgetBdto.ModuleID); db.AddInParameter(dbCmd, "@GADGET_ID", DbType.Int32, GadgetBdto.GadgetID); db.AddInParameter(dbCmd, "@READ_ACCESS ", DbType.Boolean, GadgetBdto.ReadAccess); db.AddOutParameter(dbCmd, "@IS_INSERT", DbType.Int32, 1); db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_INSERT")); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }
/// <summary> /// Get AssignModule From RoleID /// </summary> /// <returns>Returns dataset contains module name data.</returns> public DataSet GetGadgetByRole(RoleGadgetMappingBDto GadgetBdto) { Database db = null; DbCommand dbCmd = null; DataSet ds = null; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_ROLE_GADGET_MAPPING_SELECT_BYROLE); db.AddInParameter(dbCmd, "@ROLE_ID", DbType.Int32, GadgetBdto.RoleID); ds = db.ExecuteDataSet(dbCmd); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return ds; }
/// <summary> /// Bind customer grid /// </summary> private void BindGridGadgetAccess(int RoleId) { DataSet ds = null; objRoleGadgetMappingDal = new RoleGadgetMappingDal(); objRoleGadgetMappingBDto = new RoleGadgetMappingBDto(); objRoleGadgetMappingBDto.RoleID = RoleId; ds = objRoleGadgetMappingDal.GetGadgetByRole(objRoleGadgetMappingBDto); radGridAccess.DataSource = ds; radGridAccess.DataBind(); }
protected void btnSave_OnClick(object sender, EventArgs e) { int result; bool SaveFail = true; objRoleGadgetMappingBDto = new RoleGadgetMappingBDto(); objRoleGadgetMappingDal = new RoleGadgetMappingDal(); foreach (GridDataItem item in radGridAccess.Items) { CheckBox chkRead = (CheckBox)item.FindControl("grdChkRead"); if (item["GADGET_ID"] != null) objRoleGadgetMappingBDto.GadgetID = int.Parse(item["GADGET_ID"].Text); if (item["MODULE_ID"] != null) objRoleGadgetMappingBDto.ModuleID = int.Parse(item["MODULE_ID"].Text); if (GlobalRoleId != 0) objRoleGadgetMappingBDto.RoleID = GlobalRoleId; objRoleGadgetMappingBDto.ReadAccess = chkRead.Checked; result = objRoleGadgetMappingDal.InsertAccess(objRoleGadgetMappingBDto); if (result != 1) SaveFail = false; } if (SaveFail) { Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString()); Master.MessageCssClass = "successMessage"; } pnlAccessGrid.Visible = false; }