public int Create(BlockDataRoleCreateModel model) { int output = 0; string strLstOfMenuIds = ""; try { strLstOfMenuIds = model.StrAllowedMenus; DBConnection.OpenDBConnect(); //STEP1: ***************************************************************/ Dictionary <string, object> dicParas = new Dictionary <string, object>(); Dictionary <string, object> dicParaOuts = new Dictionary <string, object>(); if (model.Name != null && model.Description != null && strLstOfMenuIds != null) { dicParas.Add("Name", model.Name); //dicParas.Add("Description", model.Description); dicParas.Add("Description", String.IsNullOrEmpty(model.Description) ? "" : model.Description); dicParas.Add("LstOfMenuIds", strLstOfMenuIds); dicParas.Add("DepartId", model.DeptID); if (model.RoleId == 0) { //dicParas.Add("") output = DBConnection.ExecSPNonQuery("SP_ROLE_INSERT", dicParas, ref dicParaOuts, true); } else { dicParas.Add("RoleId", model.RoleId); output = DBConnection.ExecSPNonQuery("SP_ROLE_UPDATE", dicParas, ref dicParaOuts, true); } } //STEP2: ***************************************************************/ } catch (Exception ex) { this.ERROR = ex.ToString(); output = -1; } finally { DBConnection.CloseDBConnect(); } return(output); }
public BlockDataRoleCreateModel GetEntityById(int id) { BlockDataRoleCreateModel output = new BlockDataRoleCreateModel(); try { DBConnection.OpenDBConnect(); if (this.DBConnection.ERROR != null) { throw new Exception("Can't connect to db"); } //STEP1: ***************************************************************/ Dictionary <string, object> dicParas = new Dictionary <string, object>(); Dictionary <string, object> dicParaOuts = new Dictionary <string, object>(); dicParas.Add("ROLEID", id); DataSet dataSet = DBConnection.ExecSelectSP("SP_ROLE_GET_BY_ID", dicParas, ref dicParaOuts, true); //**********************TABLE: ROLE*************************************** DataTable table1 = dataSet.Tables[0]; foreach (DataRow row in table1.Rows) { output.Name = row["Name"].ToString(); output.Description = row["Description"].ToString(); output.RoleId = Int32.Parse(row["RoleId"].ToString()); output.DeptID = Int32.Parse(row["DepartId"].ToString()); } //**********************TABLE: ROLEMENU *********************************************** DataTable table2 = dataSet.Tables[1]; foreach (DataRow row in table2.Rows) { output.ListRoleMenus.Add(Int32.Parse(row["menuid"].ToString())); } } catch (Exception ex) { this.ERROR = ex.ToString(); } finally { this.DBConnection.CloseDBConnect(); } return(output); }