public ActionResult DeletePricingDetails(string ProductPricingId)
{
if (User.Identity.IsAuthenticated)
{
if (isAdminUser())
{
StringBuilder ErrorMessages = new StringBuilder();
StringBuilder SuccessMessages = new StringBuilder();
try
{
PricingData pricingData = new PricingData();
if (!string.IsNullOrEmpty(ProductPricingId))
{
pricingData.ProductPricingId = ProductPricingId;
bool InsertResult = false;
InsertResult = PricingDetailsProxy.CUDPricingDetails(pricingData, "Delete");
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails();
PricingDataTable = PricingDataSet.Tables[0];
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
if (InsertResult == false)
{
ErrorMessages.Append(CUDConstants.DeleteError);
}
else
{
SuccessMessages.Append(CUDConstants.DeleteSuccess);
}
}
else
{
ErrorMessages.Append(CUDConstants.DeleteError);
}
}
catch (Exception e)
{
ErrorMessages.Append(CUDConstants.DeleteError);
}
if (!String.IsNullOrEmpty(SuccessMessages.ToString()))
{
managePricing_IndexViewModel.SuccessMessage = SuccessMessages.ToString();
}
if (!String.IsNullOrEmpty(ErrorMessages.ToString()))
{
managePricing_IndexViewModel.ErrorMessage = ErrorMessages.ToString();
}
return(PartialView("PricingDataTable", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult UploadProductImages(HttpPostedFileBase ImageZip)
{
string filename = ImageZip.FileName;
string zippath = Server.MapPath("~/Zip/");
string ExtractPath = Server.MapPath("~/ZipExtract/");
zippath = zippath + filename;
try
{
if (isAdminUser())
{
ImageZip.SaveAs(zippath);
System.IO.Compression.ZipFile.ExtractToDirectory(zippath, ExtractPath);
string ImportValues = ProcessDirectory(ExtractPath);
bool uploadResult = PricingDetailsProxy.InsertBulkPricingPhotoDetails(ImportValues);
managePricing_IndexViewModel.SuccessMessage = UploadConstants.UploadSuccessMessage;
System.IO.File.Delete(zippath);
return(RedirectToAction("Index", "ManagePricing", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
catch (Exception e)
{
managePricing_IndexViewModel.ErrorMessage = CUDConstants.InsertError;
return(RedirectToAction("Index", "ManagePricing", managePricing_IndexViewModel));
}
}
public ActionResult Index(ManagePricing_IndexViewModel managePricing_IndexViewModel)
{
if (User.Identity.IsAuthenticated)
{
if (isAdminUser())
{
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails();
PricingDataTable = PricingDataSet.Tables[0];
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
return(View(managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Index()
{
string controllerName = GetControllerNameByItsRole();
if (User.Identity.IsAuthenticated)
{
if (!isAdminUser())
{
return(RedirectToAction("Index", controllerName));
}
else
{
return(RedirectToAction("Index", "ManagePricing"));
}
}
else
{
managePricing_IndexViewModel = new ManagePricing_IndexViewModel();
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails();
PricingDataTable = PricingDataSet.Tables[0];
PricingDataTable = DataTablePhotoMapping(PricingDataTable);
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
return(View(managePricing_IndexViewModel));
}
}
public ActionResult UpdateCartItem(string ProductPricingId, string CartItemQuantity)
{
if (isValidUser())
{
StringBuilder ErrorMessages = new StringBuilder();
StringBuilder SuccessMessages = new StringBuilder();
try
{
bool UpdateResult = false;
CartData cartData = new CartData();
cartData.ProductPricingId = ProductPricingId;
cartData.Quantity = int.Parse(CartItemQuantity);
cartData.UserId = User.Identity.GetUserId();
UpdateResult = CartDetailsProxy.CUDCartValue(cartData, "Insert/Update");
if (UpdateResult)
{
SuccessMessages.Append(CUDConstants.UpdateCartSuccess);
}
else
{
ErrorMessages.Append(CUDConstants.UpdateCartError);
}
managePricing_IndexViewModel = new ManagePricing_IndexViewModel();
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails();
PricingDataTable = PricingDataSet.Tables[0];
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
managePricing_IndexViewModel.UserId = User.Identity.GetUserId();
}
catch (Exception e)
{
ErrorMessages.Append(CUDConstants.UpdateCartError);
}
if (!String.IsNullOrEmpty(SuccessMessages.ToString()))
{
managePricing_IndexViewModel.SuccessMessage = SuccessMessages.ToString();
}
if (!String.IsNullOrEmpty(ErrorMessages.ToString()))
{
managePricing_IndexViewModel.ErrorMessage = ErrorMessages.ToString();
}
return(PartialView("ChampionsPricingGrid", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult UpdatePricingDetails(PricingData pricingData)
{
if (User.Identity.IsAuthenticated)
{
if (isAdminUser())
{
StringBuilder ErrorMessages = new StringBuilder();
StringBuilder SuccessMessages = new StringBuilder();
try
{
bool UpdateResult = false;
UpdateResult = PricingDetailsProxy.CUDPricingDetails(pricingData, "Update");
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails();
PricingDataTable = PricingDataSet.Tables[0];
PricingDataTable = DataTablePhotoMapping(PricingDataTable);
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
if (UpdateResult == false)
{
ErrorMessages.Append(CUDConstants.UpdateError);
}
else
{
SuccessMessages.Append(CUDConstants.UpdateSuccess);
}
}
catch (Exception e)
{
ErrorMessages.Append(CUDConstants.UpdateError);
}
if (!String.IsNullOrEmpty(SuccessMessages.ToString()))
{
managePricing_IndexViewModel.SuccessMessage = SuccessMessages.ToString();
}
if (!String.IsNullOrEmpty(ErrorMessages.ToString()))
{
managePricing_IndexViewModel.ErrorMessage = ErrorMessages.ToString();
}
return(PartialView("PricingDataTable", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Index()
{
managePricing_IndexViewModel = new ManagePricing_IndexViewModel();
if (User.Identity.IsAuthenticated)
{
if (isValidUser())
{
managePricing_IndexViewModel.IsChampion = true;
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
DataSet CumulativeCartDataSet = new DataSet();
DataTable CumulativeCartDataTable = new DataTable();
string UserId = User.Identity.GetUserId();
PricingDataSet = PricingDetailsProxy.FetchUserPricingDetails(UserId);
PricingDataTable = PricingDataSet.Tables[0];
CumulativeCartDataSet = PricingDetailsProxy.FetchCumulativeCartDetails(UserId);
CumulativeCartDataTable = CumulativeCartDataSet.Tables[0];
foreach (DataRow row in CumulativeCartDataTable.Rows)
{
managePricing_IndexViewModel.TotalItems = row["TotalItems"].ToString();
string Role = GetRolesByUserId(UserId);
if (Role.Equals("Champion", StringComparison.OrdinalIgnoreCase))
{
managePricing_IndexViewModel.TotalBuyValue = row["TotalBuyValue"].ToString();
}
else if (Role.Equals("Customer", StringComparison.OrdinalIgnoreCase))
{
managePricing_IndexViewModel.TotalBuyValue = row["TotalSellValue"].ToString();
}
}
PricingDataTable = DataTablePhotoMapping(PricingDataTable);
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
return(View(managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult CUProductImage(HttpPostedFileBase ImageFile, string ProductId, string ProductPricingId, string Ordinal, string ProductPhotoMappingId)
{
string filename = ImageFile.FileName;
string ImagePath = Server.MapPath("~/ProductImages/");
ImagePath = ImagePath + filename;
try
{
if (isAdminUser())
{
PricingPhotoData pricingPhotoData = new PricingPhotoData();
ImageFile.SaveAs(ImagePath);
string Base64 = ProcessFile(ImagePath);
int OrdinalInt;
int.TryParse(Ordinal, out OrdinalInt);
pricingPhotoData.Ordinal = OrdinalInt;
pricingPhotoData.Photo = Base64;
pricingPhotoData.ProductId = ProductId;
pricingPhotoData.ProductPricingId = ProductPricingId;
if (String.IsNullOrEmpty(ProductPhotoMappingId))
{
pricingPhotoData.ProductPhotoMappingId = Guid.NewGuid().ToString();
PricingDetailsProxy.CUDPricingPhotoDetails(pricingPhotoData, "Insert");
}
else
{
pricingPhotoData.ProductPhotoMappingId = ProductPhotoMappingId;
PricingDetailsProxy.CUDPricingPhotoDetails(pricingPhotoData, "Update");
}
System.IO.File.Delete(ImagePath);
managePricing_IndexViewModel.SuccessMessage = UploadConstants.UploadSuccessMessage;
return(RedirectToAction("Index", "ManagePricing", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
catch (Exception e)
{
managePricing_IndexViewModel.ErrorMessage = CUDConstants.InsertError;
System.IO.File.Delete(ImagePath);
return(RedirectToAction("Index", "ManagePricing", managePricing_IndexViewModel));
}
return(View());
}
public ActionResult Index()
{
if (User.Identity.IsAuthenticated)
{
if (isValidUser())
{
managePricing_IndexViewModel = new ManagePricing_IndexViewModel();
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
DataSet CumulativeCartDataSet = new DataSet();
DataTable CumulativeCartDataTable = new DataTable();
string UserId = User.Identity.GetUserId();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails(UserId);
PricingDataTable = PricingDataSet.Tables[0];
CumulativeCartDataSet = PricingDetailsProxy.FetchCumulativeCartDetails(UserId);
CumulativeCartDataTable = CumulativeCartDataSet.Tables[0];
foreach (DataRow row in CumulativeCartDataTable.Rows)
{
managePricing_IndexViewModel.TotalItems = row["TotalItems"].ToString();
managePricing_IndexViewModel.TotalBuyValue = row["TotalBuyValue"].ToString();
}
PricingDataTable = DataTablePhotoMapping(PricingDataTable);
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
return(View(managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult UploadPricingDetails(PricingList pricingList, HttpPostedFileBase FileUpload)
{
if (User.Identity.IsAuthenticated)
{
if (isAdminUser())
{
StringBuilder ErrorMessages = new StringBuilder();
StringBuilder SuccessMessages = null;
if (FileUpload != null)
{
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
string targetpath = Server.MapPath("~/Doc/");
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
var connectionString = "";
if (filename.EndsWith(".xls"))
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (filename.EndsWith(".xlsx"))
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);
}
var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var pricingLists = from a in excelFile.Worksheet <PricingList>(sheetName) select a;
StringBuilder ImportValues = new StringBuilder();
foreach (var a in pricingLists)
{
try
{
if (a.ProductId != "")
{
PricingList PL = new PricingList();
PL.ProductId = a.ProductId;
PL.ProductName = a.ProductName;
PL.BuyPrice = a.BuyPrice;
PL.SellPrice = a.SellPrice;
PL.Profit = a.Profit;
PL.MRP = a.MRP;
string value = "('" + Guid.NewGuid() + "','" + PL.ProductId + "','" + PL.ProductName + "','" + PL.BuyPrice + "','" + PL.SellPrice + "','" + PL.Profit + "','" + PL.MRP + "',1,getdate(),suser_sname(),null,null),";
ImportValues.Append(value);
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
ErrorMessages.Append("\nProperty: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
//deleting excel file from folder
if ((System.IO.File.Exists(pathToExcelFile)))
{
System.IO.File.Delete(pathToExcelFile);
}
string ImportData = ImportValues.ToString();
ImportData = ImportData.Substring(0, ImportData.Length - 1);
PricingDetailsProxy.InsertBulkPricingDetails(ImportData);
SuccessMessages = new StringBuilder();
SuccessMessages.Append(UploadConstants.UploadSuccessMessage);
}
else
{
ErrorMessages.Append(UploadConstants.InvalidFileFormat);
}
}
else
{
ErrorMessages.Append(UploadConstants.FileNotFound);
}
if (!String.IsNullOrEmpty(SuccessMessages.ToString()))
{
TempData[UploadConstants.UploadSuccess] = SuccessMessages.ToString();
}
if (!String.IsNullOrEmpty(ErrorMessages.ToString()))
{
TempData[UploadConstants.UploadError] = ErrorMessages.ToString();
}
return(RedirectToAction("Index", "ManagePricing"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public JsonResult UploadPricing(PricingList pricingList, HttpPostedFileBase FileUpload)
{
List <string> data = new List <string>();
if (FileUpload != null)
{
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
string targetpath = Server.MapPath("~/Doc/");
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
var connectionString = "";
if (filename.EndsWith(".xls"))
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (filename.EndsWith(".xlsx"))
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);
}
var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var pricingLists = from a in excelFile.Worksheet <PricingList>(sheetName) select a;
StringBuilder ImportValues = new StringBuilder();
foreach (var a in pricingLists)
{
try
{
if (a.ProductId != "")
{
PricingList PL = new PricingList();
PL.ProductId = a.ProductId;
PL.ProductName = a.ProductName;
PL.BuyPrice = a.BuyPrice;
PL.SellPrice = a.SellPrice;
PL.Profit = a.Profit;
PL.MRP = a.MRP;
string value = "('" + Guid.NewGuid() + "','" + PL.ProductId + "','" + PL.ProductName + "','" + PL.BuyPrice + "','" + PL.SellPrice + "','" + PL.Profit + "','" + PL.MRP + "',1,getdate(),suser_sname(),null,null),";
ImportValues.Append(value);
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
//deleting excel file from folder
if ((System.IO.File.Exists(pathToExcelFile)))
{
System.IO.File.Delete(pathToExcelFile);
}
string ImportData = ImportValues.ToString();
ImportData = ImportData.Substring(0, ImportData.Length - 1);
PricingDetailsProxy.InsertBulkPricingDetails(ImportData);
return(Json("success", JsonRequestBehavior.AllowGet));
}
else
{
//alert message for invalid file format
data.Add("<ul>");
data.Add("<li>Only Excel file format is allowed</li>");
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
else
{
data.Add("<ul>");
if (FileUpload == null)
{
data.Add("<li>Please choose Excel file</li>");
}
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateCartItem(string ProductPricingId, string CartItemQuantity)
{
if (isValidUser())
{
StringBuilder ErrorMessages = new StringBuilder();
StringBuilder SuccessMessages = new StringBuilder();
try
{
bool UpdateResult = false;
CartData cartData = new CartData();
cartData.ProductPricingId = ProductPricingId;
cartData.Quantity = int.Parse(CartItemQuantity);
cartData.UserId = User.Identity.GetUserId();
UpdateResult = CartDetailsProxy.CUDCartValue(cartData, "Insert/Update");
if (UpdateResult)
{
SuccessMessages.Append(CUDConstants.UpdateCartSuccess);
}
else
{
ErrorMessages.Append(CUDConstants.UpdateCartError);
}
managePricing_IndexViewModel = new ManagePricing_IndexViewModel();
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
string UserId = User.Identity.GetUserId();
PricingDataSet = PricingDetailsProxy.FetchPricingDetails(UserId);
PricingDataTable = PricingDataSet.Tables[0];
#region CumulativeCartData
DataSet CumulativeCartDataSet = new DataSet();
DataTable CumulativeCartDataTable = new DataTable();
CumulativeCartDataSet = PricingDetailsProxy.FetchCumulativeCartDetails(UserId);
CumulativeCartDataTable = CumulativeCartDataSet.Tables[0];
foreach (DataRow row in CumulativeCartDataTable.Rows)
{
managePricing_IndexViewModel.TotalItems = row["TotalItems"].ToString();
managePricing_IndexViewModel.TotalBuyValue = row["TotalSellValue"].ToString();
}
#endregion
PricingDataTable = DataTablePhotoMapping(PricingDataTable);
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
managePricing_IndexViewModel.UserId = User.Identity.GetUserId();
}
catch (Exception e)
{
ErrorMessages.Append(CUDConstants.UpdateCartError);
}
if (!String.IsNullOrEmpty(SuccessMessages.ToString()))
{
managePricing_IndexViewModel.SuccessMessage = SuccessMessages.ToString();
}
if (!String.IsNullOrEmpty(ErrorMessages.ToString()))
{
managePricing_IndexViewModel.ErrorMessage = ErrorMessages.ToString();
}
return(PartialView("CustomerPricingGrid", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult DeleteCartItem(string ProductPricingId)
{
if (isValidUser())
{
StringBuilder ErrorMessages = new StringBuilder();
StringBuilder SuccessMessages = new StringBuilder();
try
{
bool UpdateResult = false;
CartData cartData = new CartData();
cartData.ProductPricingId = ProductPricingId;
cartData.UserId = User.Identity.GetUserId();
UpdateResult = CartDetailsProxy.CUDCartValue(cartData, "Delete");
if (UpdateResult)
{
SuccessMessages.Append(CUDConstants.UpdateCartSuccess);
}
else
{
ErrorMessages.Append(CUDConstants.UpdateCartError);
}
managePricing_IndexViewModel = new ManagePricing_IndexViewModel();
managePricing_IndexViewModel.IsChampion = true;
DataSet PricingDataSet = new DataSet();
DataTable PricingDataTable = new DataTable();
DataSet CumulativeCartDataSet = new DataSet();
DataTable CumulativeCartDataTable = new DataTable();
string UserId = User.Identity.GetUserId();
PricingDataSet = PricingDetailsProxy.FetchUserPricingDetails(UserId);
PricingDataTable = PricingDataSet.Tables[0];
PricingDataTable = DataTablePhotoMapping(PricingDataTable);
foreach (DataRow row in CumulativeCartDataTable.Rows)
{
managePricing_IndexViewModel.TotalItems = row["TotalItems"].ToString();
string Role = GetRolesByUserId(UserId);
if (Role.Equals("Champion", StringComparison.OrdinalIgnoreCase))
{
managePricing_IndexViewModel.TotalBuyValue = row["TotalBuyValue"].ToString();
}
else if (Role.Equals("Customer", StringComparison.OrdinalIgnoreCase))
{
managePricing_IndexViewModel.TotalBuyValue = row["TotalSellValue"].ToString();
}
}
if (PricingDataTable != null)
{
managePricing_IndexViewModel.PricingDataTable = PricingDataTable;
}
managePricing_IndexViewModel.UserId = User.Identity.GetUserId();
}
catch (Exception e)
{
ErrorMessages.Append(CUDConstants.UpdateCartError);
}
if (!String.IsNullOrEmpty(SuccessMessages.ToString()))
{
managePricing_IndexViewModel.SuccessMessage = SuccessMessages.ToString();
}
if (!String.IsNullOrEmpty(ErrorMessages.ToString()))
{
managePricing_IndexViewModel.ErrorMessage = ErrorMessages.ToString();
}
return(PartialView("CartView", managePricing_IndexViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
