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