public ML_UserType GetUserTypeByUserType(string UserType)
{
DataTable dt = new DataTable();
try
{
objML_UserType = new ML_UserType();
SqlParameter[] parameters =
{
#region Get Properties
new SqlParameter("@UserType", UserType)
#endregion
};
this.Parameters = parameters;
SqlDataReader sdr = SqlHelper.ExecuteReader(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetUserTypeByUserType.ToString(), this.Parameters);
if (sdr.HasRows)
{
dt.Load(sdr);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
objML_UserType.Id = ML_Common.string2Int32(ML_Common.clean(dr["Id"].ToString()));
objML_UserType.UserTypeId = ML_Common.string2Int32(ML_Common.clean(dr["UserTypeId"].ToString()));
objML_UserType.UserType = ML_Common.clean(dr["UserType"].ToString());
objML_UserType.IsActive = ML_Common.clean(dr["IsActive"].ToString());
objML_UserType.IsArchive = ML_Common.clean(dr["IsArchive"].ToString());
objML_UserType.CreatedDate = ML_Common.ToDateTimeSafe(ML_Common.clean(dr["CreatedDate"].ToString()));
objML_UserType.CreatedBy = ML_Common.clean(dr["CreatedBy"].ToString());
objML_UserType.ModifiedDate = ML_Common.ToDateTimeSafe(ML_Common.clean(dr["ModifiedDate"].ToString()));
objML_UserType.ModifiedBy = ML_Common.clean(dr["ModifiedBy"].ToString());
objML_UserType.CreatedByUserNameId = ML_Common.string2Int32(dr["CreatedByUserNameId"].ToString());
}
}
}
catch (Exception ex)
{
Exception exx = ex;
throw;
}
finally
{
//
}
return(objML_UserType);
}
