/// <summary> /// GetByLogin /// Calls [usp_select_LoginPreference_by_Login] /// </summary> public override LoginPreferenceDetails GetByLogin(System.Int32?loginNo) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_LoginPreference_by_Login", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@LoginNo", SqlDbType.Int).Value = loginNo; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetLoginPreferenceFromReader(reader); LoginPreferenceDetails obj = new LoginPreferenceDetails(); obj.LoginNo = GetReaderValue_Int32(reader, "LoginNo", 0); obj.ShowMessageAlert = GetReaderValue_Boolean(reader, "ShowMessageAlert", false); obj.DefaultSiteLanguageNo = GetReaderValue_NullableInt32(reader, "DefaultSiteLanguageNo", null); obj.DefaultListPageSize = GetReaderValue_Int32(reader, "DefaultListPageSize", 0); obj.NumberRecentlyViewedPages = GetReaderValue_Int32(reader, "NumberRecentlyViewedPages", 0); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_NullableDateTime(reader, "DLUP", null); obj.DefaultHomePageTab = GetReaderValue_Int32(reader, "DefaultHomePageTab", 0); obj.DefaultListPageView = GetReaderValue_Int32(reader, "DefaultListPageView", 0); obj.BackgroundImage = GetReaderValue_String(reader, "BackgroundImage", ""); obj.SaveDataListNuggetStateByDefault = GetReaderValue_Boolean(reader, "SaveDataListNuggetStateByDefault", false); obj.LoginTimeout = GetReaderValue_Int32(reader, "LoginTimeout", 0); obj.DefaultSiteLanguageCode = GetReaderValue_String(reader, "DefaultSiteLanguageCode", ""); //[001] code start obj.SendEmail = GetReaderValue_Boolean(reader, "SendEmail", false); //[001] code end obj.PrinterNo = GetReaderValue_NullableInt32(reader, "PrinterNo", null); obj.PrinterName = GetReaderValue_String(reader, "PrinterName", ""); obj.LabelPathNo = GetReaderValue_NullableInt32(reader, "LabelPathNo", null); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get LoginPreference", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
private static LoginPreference PopulateFromDBDetailsObject(LoginPreferenceDetails obj) { LoginPreference objNew = new LoginPreference(); objNew.LoginNo = obj.LoginNo; objNew.ShowMessageAlert = obj.ShowMessageAlert; objNew.DefaultSiteLanguageNo = obj.DefaultSiteLanguageNo; objNew.DefaultListPageSize = obj.DefaultListPageSize; objNew.NumberRecentlyViewedPages = obj.NumberRecentlyViewedPages; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.DefaultHomePageTab = obj.DefaultHomePageTab; objNew.DefaultListPageView = obj.DefaultListPageView; objNew.BackgroundImage = obj.BackgroundImage; objNew.SaveDataListNuggetStateByDefault = obj.SaveDataListNuggetStateByDefault; objNew.LoginTimeout = obj.LoginTimeout; objNew.DefaultSiteLanguageCode = obj.DefaultSiteLanguageCode; return(objNew); }
//[001] code start /// <summary> /// GetByLoginForSendEmail /// usp_select_login_for_sendemail /// </summary> /// <param name="loginNo"></param> /// <returns></returns> public override LoginPreferenceDetails GetByLoginForSendEmail(System.Int32?loginId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_login_for_sendemail", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@loginId", SqlDbType.Int).Value = loginId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { LoginPreferenceDetails obj = new LoginPreferenceDetails(); obj.SendEmail = GetReaderValue_Boolean(reader, "SendEmail", false); obj.Email = GetReaderValue_String(reader, "EMail", ""); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get login details", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }