public string AddShipToAddress(OutletViewModel ovm)
{
return "noma sana";
}
public ActionResult ImportOutlets(HttpPostedFileBase file)
{
try
{
// extract only the fielname
var fileName = Path.GetFileName(file.FileName);
// var pathh = Path.Combine(Server.MapPath("./Uploads"), fileName);
var directory = Server.MapPath("~/Uploads");
if (Directory.Exists(directory) == false)
{
Directory.CreateDirectory(directory);
}
var path = Server.MapPath("~/Uploads") + "\\" + fileName;
file.SaveAs(path);
string fileExtension = Path.GetExtension(fileName);
if (fileExtension == ".xlsx")
{
ViewBag.msg = "Please wait. Upload in progress";
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;HDR=YES;'";
OleDbConnection conn = new OleDbConnection(connectionString);
try
{
conn.Open();
OleDbCommand command = new OleDbCommand("SELECT code,name,distributor,route,category,type,discountgroup,vatclass,tier FROM [Sheet1$]", conn);
OleDbDataReader reader = command.ExecuteReader();
OutletViewModel pdvm = new OutletViewModel();
while (reader.Read())
{
string outletCode = reader["code"].ToString().ToLower();
string name = reader["name"].ToString().ToLower();
string distributor = reader["distributor"].ToString();
string route = reader["route"].ToString();
string outletCategory = reader["Category"].ToString();
string outletType = reader["Type"].ToString();
string discountGroup = reader["discountGroup"].ToString();
string vatClass = reader["vatClass"].ToString();
string pricingTier = reader["tier"].ToString();
// bool hasDuplicateName = _outletViewModelBuilder.GetAll()
//.Any(p => p.Username == username);
// if (hasDuplicateName)
// { }
// else
// {
pdvm.OutLetCode = outletCode;
pdvm.Name = name;
pdvm.DiscountGroupName = discountGroup;
pdvm.pricingTierCode = pricingTier;
pdvm.vatClassName = vatClass;
pdvm.OutletTypeCode =outletType;
pdvm.OutletCategoryCode = outletCategory;
pdvm.Code = route;
pdvm.DistributorName = distributor;
_outletViewModelBuilder.Save(pdvm);
// }
}
}
catch (OleDbException ex)
{
ViewBag.msg = ex.ToString();
return View();
}
finally
{
conn.Close();
}
fi = new FileInfo(path);
fi.Delete();
_auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Import", "Users", DateTime.Now);
ViewBag.msg = "Upload Successful";
return RedirectToAction("ListOutlets");
}
else
{
fi = new FileInfo(path);
fi.Delete();
ViewBag.msg = "Please upload excel file with extension .xlsx";
return View();
}
}
catch (Exception ex)
{
ViewBag.msg = ex.ToString();
return View();
}
}
public ActionResult CreateOutlets(OutletViewModel ovm)
{
ViewBag.msg = null;
ViewBag.RouteList = _outletViewModelBuilder.Route();
ViewBag.OutletCategoryList = _outletViewModelBuilder.OutletCategory();
ViewBag.OutletTypeList = _outletViewModelBuilder.OutletType();
ViewBag.DistributorList = _outletViewModelBuilder.GetDistributor();
ViewBag.DiscountGroupList = _outletViewModelBuilder.GetDiscountGroup();
ViewBag.VatClassList = _outletViewModelBuilder.GetVatClass();
ViewBag.PricingTierList = _outletViewModelBuilder.GetPricingTier();
ViewBag.ASMList = _outletViewModelBuilder.ASM();
ViewBag.SalesRepList = _outletViewModelBuilder.SalesRep();
ViewBag.SurveyorList = _outletViewModelBuilder.Surveyor();
try
{
if (ovm.RouteId == Guid.Empty)
{
ModelState.AddModelError("Outlets", "Route Is Required For This Outlet:"+" "+ovm.Name);
return View();
}
else
{
ovm.Id = Guid.Empty;
_outletViewModelBuilder.Save(ovm);
_auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Create", "Outlet", DateTime.Now);
var lastAddedOutlet = _outletViewModelBuilder.GetLastCreatedOutlet();
return RedirectToAction("CreateContact", "Contact", new { CostCentre = lastAddedOutlet.Id, CostCentreName = lastAddedOutlet.Name, ContactFor = "Outlet" });
}
}
catch (DomainValidationException dve)
{
ValidationSummary.DomainValidationErrors(dve,ModelState);
//ViewBag.msg = dve.Message;
_log.Debug("Failed to create outlet " + dve.Message);
_log.Error("Failed to create outlet " + dve.ToString());
return View();
}
catch (Exception ex)
{
ViewBag.msg = ex.Message;
_log.Debug("Failed to create outlet " + ex.Message);
_log.Error("Failed to create outlet " + ex.ToString());
return View();
}
}
public ActionResult EditOutlets(OutletViewModel ovm)
{
var regionId = _outletViewModelBuilder.GetRegionIdForDistributor(ovm.distributor);
ViewBag.RouteList = _outletViewModelBuilder.Route(regionId);
ViewBag.OutletCategoryList = _outletViewModelBuilder.OutletCategory();
ViewBag.OutletTypeList = _outletViewModelBuilder.OutletType();
ViewBag.DistributorList = _outletViewModelBuilder.GetDistributor();
ViewBag.DiscountGroupList = _outletViewModelBuilder.GetDiscountGroup();
ViewBag.VatClassList = _outletViewModelBuilder.GetVatClass();
ViewBag.PricingTierList = _outletViewModelBuilder.GetPricingTier();
ViewBag.ASMList = _outletViewModelBuilder.ASM();
ViewBag.SalesRepList = _outletViewModelBuilder.SalesRep();
ViewBag.SurveyorList = _outletViewModelBuilder.Surveyor();
try
{
if (ovm.RouteId == Guid.Empty)
{
ModelState.AddModelError("Outlets", "Route Is Required For This Outlet:" + " " + ovm.Name);
return View();
}
else
{
_outletViewModelBuilder.Save(ovm);
_auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Edit", "Outlet", DateTime.Now);
return RedirectToAction("ListOutlets");
}
}
catch (DomainValidationException dve)
{
ValidationSummary.DomainValidationErrors(dve, ModelState);
OutletViewModel ovmErr = _outletViewModelBuilder.Get(ovm.Id);
return View(ovmErr);
}
catch (Exception ex)
{
_log.Debug("Failed to edit outlet " + ex.Message);
_log.Error("Failed to edit outlet " + ex.ToString());
OutletViewModel ovmErr = _outletViewModelBuilder.Get(ovm.Id);
return View(ovmErr);
}
}
public ActionResult ListOutlets(bool? showInactive, string searchText, string Distributor = "", int page = 1, int itemsperpage = 10)
{
try
{
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
if (itemsperpage != null)
{
ViewModelBase.ItemsPerPage = itemsperpage;
}
bool showinactive = false;
if (showInactive != null)
showinactive = (bool)showInactive;
ViewBag.showInactive = showinactive;
ViewBag.DistributorList = _outletViewModelBuilder.GetDistributor();
if (TempData["msg"] != null)
{
ViewBag.msg = TempData["msg"].ToString();
TempData["msg"] = null;
}
ViewBag.searchText = searchText;
stopWatch.Stop();
TimeSpan ts = stopWatch.Elapsed;
// Format and display the TimeSpan value.
string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts.Hours,
ts.Minutes,
ts.Seconds,
ts.TotalMilliseconds);
stopWatch.Reset();
_auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Timestamp", "Outlet Controller:" + elapsedTime, DateTime.Now);
//return View(outletsPagedListContainer);
int currentPageIndex = page < 0 ? 0 : page - 1;
int take = itemsperpage;
int skip = currentPageIndex*take;
var query = new QueryStandard()
{
ShowInactive = showinactive,
Name = searchText,
Skip = skip,
Take = take
};
Guid dist = Guid.Empty;
if (Distributor == null || Distributor == "")
{
dist = Guid.Empty;
}
else
{
Guid.TryParse(Distributor, out dist);
}
var ls = _outletViewModelBuilder.Query(query, dist);
var data = ls.Data;
var count = ls.Count;
return View(data.ToPagedList(currentPageIndex,ViewModelBase.ItemsPerPage, count));
}
catch (Exception ex)
{
_log.Debug("Failed to list outlet " + ex.Message);
_log.Error("Failed to list outlet " + ex.ToString());
OutletViewModel ovm = new OutletViewModel();
ovm.ErrorText = ex.ToString();
return View(ovm);
}
}
