public ActionResult ChangePrimary(string phone_number)
{
string delete_status = FreebieStatus.MobileDeleted();
AccountMobile am = db.AccountMobiles.Where(x => x.Mobile_Number.Equals(phone_number)).Where(x => !x.Status_Cd.Equals(delete_status)).SingleOrDefault();
if (am == null)
{
return(HttpNotFound());
}
int account_id = am.Account_Id;
Account account = db.Accounts.SingleOrDefault(x => x.Account_Id == account_id);
IEnumerable <AccountMobile> account_numbers = db.AccountMobiles.Where(x => x.Account_Id.Equals(account_id)).Where(x => !x.Status_Cd.Equals(delete_status));
foreach (var number in account_numbers)
{
if (number.Mobile_Number.Equals(phone_number))
{
number.Primary_Flag = true;
}
else
{
number.Primary_Flag = false;
}
number.Updated_By = System.Configuration.ConfigurationManager.AppSettings["SystemUsername"];
number.Updated_Dttm = DateTime.Now;
}
db.SaveChanges();
FreebieEvent.UpdateMobile(account, phone_number, "A04", Permission.f_update_number_page_id);
return(RedirectToAction("ViewNumber", "AccInfo"));
}
public ActionResult ViewNumber()
{
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());
}
string status = FreebieStatus.MobileActive();
var account_numbers = db.AccountMobiles.Where(x => x.Account_Id.Equals(account.Account_Id)).Where(x => x.Status_Cd.Equals(status)).OrderByDescending(x => x.Primary_Flag);
return(View(account_numbers.ToList()));
}
public ActionResult RemoveNumber(string phone_number)
{
string delete_status = FreebieStatus.MobileDeleted();
AccountMobile am = db.AccountMobiles.Where(x => x.Mobile_Number.Equals(phone_number)).Where(x => !x.Status_Cd.Equals(delete_status)).SingleOrDefault();
if (am == null)
{
return(HttpNotFound());
}
else
{
// db.AccountMobiles.Remove(am);
am.Status_Cd = FreebieStatus.MobileDeleted();
am.Updated_By = System.Configuration.ConfigurationManager.AppSettings["SystemUsername"];
am.Updated_Dttm = DateTime.Now;
db.SaveChanges();
FreebieEvent.UpdateMobile(am.Account, phone_number, "A05", Permission.f_update_number_page_id);
}
return(RedirectToAction("ViewNumber", "AccInfo"));
}
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));
}
public ActionResult AddNumber(string phoneNumber)
{
string password = Request.Form["Password"];
phoneNumber = GetCookie("Acct", "phone_number");
bool flag = true;
if (string.IsNullOrEmpty(phoneNumber))
{
ViewBag.ValidNumber = false;
ViewBag.PhoneNumber = "";
flag = false;
}
ViewBag.PhoneNumber = phoneNumber;
string otp = Request.Form["Password"];
if (flag && (string.IsNullOrEmpty(otp) || otp.Length < 4))
{
ViewBag.ValidNumber = true;
ViewBag.Error = true;
ViewBag.ErrorMessage = System.Configuration.ConfigurationManager.AppSettings["Validate010"];
flag = false;
}
if (flag)
{
int result = OTPHandler.ValidateOTP(phoneNumber, otp);
switch (result)
{
case 0:
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());
}
AccountMobile am = db.AccountMobiles.Where(x => x.Account_Id.Equals(account.Account_Id)).Where(x => x.Mobile_Number.Equals(phoneNumber)).SingleOrDefault();
bool first_create = false;
if (am == null)
{
am = new AccountMobile();
am.Account_Id = account.Account_Id;
am.Status_Cd = FreebieStatus.MobileActive();
am.Mobile_Number = phoneNumber;
am.Primary_Flag = false;
am.Created_Dttm = DateTime.Now;
am.Updated_Dttm = DateTime.Now;
first_create = true;
}
if (first_create)
{
db.AccountMobiles.Add(am);
}
else
{
am.Status_Cd = FreebieStatus.MobileActive();
am.Created_Dttm = DateTime.Now;
am.Updated_Dttm = DateTime.Now;
db.Entry(am).State = EntityState.Modified;
}
OTP otp_request = db.OTPs.SingleOrDefault(x => x.PhoneNumber.Equals(phoneNumber));
if (otp_request != null)
{
db.OTPs.Remove(otp_request);
}
db.SaveChanges();
FreebieEvent.UpdateMobile(account, phoneNumber, "A03", Permission.f_update_number_page_id);
RemoveCoookie("Acct");
return(RedirectToAction("ViewNumber", "AccInfo"));
case 1:
ViewBag.Error = true;
ViewBag.ValidNumber = true;
ViewBag.ErrorMessage = System.Configuration.ConfigurationManager.AppSettings["Validate007"];
ViewBag.ShowPwd = true;
break;
case 2:
ViewBag.ValidNumber = false;
ViewBag.PhoneNumber = "";
ViewBag.ResetOTP = System.Configuration.ConfigurationManager.AppSettings["Otp03"];
RemoveCoookie("Acct");
break;
case 3:
ViewBag.ValidNumber = false;
ViewBag.PhoneNumber = "";
ViewBag.ResetOTP = System.Configuration.ConfigurationManager.AppSettings["Otp04"];
RemoveCoookie("Acct");
break;
default:
break;
}
}
ViewBag.ShowPwd = true;
return(View());
}
