public static List <LeapCreditApplication> GetAllLeapCreditApplication_bySSN(string ssn) { List <LeapCreditApplication> file_to_DMS_List = new List <LeapCreditApplication>(); using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("LeapCreditConnectionString")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_select_LeapCreditApplication_bySSN"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ssn ", SqlDbType.NVarChar); cmd.Parameters["@ssn "].Value = ssn; //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { LeapCreditApplication dm = new LeapCreditApplication(); dm.First_Name = reader["Firs_tName"].ToString(); file_to_DMS_List.Add(dm); } } return(file_to_DMS_List); }
public static void UpdateMMApplyModelByActivationCode(MM_ApplyModel applyModel) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("ConStr")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_Update_ApplyModelByActivationCode";//@FirstName,@LastName,@Email,@Phone,@activation_code,@ApplyFromIPAddress,@ApplyTime cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar); cmd.Parameters["@FirstName"].Value = applyModel.FirstName == null ? "" : applyModel.FirstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar); cmd.Parameters["@LastName"].Value = applyModel.LastName == null ? "" : applyModel.LastName; cmd.Parameters.Add("@Email", SqlDbType.NVarChar); cmd.Parameters["@Email"].Value = applyModel.Email == null ? "" : applyModel.Email; cmd.Parameters.Add("@Phone", SqlDbType.NVarChar); cmd.Parameters["@Phone"].Value = applyModel.Phone == null ? "" : applyModel.Phone; cmd.Parameters.Add("@activation_code", SqlDbType.NVarChar); cmd.Parameters["@activation_code"].Value = applyModel.Activation_code == null ? "" : applyModel.Activation_code; cmd.Parameters.Add("@SubmitFromIPAddress", SqlDbType.NVarChar); cmd.Parameters["@SubmitFromIPAddress"].Value = applyModel.SubmitFromIPAddress == null ? "" : applyModel.SubmitFromIPAddress; cmd.Parameters.Add("@SubmitFromBtn", SqlDbType.NVarChar); cmd.Parameters["@SubmitFromBtn"].Value = applyModel.SubmitFromBtn == null ? "" : applyModel.SubmitFromBtn; cmd.Parameters.Add("@SubmitTime", SqlDbType.NVarChar); cmd.Parameters["@SubmitTime"].Value = System.DateTime.Now.ToString(); //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); try { SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { } } catch { } } }
public static List <JC_Model> GetAllJC_Model_byActivationCode(string activation_code, string lastName) { List <JC_Model> file_to_DMS_List = new List <JC_Model>(); using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("ConStr")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_select_JC_model_by_activatiocode"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@activation_code ", SqlDbType.NVarChar); cmd.Parameters["@activation_code "].Value = activation_code; //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { JC_Model dm = new JC_Model(); dm.FirstName = reader["FirstName"].ToString(); dm.LastName = reader["LastName"].ToString(); dm.Phone = reader["Phone"].ToString(); dm.Company = reader["Company"].ToString(); dm.Activation_code = activation_code; dm.Address = reader["Address"].ToString(); dm.City = reader["City"].ToString(); dm.State = reader["State"].ToString(); dm.Zip5 = reader["Zip5"].ToString(); dm.Zipfour = reader["Zipfour"].ToString(); dm.TitleCode = reader["TitleCode"].ToString(); dm.TitleCodeDescription = reader["TitleCodeDescription"].ToString(); dm.camp_id = reader["camp_id"].ToString(); dm.DebtAmount = reader["DebtAmount"].ToString(); file_to_DMS_List.Add(dm); } } return(file_to_DMS_List); }
public static void InsertStep1Insert_LeapCreditApplication(LeapCreditApplication applyModel) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("LeapCreditConnectionString")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_Step1Insert_LeapCreditApplication";//@FirstName,@LastName,@Email,@Phone,@activation_code,@ApplyFromIPAddress,@ApplyTime cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@First_Name", SqlDbType.NVarChar); cmd.Parameters["@First_Name"].Value = applyModel.First_Name == null ? "" : applyModel.First_Name; cmd.Parameters.Add("@Last_Name", SqlDbType.NVarChar); cmd.Parameters["@Last_Name"].Value = applyModel.Last_Name == null ? "" : applyModel.Last_Name; cmd.Parameters.Add("@Email", SqlDbType.NVarChar); cmd.Parameters["@Email"].Value = applyModel.Email == null ? "" : applyModel.Email; cmd.Parameters.Add("@Loan_Amount", SqlDbType.NVarChar); cmd.Parameters["@Loan_Amount"].Value = applyModel.Loan_Amount == null ? "" : applyModel.Loan_Amount; cmd.Parameters.Add("@Paycheck_Period", SqlDbType.NVarChar); cmd.Parameters["@Paycheck_Period"].Value = applyModel.Paycheck_Period == null ? "" : applyModel.Paycheck_Period; cmd.Parameters.Add("@Gross_Income_per_Paycheck", SqlDbType.NVarChar); cmd.Parameters["@Gross_Income_per_Paycheck"].Value = applyModel.Gross_Income_per_Paycheck == null ? "" : applyModel.Gross_Income_per_Paycheck; cmd.Parameters.Add("@SubmitFromBtn", SqlDbType.NVarChar); cmd.Parameters["@SubmitFromBtn"].Value = applyModel.SubmitFromBtn == null ? "" : applyModel.SubmitFromBtn; cmd.Parameters.Add("@SubmitTime", SqlDbType.NVarChar); cmd.Parameters["@SubmitTime"].Value = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); try { SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { } } catch (Exception ex) { } } }
public static void InsertUpdateStorageAuthToken(string authToken, string userName, string location, string createDateTime, string storageUrl) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("UAM_version2")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.Parameters.Add("@userName", SqlDbType.NVarChar); cmd.Parameters["@userName"].Value = userName; cmd.Parameters.Add("@authToken", SqlDbType.NVarChar); cmd.Parameters["@authToken"].Value = authToken; cmd.Parameters.Add("@location", SqlDbType.NVarChar); cmd.Parameters["@location"].Value = location; cmd.Parameters.Add("@createTime", SqlDbType.NVarChar); cmd.Parameters["@createTime"].Value = createDateTime; cmd.Parameters.Add("@storageUrl", SqlDbType.NVarChar); cmd.Parameters["@storageUrl"].Value = storageUrl; cmd.CommandText = "Portal_CreateUpdate_StorageAuthtoken"; cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } }
public static void InsertEmptyOrWrongCodeLog(string activation_code) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("ConStr")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_Insert_EmptyOrWrongCode"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@activation_code ", SqlDbType.NVarChar); cmd.Parameters["@activation_code "].Value = activation_code == null ? "" : activation_code; cmd.Parameters.Add("@enterCodeTime", SqlDbType.NVarChar); cmd.Parameters["@enterCodeTime"].Value = System.DateTime.Now.ToString(); //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { } } }
public static bool IfExistActivationCode(string activationCode) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("ConStr")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_Select_IfExistActivationCode"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@activation_code ", SqlDbType.NVarChar); cmd.Parameters["@activation_code "].Value = activationCode == null ? "" : activationCode; //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); SqlDataReader reader = cmd.ExecuteReader(); return(reader.HasRows); //while (reader.Read()) //{ //} } }
public static void InsertStep3_LeapCreditApplication(LeapCreditApplication applyModel) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("LeapCreditConnectionString")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_Step3Insert_LeapCreditApplication";//@FirstName,@LastName,@Email,@Phone,@activation_code,@ApplyFromIPAddress,@ApplyTime cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@First_Name", SqlDbType.NVarChar); cmd.Parameters["@First_Name"].Value = applyModel.First_Name == null ? "" : applyModel.First_Name; cmd.Parameters.Add("@Last_Name", SqlDbType.NVarChar); cmd.Parameters["@Last_Name"].Value = applyModel.Last_Name == null ? "" : applyModel.Last_Name; cmd.Parameters.Add("@Email", SqlDbType.NVarChar); cmd.Parameters["@Email"].Value = applyModel.Email == null ? "" : applyModel.Email; cmd.Parameters.Add("@Loan_Amount", SqlDbType.NVarChar); cmd.Parameters["@Loan_Amount"].Value = applyModel.Loan_Amount == null ? "" : applyModel.Loan_Amount; cmd.Parameters.Add("@Paycheck_Period", SqlDbType.NVarChar); cmd.Parameters["@Paycheck_Period"].Value = applyModel.Paycheck_Period == null ? "" : applyModel.Paycheck_Period; cmd.Parameters.Add("@Gross_Income_per_Paycheck", SqlDbType.NVarChar); cmd.Parameters["@Gross_Income_per_Paycheck"].Value = applyModel.Gross_Income_per_Paycheck == null ? "" : applyModel.Gross_Income_per_Paycheck; cmd.Parameters.Add("@ck_ACH_Authorization", SqlDbType.NVarChar); cmd.Parameters["@ck_ACH_Authorization"].Value = applyModel.ck_ACH_Authorization == null ? "" : applyModel.ck_ACH_Authorization.ToString(); cmd.Parameters.Add("@Mobile_Number1", SqlDbType.NVarChar); cmd.Parameters["@Mobile_Number1"].Value = applyModel.Mobile_Number1 == null ? "" : applyModel.Mobile_Number1; cmd.Parameters.Add("@Mobile_Number2", SqlDbType.NVarChar); cmd.Parameters["@Mobile_Number2"].Value = applyModel.Mobile_Number2 == null ? "" : applyModel.Mobile_Number2; cmd.Parameters.Add("@Mobile_Number3", SqlDbType.NVarChar); cmd.Parameters["@Mobile_Number3"].Value = applyModel.Mobile_Number3 == null ? "" : applyModel.Mobile_Number3; cmd.Parameters.Add("@Secondary_Phone_Number1", SqlDbType.NVarChar); cmd.Parameters["@Secondary_Phone_Number1"].Value = applyModel.Secondary_Phone_Number1 == null ? "" : applyModel.Secondary_Phone_Number1; cmd.Parameters.Add("@Secondary_Phone_Number2", SqlDbType.NVarChar); cmd.Parameters["@Secondary_Phone_Number2"].Value = applyModel.Secondary_Phone_Number2 == null ? "" : applyModel.Secondary_Phone_Number2; cmd.Parameters.Add("@Secondary_Phone_Number3", SqlDbType.NVarChar); cmd.Parameters["@Secondary_Phone_Number3"].Value = applyModel.Secondary_Phone_Number3 == null ? "" : applyModel.Secondary_Phone_Number3; cmd.Parameters.Add("@Address", SqlDbType.NVarChar); cmd.Parameters["@Address"].Value = applyModel.Address == null ? "" : applyModel.Address; cmd.Parameters.Add("@Address2", SqlDbType.NVarChar); cmd.Parameters["@Address2"].Value = applyModel.Address2 == null ? "" : applyModel.Address2; cmd.Parameters.Add("@City", SqlDbType.NVarChar); cmd.Parameters["@City"].Value = applyModel.City == null ? "" : applyModel.City; cmd.Parameters.Add("@State", SqlDbType.NVarChar); cmd.Parameters["@State"].Value = applyModel.State == null ? "" : applyModel.State; cmd.Parameters.Add("@Zip_Code", SqlDbType.NVarChar); cmd.Parameters["@Zip_Code"].Value = applyModel.Zip_Code == null ? "" : applyModel.Zip_Code; cmd.Parameters.Add("@Date_of_Birth", SqlDbType.NVarChar); cmd.Parameters["@Date_of_Birth"].Value = applyModel.Date_of_Birth == null ? "" : applyModel.Date_of_Birth; cmd.Parameters.Add("@Current_Military", SqlDbType.NVarChar); cmd.Parameters["@Current_Military"].Value = applyModel.Current_Military == null ? "" : applyModel.Current_Military.ToString(); cmd.Parameters.Add("@Drivers_License_NO", SqlDbType.NVarChar); cmd.Parameters["@Drivers_License_NO"].Value = applyModel.Drivers_License_NO == null ? "" : applyModel.Drivers_License_NO.ToString(); cmd.Parameters.Add("@SSN1", SqlDbType.NVarChar); cmd.Parameters["@SSN1"].Value = applyModel.SSN1 == null ? "" : applyModel.SSN1.ToString(); cmd.Parameters.Add("@SSN2", SqlDbType.NVarChar); cmd.Parameters["@SSN2"].Value = applyModel.SSN2 == null ? "" : applyModel.SSN2.ToString(); cmd.Parameters.Add("@SSN3", SqlDbType.NVarChar); cmd.Parameters["@SSN3"].Value = applyModel.SSN3 == null ? "" : applyModel.SSN3.ToString(); cmd.Parameters.Add("@Job_Title", SqlDbType.NVarChar); cmd.Parameters["@Job_Title"].Value = applyModel.Job_Title == null ? "" : applyModel.Job_Title.ToString(); cmd.Parameters.Add("@Employer", SqlDbType.NVarChar); cmd.Parameters["@Employer"].Value = applyModel.Employer == null ? "" : applyModel.Employer.ToString(); cmd.Parameters.Add("@Time_Employed_year", SqlDbType.NVarChar); cmd.Parameters["@Time_Employed_year"].Value = applyModel.Time_Employed_year == null ? "" : applyModel.Time_Employed_year.ToString(); cmd.Parameters.Add("@Time_Employed_month", SqlDbType.NVarChar); cmd.Parameters["@Time_Employed_month"].Value = applyModel.Time_Employed_month == null ? "" : applyModel.Time_Employed_month.ToString(); cmd.Parameters.Add("@Supervisor_Phone_Number1", SqlDbType.NVarChar); cmd.Parameters["@Supervisor_Phone_Number1"].Value = applyModel.Supervisor_Phone_Number1 == null ? "" : applyModel.Supervisor_Phone_Number1.ToString(); cmd.Parameters.Add("@Supervisor_Phone_Number2", SqlDbType.NVarChar); cmd.Parameters["@Supervisor_Phone_Number2"].Value = applyModel.Supervisor_Phone_Number2 == null ? "" : applyModel.Supervisor_Phone_Number2.ToString(); cmd.Parameters.Add("@Supervisor_Phone_Number3", SqlDbType.NVarChar); cmd.Parameters["@Supervisor_Phone_Number3"].Value = applyModel.Supervisor_Phone_Number3 == null ? "" : applyModel.Supervisor_Phone_Number3.ToString(); cmd.Parameters.Add("@Employer_Addresss", SqlDbType.NVarChar); cmd.Parameters["@Employer_Addresss"].Value = applyModel.Employer_Addresss == null ? "" : applyModel.Employer_Addresss.ToString(); cmd.Parameters.Add("@Employer_City", SqlDbType.NVarChar); cmd.Parameters["@Employer_City"].Value = applyModel.Employer_City == null ? "" : applyModel.Employer_City.ToString(); cmd.Parameters.Add("@Employer_State", SqlDbType.NVarChar); cmd.Parameters["@Employer_State"].Value = applyModel.Employer_State == null ? "" : applyModel.Employer_State.ToString(); cmd.Parameters.Add("@Employer_Zip_Code", SqlDbType.NVarChar); cmd.Parameters["@Employer_Zip_Code"].Value = applyModel.Employer_Zip_Code == null ? "" : applyModel.Employer_Zip_Code.ToString(); cmd.Parameters.Add("@Purpose_for_Loan", SqlDbType.NVarChar); cmd.Parameters["@Purpose_for_Loan"].Value = applyModel.Purpose_for_Loan == null ? "" : applyModel.Purpose_for_Loan.ToString(); cmd.Parameters.Add("@How_did_you_hear_about_LeapCredit", SqlDbType.NVarChar); cmd.Parameters["@How_did_you_hear_about_LeapCredit"].Value = applyModel.How_did_you_hear_about_LeapCredit == null ? "" : applyModel.How_did_you_hear_about_LeapCredit.ToString(); cmd.Parameters.Add("@SubmitFromBtn", SqlDbType.NVarChar); cmd.Parameters["@SubmitFromBtn"].Value = applyModel.SubmitFromBtn == null ? "" : applyModel.SubmitFromBtn; cmd.Parameters.Add("@SubmitTime", SqlDbType.NVarChar); cmd.Parameters["@SubmitTime"].Value = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); try { SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { } } catch (Exception ex) { } } }
public static void InsertMMApplyModel(MM_ApplyModel applyModel) { using (SqlConnection objConnection = SQLDatabaseHelper.GetSqlConnection("ConStr")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = objConnection; cmd.CommandText = "sp_Insert_ApplyModel";//@FirstName,@LastName,@Email,@Phone,@activation_code,@ApplyFromIPAddress,@ApplyTime cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar); cmd.Parameters["@FirstName"].Value = applyModel.FirstName == null ? "" : applyModel.FirstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar); cmd.Parameters["@LastName"].Value = applyModel.LastName == null ? "" : applyModel.LastName; cmd.Parameters.Add("@Email", SqlDbType.NVarChar); cmd.Parameters["@Email"].Value = applyModel.Email == null ? "" : applyModel.Email; cmd.Parameters.Add("@Phone", SqlDbType.NVarChar); cmd.Parameters["@Phone"].Value = applyModel.Phone == null ? "" : applyModel.Phone; cmd.Parameters.Add("@activation_code", SqlDbType.NVarChar); cmd.Parameters["@activation_code"].Value = applyModel.Activation_code == null ? "" : applyModel.Activation_code; cmd.Parameters.Add("@SubmitFromIPAddress", SqlDbType.NVarChar); cmd.Parameters["@SubmitFromIPAddress"].Value = applyModel.SubmitFromIPAddress == null ? "" : applyModel.SubmitFromIPAddress; cmd.Parameters.Add("@SubmitFromBtn", SqlDbType.NVarChar); cmd.Parameters["@SubmitFromBtn"].Value = applyModel.SubmitFromBtn == null ? "" : applyModel.SubmitFromBtn; cmd.Parameters.Add("@Address", SqlDbType.NVarChar); cmd.Parameters["@Address"].Value = applyModel.Address == null ? "" : applyModel.Address; cmd.Parameters.Add("@City", SqlDbType.NVarChar); cmd.Parameters["@City"].Value = applyModel.City == null ? "" : applyModel.City; cmd.Parameters.Add("@Company", SqlDbType.NVarChar); cmd.Parameters["@Company"].Value = applyModel.Company == null ? "" : applyModel.Company; cmd.Parameters.Add("@State", SqlDbType.NVarChar); cmd.Parameters["@State"].Value = applyModel.State == null ? "" : applyModel.State; cmd.Parameters.Add("@StateDescription", SqlDbType.NVarChar); cmd.Parameters["@StateDescription"].Value = applyModel.StateDescription == null ? "" : applyModel.StateDescription; cmd.Parameters.Add("@TitleCode", SqlDbType.NVarChar); cmd.Parameters["@TitleCode"].Value = applyModel.TitleCode == null ? "" : applyModel.TitleCode; cmd.Parameters.Add("@TitleCodeDescription", SqlDbType.NVarChar); cmd.Parameters["@TitleCodeDescription"].Value = applyModel.TitleCodeDescription == null ? "" : applyModel.TitleCodeDescription; cmd.Parameters.Add("@Zip5", SqlDbType.NVarChar); cmd.Parameters["@Zip5"].Value = applyModel.Zip5 == null ? "" : applyModel.Zip5; cmd.Parameters.Add("@Zipfour", SqlDbType.NVarChar); cmd.Parameters["@Zipfour"].Value = applyModel.Zipfour == null ? "" : applyModel.Zipfour; cmd.Parameters.Add("@camp_id", SqlDbType.NVarChar); cmd.Parameters["@camp_id"].Value = applyModel.camp_id == null ? "" : applyModel.camp_id; cmd.Parameters.Add("@DebtAmount", SqlDbType.NVarChar); cmd.Parameters["@DebtAmount"].Value = applyModel.DebtAmount == null ? "" : applyModel.DebtAmount; cmd.Parameters.Add("@SubmitTime", SqlDbType.NVarChar); cmd.Parameters["@SubmitTime"].Value = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //cmd.ExecuteNonQuery(); //cmd.ExecuteReader(); try { SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { } } catch { } } }