public void ProcessRequest(HttpContext context)
{
string reply_str = "";
var db = new EchoContext();
SmsRegistrationLog sms_log = new SmsRegistrationLog();
string sms_log_result = "";
try
{
string keyword = context.Request.Form["keyword"] == null ? string.Empty : context.Request.Form["keyword"];
string content = context.Request.Form["content"] == null ? string.Empty : context.Request.Form["content"];
string mobile_no = context.Request.Form["mobile_no"] == null ? string.Empty : context.Request.Form["mobile_no"];
//string msg = context.Request.Form["msg"] == null ? string.Empty : context.Request.Form["msg"];
sms_log.Mobile_Number = mobile_no;
sms_log.RQ_Msg = "-";
sms_log.RQ_Keyword = keyword;
sms_log.RQ_Content = content;
int result = CustomValidate.ValidateNumber(mobile_no);
bool flag = true;
if (result != 1 && result != 4)
{
flag = false;
if (result == 2 || result == 3 || result == 5)
{
reply_str = System.Configuration.ConfigurationManager.AppSettings["EXIST_NUMBER"];
sms_log_result = "Existing number";
}
if (result == 6)
{
reply_str = System.Configuration.ConfigurationManager.AppSettings["NO_ACCTACTIVATION"];
sms_log_result = "Maintenance Period";
}
}
if (flag)
{
if (IsValid(keyword, content))
{
string[] content_arrs = content.Split(' ');
string gender = content_arrs[0];
string dob = content_arrs[1];
string[] result_sp = new string[2];
byte day = Convert.ToByte(dob.Substring(0, 2));
byte month = Convert.ToByte(dob.Substring(2, 2));
int year = Convert.ToInt16(dob.Substring(4, 4));
year = year - 543;
#region transaction
var transactionOptions = new TransactionOptions();
transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
transactionOptions.Timeout = TransactionManager.MaximumTimeout;
Account account = new Account();
DateTime timestamp = DateTime.Now;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, transactionOptions))
{
var db_transaction = new EchoContext();
account.Gender_Cd = gender.ToUpper();
account.Day_Of_Birth = day;
account.Month_Of_Birth = month;
account.Year_Of_Birth = year;
account.Channel_Cd = "SMS";
account.Created_By = System.Configuration.ConfigurationManager.AppSettings["CREATED_BY_SMS"];
account.Updated_By = System.Configuration.ConfigurationManager.AppSettings["CREATED_BY_SMS"];
account.First_Mobile_Number = mobile_no;
account.Created_Dttm = timestamp;
account.Updated_Dttm = timestamp;
account.Registration_Dttm = timestamp;
var today = DateTime.Now.Date;
Quota q = db_transaction.Quotas.Where(x => x.Quota_Type_Cd.Equals("B")).Where(x => x.Quota_Cd.Equals("Q0001")).SingleOrDefault();
#region account quota used cur
AccountQuotaUsedCur aquc = new AccountQuotaUsedCur();
aquc.Date = today.Date;
aquc.Account = account;
aquc.Quota_Freq_Used_Val = 0;
aquc.Quota_Avail_Flag = true;
aquc.Quota_Dur_Val = Convert.ToByte(q.Quota_Dur_Val);
aquc.Quota_Freq_Val = Convert.ToByte(q.Quota_Freq_Val);
db_transaction.AccountQuotaUsedCurs.Add(aquc);
#endregion
#region account mobile
AccountMobile am = new AccountMobile();
am.Account = account;
am.Mobile_Number = mobile_no;
am.Primary_Flag = true;
am.Status_Cd = "AC";
am.Updated_By = System.Configuration.ConfigurationManager.AppSettings["CREATED_BY_SMS"];
am.Created_By = System.Configuration.ConfigurationManager.AppSettings["CREATED_BY_SMS"];
db_transaction.AccountMobiles.Add(am);
#endregion
#region account interest
AccountInterest ai = new AccountInterest();
ai.Account = account;
db_transaction.AccountInterests.Add(ai);
#endregion
#region account quota
AccountQuota aq = new AccountQuota();
aq.Account = account;
aq.Quota_Cd = q.Quota_Cd;
db_transaction.AccountQuotas.Add(aq);
#endregion
#region update account activation and set status_cd
SqlParameter output = new SqlParameter("acstatus", SqlDbType.Int);
output.Direction = ParameterDirection.Output;
SqlParameter date = new SqlParameter("today", SqlDbType.Date);
date.Value = DateTime.Now;
SqlParameter no_acct_total = new SqlParameter("no_acct_limit_total", SqlDbType.Int);
int no_acct_limit_total = 0;
AdminConfiguration admin_config = db_transaction.AdminConfigurations.SingleOrDefault();
if (admin_config != null)
{
no_acct_limit_total = admin_config.No_Activation_Limit_Total;
}
no_acct_total.Value = no_acct_limit_total;
string sql_string =
"declare @tbt table (acstatus int)" +
"UPDATE Account_Activation " +
"SET No_Activation = CASE WHEN (No_Activation + 1 > No_Max_Activation or (No_Activation_Acc + 1 > @no_acct_limit_total)) THEN No_Activation ELSE No_Activation + 1 END, " +
"No_Activation_Acc = CASE WHEN (No_Activation + 1 > No_Max_Activation or (No_Activation_Acc + 1 > @no_acct_limit_total)) THEN No_Activation_Acc ELSE No_Activation_Acc + 1 END, " +
"No_Activation_Pending = CASE WHEN (No_Activation + 1 > No_Max_Activation or (No_Activation_Acc + 1 > @no_acct_limit_total)) THEN No_Activation_Pending + 1 ELSE No_Activation_Pending END, " +
"Updated_By = 'WEBSITE', " +
"Updated_Dttm = GETDATE() " +
"OUTPUT CASE WHEN (deleted.No_Activation + 1 > deleted.No_Max_Activation or deleted.No_Activation_Acc + 1 > @no_acct_limit_total) THEN 1 ELSE 0 END " +
" into @tbt " +
"WHERE [Date] = @today " +
"select @acstatus = acstatus from @tbt";
db_transaction.Database.ExecuteSqlCommand(sql_string, no_acct_total, date, output);
int sql_result = Convert.ToInt16(output.Value);
if (sql_result == 0)
{
account.Status_Cd = FreebieStatus.AccountActivated();
account.Activation_Dttm = timestamp;
reply_str = System.Configuration.ConfigurationManager.AppSettings["ACD"];
sms_log_result = "Register success";
string q_str = (Convert.ToByte(q.Quota_Freq_Val) * Convert.ToByte(q.Quota_Dur_Val) * 30).ToString();
reply_str = reply_str.Replace("{count}", q.Quota_Freq_Val.ToString());
reply_str = reply_str.Replace("{mins}", q.Quota_Dur_Val.ToString());
reply_str = reply_str.Replace("{num}", q_str);
}
else
{
account.Status_Cd = FreebieStatus.AccountPending();
reply_str = System.Configuration.ConfigurationManager.AppSettings["AP"];
sms_log_result = "Register Pending";
}
#endregion
account.First_Quota_Cd = q.Quota_Cd;
account.First_Quota_Dur_Val = q.Quota_Dur_Val;
account.First_Quota_Freq_Val = q.Quota_Freq_Val;
account.Dummy_Flag = "0";
db_transaction.Accounts.Add(account);
db_transaction.SaveChanges();
scope.Complete();
}
#endregion
#region call_sp
result_sp = CallSP.SP_Insert_Interact_Profile(account.Account_Id);
if (!result_sp[0].Equals("0"))
{
using (var new_db = new EchoContext())
{
SqlParameter date = new SqlParameter("today", SqlDbType.Date);
date.Value = DateTime.Now;
Account remove_ac = new_db.Accounts.SingleOrDefault(x => x.Account_Id == account.Account_Id);
if (remove_ac != null)
{
if (remove_ac.Status_Cd.Equals(FreebieStatus.AccountActivated()))
{
string sql_string =
"UPDATE Account_Activation " +
"SET No_Activation = CASE WHEN (No_Activation - 1 < 0 ) THEN 0 ELSE No_Activation - 1 END, " +
"No_Activation_Acc = CASE WHEN (No_Activation_Acc - 1 < 0 ) THEN 0 ELSE No_Activation_Acc - 1 END, " +
"Updated_By = 'WEBSITE', " +
"Updated_Dttm = GETDATE() " +
"WHERE [Date] = @today ";
new_db.Database.ExecuteSqlCommand(sql_string, date);
}
else
{
if (remove_ac.Status_Cd.Equals(FreebieStatus.AccountPending()))
{
string sql_string =
"UPDATE Account_Activation " +
"SET No_Activation_Pending = CASE WHEN (No_Activation_Pending - 1 < 0 ) THEN 0 ELSE No_Activation_Pending - 1 END, " +
"Updated_By = 'WEBSITE', " +
"Updated_Dttm = GETDATE() " +
"WHERE [Date] = @today ";
new_db.Database.ExecuteSqlCommand(sql_string, date);
}
}
AccountQuotaUsedCur remove_aquc = new_db.AccountQuotaUsedCurs.SingleOrDefault(x => x.Account_Id == account.Account_Id);
if (remove_aquc != null)
{
new_db.AccountQuotaUsedCurs.Remove(remove_aquc);
}
new_db.Accounts.Remove(remove_ac);
new_db.SaveChanges();
}
}
reply_str = System.Configuration.ConfigurationManager.AppSettings["NO_ACCTACTIVATION"];
}
else
{
FreebieEvent.AccountCreateEvent(account, account.First_Mobile_Number, Permission.f_cust_regis_page_id);
}
#endregion
}
else
{
reply_str = System.Configuration.ConfigurationManager.AppSettings["WRONG_FORMAT"];
sms_log_result = "Wrong input Format";
}
}
}
catch (Exception err)
{
reply_str = System.Configuration.ConfigurationManager.AppSettings["NO_ACCTACTIVATION"];
sms_log_result = "System Error";
FreebieEvent.AddCustomError(err.Message, Permission.f_cust_regis_page_id);
}
Encoding encoding = Encoding.GetEncoding("tis-620");
string xml_str = GetReplyXML(reply_str, encoding);
sms_log.Result = sms_log_result;
db.SmsRegistrationLogs.Add(sms_log);
db.SaveChanges();
context.Response.ContentType = "text/xml";
context.Response.ContentEncoding = encoding;
context.Response.Write(xml_str);
}
public ActionResult Index()
{
if (Session["Account_Id"] == null)
{
return(RedirectToAction("~/Users/Login"));
}
int account_id = Convert.ToInt32(Session["Account_Id"].ToString());
var account = db.Accounts.SingleOrDefault(x => x.Account_Id == account_id);
if (account == null)
{
return(HttpNotFound());
}
// var primary_number = db.AccountMobiles.Where(x => x.Account_Id.Equals(account.Account_Id)).Where(x => x.Primary_Flag).SingleOrDefault();
string delete_status = FreebieStatus.MobileDeleted();
//var numbers = db.AccountMobiles.Where(x => x.Account_Id.Equals(account.Account_Id)).Where(x => !x.Status_Cd.Equals(delete_status)).Where(x => !x.Primary_Flag).OrderBy(x => x.Created_Dttm);
string primary_number = "";
string secondary_number = "";
var account_numbers = db.AccountMobiles.Where(x => x.Account_Id.Equals(account.Account_Id)).Where(x => !x.Status_Cd.Equals(delete_status)).OrderByDescending(x => x.Primary_Flag);
IEnumerable <AccountMobile> list_account_numbers = account_numbers.ToList();
foreach (var number in list_account_numbers)
{
if (number.Primary_Flag)
{
primary_number = number.Mobile_Number;
}
else
{
secondary_number += number.Mobile_Number;
if (number != list_account_numbers.Last() && (list_account_numbers.Count() - 1) > 0)
{
secondary_number += ", ";
}
}
}
//IEnumerable<AccountQuota> aqs = db.AccountQuotas.Where(x => x.Account_Id.Equals(account.Account_Id));
//if (aqs.Count() > 0) {
// Quota q = aqs.Last().Quota;
// ViewBag.Quota = q;
// ViewBag.Remaining = q.Quota_Freq_Val;
//}
ViewBag.PNumber = primary_number;
ViewBag.SNumber = secondary_number;
var today = DateTime.Now;
AccountQuotaUsedCur qu = db.AccountQuotaUsedCurs.Where(x => x.Date.Equals(today.Date)).Where(x => x.Account_Id == account.Account_Id).SingleOrDefault();
if (qu != null)
{
int remaining = (Convert.ToInt16(qu.Quota_Freq_Val) - Convert.ToInt16(qu.Quota_Freq_Used_Val));
if (remaining < 0)
{
remaining = 0;
}
ViewBag.Remaining = remaining;
ViewBag.Freq = qu.Quota_Freq_Val;
ViewBag.Dur = qu.Quota_Dur_Val;
}
return(View(account));
}
