public List<UserProfileModel> GetUserByUserId(ParameterModel mymodel) { List<UserProfileModel> model = new List<UserProfileModel>(); try { cmd = new SqlCommand("GetUserByUserId_Sp", con); cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = mymodel.Id; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new UserProfileModel { UserId = Convert.ToInt32(dr["UserId"]), OrgId = Convert.ToInt32(dr["OrgId"]), OrgName = dr["OrgName"].ToString(), OrgStreet = dr["OrgStreet"].ToString(), OrgCity = dr["OrgCityName"].ToString(), OrgState = dr["OrgStateName"].ToString(), UserFirstName = dr["FirstName"].ToString(), UserLastName = dr["LastName"].ToString(), UserStreet = dr["Street"].ToString(), UserCityId = Convert.ToInt32(dr["CityId"]), UserStateId = Convert.ToInt32(dr["StateId"]), UserCity = dr["CityName"].ToString(), UserState = dr["StateName"].ToString(), ProfilePhoto = dr["ProfilePhoto"].ToString(), RoleId = Convert.ToInt32(dr["RoleId"]), RoleName = dr["RoleName"].ToString(), UserName = dr["UserName"].ToString(), UserEmailId = dr["EmailId"].ToString(), UserMobileNo = dr["MobileNo"].ToString(), Password = PasswordSecurity.Decrypt(dr["Password"].ToString()), //Password Decryption CreatedBy = Convert.ToInt32(dr["CreatedBy"]), CreatedOn = Convert.ToDateTime(dr["CreatedOn"]), ModifiedBy = Convert.ToInt32(dr["ModifiedBy"]), ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"]), IsActive = Convert.ToBoolean(dr["IsActive"]), IsDelete = Convert.ToBoolean(dr["IsDelete"]), RegisteredAs = dr["RegisteredAs"].ToString() }); } if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public List<ModulesModel> GetAllModuleListByOrgId(ParameterModel mymodel) { List<ModulesModel> model = new List<ModulesModel>(); try { SqlCommand cmd = new SqlCommand("GetAllModuleListByOrgId_Sp", con); cmd.Parameters.Add("@Org_Id", SqlDbType.NVarChar, 150).Value = mymodel.Id; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new ModulesModel { ModuleId = Convert.ToInt32(dr["ModuleId"]), ModuleName = dr["Module_Name"].ToString(), CreatedByOrg_Id = Convert.ToInt64(dr["CreatedBy"]), }); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; // return Json(model, JsonRequestBehavior.AllowGet); }
public List<ModulesModel> GetAllModuleListByOrgId(ParameterModel model) { Modules_Sp_Class objMod = new Modules_Sp_Class(); return objMod.GetAllModuleListByOrgId(model); }
public List<UserProfileModel> GetUserByUserId(ParameterModel model) { return obj.GetUserByUserId(model); }