// GET: Sales/Edit/5
public ActionResult Edit(int?id)
{
string userId = User.Identity.GetUserId();
var roles = DefualtDB.Roles.Where(a => a.Users.Any(x => x.UserId == userId)).ToList();
if (roles.Count > 0)
{
ViewBag.UserRole = roles[0].Name;
if (roles[0].Name == "Agent")
{
ViewBag.Status = db.Status.Where(a => a.ID == 1 || a.ID == 4).Select(m => new SelectListItem
{
Value = m.ID.ToString(),
Text = m.Name,
}).ToList();
}
else
{
ViewBag.Status = db.Status.Select(m => new SelectListItem
{
Value = m.ID.ToString(),
Text = m.Name,
}).ToList();
}
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Sale saleDB = db.Sales.Where(a => a.ID == id).FirstOrDefault();
SalesViewModel sale = SalesViewModel.GetVMFromDB(saleDB);
if (sale == null)
{
return(HttpNotFound());
}
ViewBag.ChoosenNumbers = db.Numbers.Where(a => a.IsChoosen != true && a.IsPrivate != true || a.ID == sale.ChoosenNo).Select(m => new SelectListItem
{
Value = m.ID.ToString(),
Text = m.No,
}).ToList();
ViewBag.Packages = db.Packages.Select(m => new SelectListItem
{
Value = m.ID.ToString(),
Text = m.PackageName,
}).ToList();
return(View(sale));
}
public ActionResult ActiveIndex()
{
ViewBag.State = "Active";
List <Sale> salesDB = new List <Sale>();
List <SalesViewModel> sales = new List <SalesViewModel>();
string userId = User.Identity.GetUserId();
var user = (new ApplicationDbContext()).Users.FirstOrDefault(s => s.Id == userId);
Session["UserName"] = user.UserName;
Session["UserId"] = user.Id;
var roles = DefualtDB.Roles.Where(a => a.Users.Any(x => x.UserId == userId)).ToList();
if (roles.Count > 0)
{
if (roles[0].Name == "Agent")
{
salesDB = db.Sales.Where(a => a.UserID == userId && a.StatusID == 2).OrderByDescending(s => s.ID).ToList();
foreach (var item in salesDB)
{
sales.Add(SalesViewModel.GetVMFromDB(item));
}
}
else
{
salesDB = db.Sales.Where(a => a.StatusID == 2).OrderByDescending(s => s.ID).ToList();
foreach (var item in salesDB)
{
sales.Add(SalesViewModel.GetVMFromDB(item));
}
}
}
var data = new[] {
new SelectListItem {
Value = "1", Text = "Serial"
},
new SelectListItem {
Value = "2", Text = "ChoosenNo"
},
new SelectListItem {
Value = "3", Text = "CustomerName"
},
};
ViewBag.SearchTypes = data;
return(View("Index", sales));
}
public ActionResult FilterData(int?SearchType, string SearchValue, string FromDateString, string ToDateString, int?StatusID, string ActivationFromDateString, string ActivationToDateString)
{
DateTime?FromDate = null, ToDate = null, ActivationFromDate = null, ActivationToDate = null;
if (FromDateString != "")
{
FromDate = Convert.ToDateTime(FromDateString);
}
if (ToDateString != "")
{
ToDate = Convert.ToDateTime(ToDateString);
ToDate = ToDate.Value.AddDays(1);
}
if (!string.IsNullOrEmpty(ActivationFromDateString))
{
ActivationFromDate = Convert.ToDateTime(ActivationFromDateString);
}
if (!string.IsNullOrEmpty(ActivationToDateString))
{
ActivationToDate = Convert.ToDateTime(ActivationToDateString);
ActivationToDate = ActivationToDate.Value.AddDays(1);
}
List <SalesViewModel> sales = new List <SalesViewModel>();
List <Sale> SalesDB = new List <Sale>();
if (SearchType == 2)
{
SearchValue = GetNumberId(SearchValue).ToString();
}
string userId = User.Identity.GetUserId();
var roles = DefualtDB.Roles.Where(a => a.Users.Any(x => x.UserId == userId)).ToList();
if (roles.Count > 0)
{
if (roles[0].Name == "Agent")
{
if (SearchType == 1)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && a.UserID == userId && ((a.Serial == long.Parse(SearchValue) || (SearchValue == null)) && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
if (SearchType == 2)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && a.UserID == userId && ((a.ChoosenNo == int.Parse(SearchValue) || (SearchValue == null)) && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
if (SearchType == 3)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && a.UserID == userId && (a.CustomerName != null) && ((a.CustomerName.Contains(SearchValue) || (SearchValue == null)) && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
if (SearchType == null)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && a.UserID == userId && ((a.CreationDate >= FromDate || (FromDate == null) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
}
else
{
if (SearchType == 1)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && ((a.Serial == long.Parse(SearchValue) || (SearchValue == null)) && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
if (SearchType == 2)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && ((a.ChoosenNo == int.Parse(SearchValue) || (SearchValue == null)) && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
if (SearchType == 3)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && (a.CustomerName != null) && ((a.CustomerName.Contains(SearchValue) || (SearchValue == null)) && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null))) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
if (SearchType == null)
{
SalesDB = db.Sales.ToList().Where(a => a.StatusID == StatusID && ((a.CreationDate >= FromDate || (FromDate == null)) && (a.CreationDate <= ToDate || (ToDate == null)) && ((a.ActivationDate >= ActivationFromDate || (ActivationFromDate == null)) && (a.ActivationDate <= ActivationToDate || (ActivationToDate == null))))).ToList();
}
}
foreach (var item in SalesDB)
{
sales.Add(SalesViewModel.GetVMFromDB(item));
}
return(PartialView("_index", sales));
}
else
{
return(null);
}
}
