public ActionResult AddNewScript(PromoScript ps)
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
try
{
string logI = HttpContext.User.Identity.Name;
int ret = ScriptDataAccess.SaveNewScript(ps, logI.Split('\\').LastOrDefault());
if (ret > 0)
{
return(RedirectToAction("Index"));
}
else
{
ViewData["Err"] = "Script Template Already Exist!";
}
}
catch (Exception ex)
{
ViewData["Err"] = ex.Message;
}
return(View(ps));
}
public ActionResult AddNewScript()
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
ViewBag.BrandCode = new SelectList(ScriptDataAccess.GetBrands(), "BrandCode", "BrandName", "");
return(View());
}
public ActionResult Index()
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
IEnumerable <PromoScript> scripts = ScriptDataAccess.GetScripts().ToList();
return(View(scripts));
}
public ActionResult EditProductCode(string pId)
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
ProductCode Pc = ProductCodeDataAccess.GetProductCode(pId);
ViewBag.ScriptTemplate = new SelectList(ScriptDataAccess.GetScripts(), "ScriptTemplate", "ScriptName", Pc.ScriptTemplate);
return(View(Pc));
}
public ActionResult EditScript(PromoScript ps, string OldScriptCode)
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
string logI = HttpContext.User.Identity.Name;
try
{
ScriptDataAccess.UpdateScript(ps, OldScriptCode, logI.Split('\\').LastOrDefault());
}
catch
{
ViewBag.OldScriptCode = OldScriptCode;
return(View(ps));
}
return(RedirectToAction("Index"));
}
public ActionResult EditScript(string tId)
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
PromoScript ps = new PromoScript();
DataRow dr = ScriptDataAccess.GetScript(tId);
ps.ScriptTemplate = dr["ScriptCode"].ToString();
ps.ScriptName = dr["ScriptName"].ToString();
ps.BiScriptCode = dr["BIScriptCode"].ToString();
ps.CoreOfferSalesTax = dr["CoreOfferSalesTax"].ToString();
ps.CrossSalesTax = dr["CrossSaleTax"].ToString();
ps.Description = dr["Description"].ToString();
ps.BrandCode = dr["BrandCode"].ToString();
ViewBag.OldScriptCode = dr["ScriptCode"].ToString();
ViewBag.BrandCode = new SelectList(ScriptDataAccess.GetBrands(), "BrandCode", "BrandName", ps.BrandCode);
return(View(ps));
}
public ActionResult UploadProducts(HttpPostedFileBase file, List <ProductCode> model, string Submit)
{
ActiveDirectoryWeb ad = new ActiveDirectoryWeb();
string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|');
ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]);
string logI = HttpContext.User.Identity.Name;
List <ProductCode> pcs = new List <ProductCode>();
List <ProductCode> RetPcs = new List <ProductCode>();
string err;
if (Submit == "Upload")
{
try
{
pcs = LoadProductCodes(file, out err);
if (err == null)
{
foreach (ProductCode pc in pcs)
{
bool exist = ProductCodeDataAccess.CheckIfExist(pc.PCode);
if (exist == false)
{
RetPcs.Add(pc);
}
}
//future function
//foreach (ProductCode pc in pcs)
//{
// bool forUpdating = ProductCodeDataAccess.CheckIfForUpdating(pc);
// if (forUpdating == true)
// {
// RetPcs.Add(pc);
// }
//}
}
else
{
ViewData["Error"] = err;
return(View());
}
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
return(View());
}
if (RetPcs.Count() <= 0)
{
ViewData["Error"] = "No New ProductCode Found!";
}
ViewBag.ScriptTemplate = new SelectList(ScriptDataAccess.GetScripts(), "ScriptTemplate", "ScriptName");
return(View(RetPcs));
}
else
{
if (model != null)
{
foreach (ProductCode pc in model)
{
try
{
ProductCodeDataAccess.InsertProduct(pc, logI.Split('\\').LastOrDefault());
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
ViewBag.ScriptTemplate = new SelectList(ScriptDataAccess.GetScripts(), "ScriptTemplate", "ScriptName");
return(View(model));
}
}
}
ViewData["Success"] = "Product Code Successfully uploaded!";
return(RedirectToAction("Index"));
}
}
