public ActionResult DashBoard(string message = "")
{
if (sessionDTO.getName() == null)
{
return(RedirectToAction("Index", "Admin"));
}
else
{
string dt = DateTime.Now.ToString("dd/MM/yyyy");
string[] st = dt.Split('/');
//Current Month Stats
List <Number> Numlst = new NumberBL().getNumberList().Where(x => x.CreatedAt.Value.Month == Convert.ToInt32(st[1])).ToList();
ViewBag.MNumbersList = Numlst.Count;
List <Customer> DNumlst = new CustomerBL().getCustomerList().Where(x => x.CreatedAt.Value.Month == Convert.ToInt32(st[1]) && x.DesiredNumber != null).ToList();
ViewBag.MDNumbersList = DNumlst.Count;
List <Customer> SNumlst = new CustomerBL().getCustomerList().Where(x => x.CreatedAt.Value.Month == Convert.ToInt32(st[1]) && x.SellingNumber != null).ToList();
ViewBag.MSNumbersList = SNumlst.Count;
List <Subscriber> subslst = new SubscriberBL().getSubscriberList().Where(x => x.CreatedAt.Value.Month == Convert.ToInt32(st[1])).ToList();
ViewBag.SubscribersList = subslst.Count;
//Total Stats
List <Number> Tnumlst = new NumberBL().getNumberList();
ViewBag.TNumbersList = Tnumlst.Count;
List <Customer> TDNumlst = new CustomerBL().getCustomerList().Where(x => x.DesiredNumber != null).ToList();
ViewBag.TDNumbersList = TDNumlst.Count;
List <Customer> TSNumlst = new CustomerBL().getCustomerList().Where(x => x.SellingNumber != null).ToList();
ViewBag.TSNumbersList = TSNumlst.Count;
List <Subscriber> Tsubslst = new SubscriberBL().getSubscriberList();
ViewBag.TSubscribersList = Tsubslst.Count;
ViewBag.message = message;
return(View());
}
}
public ActionResult Index()
{//Mobilink viewbags
List <Number> JazzD = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Status == "Diamond").ToList();
ViewBag.JazzD = JazzD;
List <Number> JazzP = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Status == "Platinium").ToList();
ViewBag.JazzP = JazzP;
List <Number> JazzG = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Status == "Gold").ToList();
ViewBag.JazzG = JazzG;
// Telenor Viewbags
List <Number> TelenorD = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Status == "Diamond").ToList();
ViewBag.TelenorD = TelenorD;
List <Number> TelenorP = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Status == "Platinium").ToList();
ViewBag.TelenorP = TelenorP;
List <Number> TelenorG = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Status == "Diamond").ToList();
ViewBag.TelenorG = TelenorG;
//Ufone Viewbags
List <Number> UfoneD = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Status == "Diamond").ToList();
ViewBag.UfoneD = UfoneD;
List <Number> UfoneP = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Status == "Platinium").ToList();
ViewBag.UfoneP = UfoneP;
List <Number> UfoneG = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Status == "Gold").ToList();
ViewBag.UfoneG = UfoneG;
//warid viewbags
List <Number> WaridD = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Status == "Diamond").ToList();
ViewBag.WaridD = WaridD;
List <Number> WaridP = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Status == "Platinium").ToList();
ViewBag.WaridP = WaridP;
List <Number> WaridG = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Status == "Gold").ToList();
ViewBag.WaridG = WaridG;
//Zong viewbag
List <Number> ZongD = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Status == "Diamond").ToList();
ViewBag.ZongD = ZongD;
List <Number> ZongP = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Status == "Platinium").ToList();
ViewBag.ZongP = WaridP;
List <Number> ZongG = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Status == "Gold").ToList();
ViewBag.ZongG = ZongG;
return(View());
}
public ActionResult PostAddNumber(string Number, string Price, string SelectCompany, string SelectType, string SelectStatus)
{
List <Number> numbs = new NumberBL().getNumberList().ToList();
foreach (Number nm in numbs)
{
if (nm.Number1 == Number)
{
return(RedirectToAction("AddNumber", "Admin", new { message = "Number Already Exists In Database" }));
}
}
Number num = new Number()
{
Number1 = Number,
Price = Price,
Company = SelectCompany,
Type = SelectType,
Status = SelectStatus,
CreatedAt = DateTime.Now,
IsActive = 1
};
if (new NumberBL().AddNumber(num) == false)
{
return(RedirectToAction("AddNumber", "Admin", new { message = "All fields are Required" }));
}
else
{
return(RedirectToAction("AddNumber", "Admin", new { message = "Number's Information Added Succesfully" }));
}
}
public ActionResult DeleteNumber(int NumId)
{
Number num = new NumberBL().getNumberById(NumId);
num.IsActive = 0;
new NumberBL().UpdateNumber(num);
return(RedirectToAction("ListNumbers", "Admin"));
}
public ActionResult EditNumber(int id, string message)
{
if (sessionDTO.getName() == null)
{
return(RedirectToAction("Index", "Admin"));
}
else
{
Number num = new NumberBL().getNumberById(id);
ViewBag.num = num;
ViewBag.message = message;
return(View());
}
}
public ActionResult ListNumbers(string message = "")
{
if (sessionDTO.getName() == null)
{
return(RedirectToAction("Index", "Admin"));
}
else
{
List <Number> numbers = new NumberBL().getNumberList().OrderBy(x => x.Id).ToList();
ViewBag.numbers = numbers;
ViewBag.message = message;
return(View());
}
}
public ActionResult PostEditNumber(int id, string Number, string Price, string SelectCompany, string SelectType, string SelectStatus)
{
List <Number> numbs = new NumberBL().getNumberList().ToList();
Number n = new NumberBL().getNumberById(id);
if (n.Number1 != Number)
{
foreach (Number nm in numbs)
{
if (nm.Number1 == Number)
{
return(RedirectToAction("EditNumber", "Admin", new { id = id, message = "Number Already Exists in Database" }));
}
}
}
Number number = new NumberBL().getNumberById(id);
Number num = new Number()
{
Id = id,
Number1 = Number,
Price = Price,
Company = SelectCompany,
Type = SelectType,
Status = SelectStatus,
CreatedAt = DateTime.Now,
IsActive = 1
};
if (new NumberBL().UpdateNumber(num) == false)
{
return(RedirectToAction("EditNumber", "Admin", new { id = num.Id, message = "All fields are Required" }));
}
else
{
return(RedirectToAction("ListNumbers", "Admin", new { message = "Number's Information Updated Succesfully" }));
}
}
public ActionResult BuyNumber()
{
#region Moblink
List <Number> JazzR = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "Regular").ToList();
ViewBag.JazzR = JazzR;
List <Number> JazzT = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "Triple").ToList();
ViewBag.JazzT = JazzT;
List <Number> JazzTet = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "Tetra").ToList();
ViewBag.JazzTet = JazzTet;
List <Number> JazzP = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "Penta").ToList();
ViewBag.JazzP = JazzP;
List <Number> JazzH = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "Hexa").ToList();
ViewBag.JazzH = JazzH;
List <Number> Jazz7 = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "786").ToList();
ViewBag.Jazz7 = Jazz7;
List <Number> JazzTrP = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "Triple Pair").ToList();
ViewBag.JazzTrP = JazzTrP;
List <Number> JazzUAN = new NumberBL().getNumberList().Where(x => x.Company == "Mobilink" && x.Type == "UAN").ToList();
ViewBag.JazzUAN = JazzUAN;
#endregion
#region Telenor
List <Number> TelenorR = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "Regular").ToList();
ViewBag.TelenorR = TelenorR;
List <Number> TelenorT = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "Triple").ToList();
ViewBag.TelenorT = TelenorT;
List <Number> TelenorTet = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "Tetra").ToList();
ViewBag.TelenorTet = TelenorTet;
List <Number> TelenorP = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "Penta").ToList();
ViewBag.TelenorP = TelenorP;
List <Number> TelenorH = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "Hexa").ToList();
ViewBag.TelenorH = TelenorH;
List <Number> Telenor7 = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "786").ToList();
ViewBag.Telenor7 = Telenor7;
List <Number> TelenorTrP = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "Triple Pair").ToList();
ViewBag.TelenorTrP = TelenorTrP;
List <Number> TelenorUAN = new NumberBL().getNumberList().Where(x => x.Company == "Telenor" && x.Type == "UAN").ToList();
ViewBag.TelenorUAN = TelenorUAN;
#endregion
#region Ufone
List <Number> UfoneR = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "Regular").ToList();
ViewBag.UfoneR = UfoneR;
List <Number> UfoneT = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "Triple").ToList();
ViewBag.UfoneT = UfoneT;
List <Number> UfoneTet = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "Tetra").ToList();
ViewBag.UfoneTet = UfoneTet;
List <Number> UfoneP = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "Penta").ToList();
ViewBag.UfoneP = UfoneP;
List <Number> UfoneH = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "Hexa").ToList();
ViewBag.UfoneH = UfoneH;
List <Number> Ufone7 = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "786").ToList();
ViewBag.Ufone7 = Ufone7;
List <Number> UfoneTrP = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "Triple Pair").ToList();
ViewBag.UfoneTrP = UfoneTrP;
List <Number> UfoneUAN = new NumberBL().getNumberList().Where(x => x.Company == "Ufone" && x.Type == "UAN").ToList();
ViewBag.UfoneUAN = UfoneUAN;
#endregion
#region Warid
List <Number> WaridR = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "Regular").ToList();
ViewBag.WaridR = WaridR;
List <Number> WaridT = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "Triple").ToList();
ViewBag.WaridT = WaridT;
List <Number> WaridTet = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "Tetra").ToList();
ViewBag.WaridTet = WaridTet;
List <Number> WaridP = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "Penta").ToList();
ViewBag.WaridP = WaridP;
List <Number> WaridH = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "Hexa").ToList();
ViewBag.WaridH = WaridH;
List <Number> Warid7 = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "786").ToList();
ViewBag.Warid7 = Warid7;
List <Number> WaridTrP = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "Triple Pair").ToList();
ViewBag.WaridTrP = WaridTrP;
List <Number> WaridUAN = new NumberBL().getNumberList().Where(x => x.Company == "Warid" && x.Type == "UAN").ToList();
ViewBag.WaridUAN = WaridUAN;
#endregion
#region Zong
List <Number> ZongR = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "Regular").ToList();
ViewBag.ZongR = ZongR;
List <Number> ZongT = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "Triple").ToList();
ViewBag.ZongT = ZongT;
List <Number> ZongTet = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "Tetra").ToList();
ViewBag.ZongTet = ZongTet;
List <Number> ZongP = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "Penta").ToList();
ViewBag.ZongP = ZongP;
List <Number> ZongH = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "Hexa").ToList();
ViewBag.ZongH = ZongH;
List <Number> Zong7 = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "786").ToList();
ViewBag.Zong7 = Zong7;
List <Number> ZongTrP = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "Triple Pair").ToList();
ViewBag.ZongTrP = ZongTrP;
List <Number> ZongUAN = new NumberBL().getNumberList().Where(x => x.Company == "Zong" && x.Type == "UAN").ToList();
ViewBag.ZongUAN = ZongUAN;
#endregion
return(View());
}
