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