/// <summary>
/// Connects to database and returns profile by profile ID.
/// </summary>
/// <param name="EditID">Profile ID.</param>
/// <returns>Profile detail</returns>
public ProfileManagementInfo GetProfileByProfileID(int EditID)
{
SqlDataReader reader = null;
try
{
string sp = "[dbo].[sp_ProfileGetByProfileID]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ProfileID", EditID));
reader = SQLH.ExecuteAsDataReader(sp, ParamCollInput);
ProfileManagementInfo objList = new ProfileManagementInfo();
while (reader.Read())
{
objList.ProfileID = int.Parse(reader["ProfileID"].ToString());
objList.Name = reader["Name"].ToString();
objList.PropertyTypeID = int.Parse(reader["PropertyTypeID"].ToString());
objList.DataType = reader["DataType"].ToString();
objList.IsRequired = bool.Parse(reader["IsRequired"].ToString());
objList.DisplayOrder = int.Parse(reader["DisplayOrder"].ToString());
objList.IsActive = bool.Parse(reader["IsActive"].ToString());
objList.IsDeleted = bool.Parse(reader["IsDeleted"].ToString());
objList.IsDeleted = bool.Parse(reader["IsModified"].ToString());
objList.UpdatedOn = DateTime.Parse(reader["UpdatedOn"].ToString());
objList.PortalID = int.Parse(reader["PortalID"].ToString());
objList.UpdatedBy = reader["UpdatedBy"].ToString();
}
return(objList);
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
/// <summary>
/// Adss value to list
/// </summary>
/// <param name="value">ProfileManagementInfo object</param>
/// <returns></returns>
public int Add(ProfileManagementInfo value)
{
return List.Add(value);
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
public void Remove(ProfileManagementInfo value)
{
List.Remove(value);
}
/// <summary>
///
/// </summary>
/// <param name="index"></param>
/// <param name="value"></param>
public void Insert(int index, ProfileManagementInfo value)
{
List.Insert(index, value);
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public int IndexOf(ProfileManagementInfo value)
{
return List.IndexOf(value);
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public bool Contains(ProfileManagementInfo value)
{
return List.Contains(value);
}
/// <summary>
/// Connects to database and returns profile by profile ID.
/// </summary>
/// <param name="EditID">Profile ID.</param>
/// <returns>Profile detail</returns>
public ProfileManagementInfo GetProfileByProfileID(int EditID)
{
SqlDataReader reader = null;
try
{
string sp = "[dbo].[sp_ProfileGetByProfileID]";
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ProfileID", EditID));
reader = SQLH.ExecuteAsDataReader(sp, ParamCollInput);
ProfileManagementInfo objList = new ProfileManagementInfo();
while (reader.Read())
{
objList.ProfileID = int.Parse(reader["ProfileID"].ToString());
objList.Name = reader["Name"].ToString();
objList.PropertyTypeID = int.Parse(reader["PropertyTypeID"].ToString());
objList.DataType = reader["DataType"].ToString();
objList.IsRequired = bool.Parse(reader["IsRequired"].ToString());
objList.DisplayOrder = int.Parse(reader["DisplayOrder"].ToString());
objList.IsActive = bool.Parse(reader["IsActive"].ToString());
objList.IsDeleted = bool.Parse(reader["IsDeleted"].ToString());
objList.IsDeleted = bool.Parse(reader["IsModified"].ToString());
objList.UpdatedOn = DateTime.Parse(reader["UpdatedOn"].ToString());
objList.PortalID = int.Parse(reader["PortalID"].ToString());
objList.UpdatedBy = reader["UpdatedBy"].ToString();
}
return objList;
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
