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 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 {
}
}
}
