public List <ModuleActionDto> GetModuleActionsByUserId(int userid, bool isFederation) { List <ModuleActionDto> moduleActoins = new List <ModuleActionDto>(); try { AdoHelper obj = new AdoHelper(); SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@UserId", userid); parms[0].SqlDbType = SqlDbType.Int; parms[1] = new SqlParameter("@IsFedertaion", isFederation); parms[1].SqlDbType = SqlDbType.Bit; SqlDataReader drResult = obj.ExecDataReaderProc("uspGetModlueActionsByUserId", parms); while (drResult.Read()) { ModuleActionDto moduleActionDto = new ModuleActionDto(); moduleActionDto.ActionName = drResult["ActionName"].ToString(); moduleActionDto.ModuleActionCode = drResult["ModuleActionCode"].ToString(); moduleActionDto.ModuleActionId = Convert.ToInt32(drResult["ModuleActionId"].ToString()); moduleActionDto.ModuleId = Convert.ToInt32(drResult["ModuleId"].ToString()); moduleActionDto.ModuleName = drResult["ModuleName"].ToString(); moduleActionDto.Status = Convert.ToInt32(drResult["Status"].ToString()); moduleActionDto.Url = drResult["Url"].ToString(); moduleActoins.Add(moduleActionDto); } } catch (Exception) { } return(moduleActoins); }
private ResultDto InsertUpdate(ModuleActionDto moduleAction) { ResultDto resultDto = new ResultDto(); string objectName = "ModuleAction"; try { //ObjectParameter prmModuleactionId = new ObjectParameter("ModuleActionId", moduleAction.ModuleActionId); int moduleActionId = moduleAction.ModuleActionId; int effectedRow = _moduleActionDal.InsertUpdateModuleAction(ref moduleActionId, moduleAction.ModuleActionCode, moduleAction.ActionName, moduleAction.ModuleId, moduleAction.Url); resultDto.ObjectId = moduleActionId; if (resultDto.ObjectId > 0) { resultDto.Message = string.Format("{0} Details Saved Successfully ", objectName); } else { resultDto.Message = string.Format("Error Occured while Saving {0} Details", objectName); } } catch (Exception) { resultDto.Message = string.Format("Service layer error occured while saving the {0} details", objectName); resultDto.ObjectId = -98; } return(resultDto); }
public ActionResult AddModuleAction(string id) { int ID = string.IsNullOrEmpty(id) ? default(int) : Convert.ToInt32(id); var moduleActionDto = new ModuleActionDto(); if (ID > 0) { moduleActionDto = _moduleActionService.GetModuleActionByID(ID); } BindDropdowns(); return(View(moduleActionDto)); }
public ActionResult AddModuleAction(ModuleActionDto moduleActionDto) { BindDropdowns(); var resultDto = new ResultDto(); if (moduleActionDto.ModuleActionId == 0) { resultDto = _moduleActionService.Insert(moduleActionDto); } else { resultDto = _moduleActionService.Update(moduleActionDto); } ViewBag.Result = resultDto; return(View(moduleActionDto)); }
public ModuleActionDto GetModuleActionByID(int moduleActionID) { ModuleActionDto objModuleAction = new ModuleActionDto(); cmd = new SqlCommand(ProcNames.uspModuleActionGetByID, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ModuleActionId", moduleActionID); con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { objModuleAction.ModuleActionId = Convert.ToInt32(dr["ModuleActionId"]); objModuleAction.ModuleActionCode = Convert.ToString(dr["ModuleActionCode"]); objModuleAction.ModuleId = Convert.ToInt32(dr["ModuleId"]); objModuleAction.ActionName = Convert.ToString(dr["ActionName"]); objModuleAction.Url = Convert.ToString(dr["Url"]); } con.Close(); return(objModuleAction); }
public List <ModuleActionDto> GetModuleActions(int id) { List <ModuleActionDto> lstModuleActionDto = new List <ModuleActionDto>(); SqlConnection con = new SqlConnection(DBConstants.MFIS_CS); SqlCommand cmd = new SqlCommand(ProcNames.uspGetModuleActionsByModuleID, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ModuleId", id); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); ModuleActionDto objModuleActionDto; while (sdr.Read()) { objModuleActionDto = new ModuleActionDto(); objModuleActionDto.ModuleActionId = Convert.ToInt32(sdr["ModuleActionId"]); objModuleActionDto.ActionName = Convert.ToString(sdr["ActionName"]); lstModuleActionDto.Add(objModuleActionDto); } con.Close(); return(lstModuleActionDto); }
public ModuleActionDto GetModuleActionByID(int moduleActionID) { ModuleActionDto moduleActions = _moduleActionDal.GetModuleActionByID(moduleActionID); return(moduleActions); }
public ResultDto Update(ModuleActionDto moduleAction) { return(InsertUpdate(moduleAction)); }