protected void btnReject_Click(object sender, EventArgs e) { int AdminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()); Administrators _admin = context.Administrator.ToList().Where(m => m.Administrators_Id == AdminId).FirstOrDefault(); int prdId = Convert.ToInt32(lblProductId.Text); Product _Product = context.Product.ToList().Where(m => m.Product_Id == prdId).FirstOrDefault(); if (_Product.Product_Status != eProductStatus.Rejected.ToString()) { _Product.Product_Status = eProductStatus.Rejected.ToString(); context.Entry(_Product).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); ProductHelper.CreateProductFlow(_Product.Product_Id, _Product.Product_Title, _admin.Administrators_Id, _admin.FullName, "Product " + _Product.Product_Status + " Due to : " + txtReasonReject.Text, _Product.Product_Status); LoadDetail(_Product.Product_Id.ToString()); pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-success alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Success!!! Product Rejected successfully, Product Status Changed to " + _Product.Product_Status; } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Oops!!! You cannot the Reject the product, because Product Already in " + _Product.Product_Status + " Status."; } }
protected void btnProceedToSubmit_Click(object sender, EventArgs e) { int AdminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()); Administrators _admin = bAdministrator.List().Where(m => m.Administrators_Id == AdminId).FirstOrDefault(); Product Product = new Product() { Store_Id = _admin.Store_Id, Product_Title = txtTitle.Text, Product_Description = txtDescription.Content, Product_Specification = txtSpecification.Content, Administrators_Id = _admin.Administrators_Id, Product_Qty = Convert.ToInt32(txtQuantity.Text), Product_Qty_Alert = Convert.ToInt32(txtAlert.Text), Product_Delivery_Time = Convert.ToInt32(txtProductDelieveredIn.Text), Product_Max_Purchase = Convert.ToInt32(txtMaxPurchase.Text), Product_Mkt_Price = Convert.ToDecimal(txtMarketPrice.Text), Product_Our_Price = Convert.ToDecimal(txtOurPrice.Text), Product_ShippingCharge = Convert.ToDecimal(txtShippingCharge.Text), Product_Has_Size = (rdbHasSize.SelectedValue == "Yes") ? true : false, Product_Size = (rdbHasSize.SelectedValue == "Yes") ? txtSize.Text : "No Size", Product_Avail_ZipCode = (txtZipcode.Text != "") ? txtZipcode.Text : "0", Product_Discount = Convert.ToDecimal(txtDiscount.Text), SubCategory_Id = Convert.ToInt32(ddlCategory.SelectedValue), Product_CreatedDate = DateTime.Now, Product_UpdatedDate = DateTime.Now, Product_Status = eProductStatus.ReviewPending.ToString(), Store_Rating = (txtRating.Text != "") ? Convert.ToInt32(txtRating.Text) : 1 }; bProduct.Create(Product); if (string.IsNullOrEmpty(Product.ErrorMessage)) { ProductHelper.CreateProductFlow(Product.Product_Id, Product.Product_Title, _admin.Administrators_Id, _admin.FullName, "New Product Created and Pending for Review", Product.Product_Status); ProductBanners ProductBanner = new ProductBanners() { Product_Id = Product.Product_Id, Administrators_Id = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()), Product_Banner_Default = 1, Product_Banner_Photo = "content/noimage.png", Product_Banner_CreatedDate = DateTime.Now, Product_Banner_UpdatedDate = DateTime.Now }; bProduct.CreateProductBanner(ProductBanner); Response.Redirect("/administration/product/productsdetailstatic.aspx?SavePrdId=1000&Productid=" + Product.Product_Id); } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Product cannot be created. " + Product.ErrorMessage; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { int subCatId = Convert.ToInt32(hdnCatId.Value); int catId = Convert.ToInt32(hdnCurrentSubCatCatId.Value); SubCategories _otherSubCat = bSubCategory.List().Where(m => m.Category_Id == catId && m.SubCategory_Id != subCatId & m.SubCategory_Title == txtCategory.Text).FirstOrDefault(); int adminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()]); if (_otherSubCat == null) { SubCategories SubCategories = bSubCategory.List().Where(m => m.SubCategory_Id == subCatId).FirstOrDefault(); SubCategories.SubCategory_Title = txtCategory.Text; SubCategories.SubCategory_UpdatedDate = DateTime.Now; SubCategories.Administrators_Id = adminId; SubCategories.Category_Id = Convert.ToInt32(ddlCategory.SelectedValue); SubCategories.SubCategory_Status = (chkIsActive.Checked) ? eStatus.Active.ToString() : eStatus.InActive.ToString(); SubCategories = bSubCategory.Update(SubCategories); if (string.IsNullOrEmpty(SubCategories.ErrorMessage) && SubCategories.SubCategory_Status == eStatus.InActive.ToString()) { List <Product> products = new List <Product>(); products = bProduct.List().Where(m => m.Product_Status == eProductStatus.Published.ToString() && m.SubCategory.SubCategory_Id == SubCategories.SubCategory_Id).ToList(); foreach (var item in products) { item.Product_Status = eProductStatus.ReviewPending.ToString(); bProduct.Update(item); ProductHelper.CreateProductFlow(item.Product_Id, item.Product_Title, adminId, "System", "Sub Category In Active : Product Updated and set to Review Pending Status", item.Product_Status); bProduct.DeleteTopEight(item.Product_Id); bProduct.DeleteProductFeature(item.Product_Id); bProduct.DeleteCart(item.Product_Id); } } ActivityHelper.Create("Update Sub Category", "Sub Category Updated On " + DateTime.Now.ToString("D") + " Successfully and Title is " + SubCategories.SubCategory_Title + ".", adminId); Response.Redirect("/administration/categories/subcategory.aspx?id=2000&redirecturl=admin-category-RachnaTeracotta"); } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Oops!! Sub Category not updated successfully, sub category name should not be same as other."; } } catch (Exception ex) { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Oops!! " + ex.Message.ToString(); } }
protected void btnProceedToSubmit_Click(object sender, EventArgs e) { int AdminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["VendorSession"].ToString()].ToString()); Administrators _admin = bAdministrator.List().ToList().Where(m => m.Administrators_Id == AdminId).FirstOrDefault(); int prdId = Convert.ToInt32(hdnProductId.Value); Product Product = bProduct.List().ToList().Where(m => m.Product_Id == prdId).FirstOrDefault(); Product.Store_Id = _admin.Store_Id; if (Product.Product_Title != txtTitle.Text || Product.Product_Description != txtDescription.Content || Product.Product_Specification != txtSpecification.Content) { Product.Product_Title = txtTitle.Text; Product.Product_Description = txtDescription.Content; Product.Product_Specification = txtSpecification.Content; Product.Product_Status = eProductStatus.ReviewPending.ToString(); } Product.Administrators_Id = _admin.Administrators_Id; Product.Product_Qty = Convert.ToInt32(txtQuantity.Text); Product.Product_Qty_Alert = Convert.ToInt32(txtAlert.Text); Product.Product_Delivery_Time = Convert.ToInt32(txtProductDelieveredIn.Text); Product.Product_Max_Purchase = Convert.ToInt32(txtMaxPurchase.Text); Product.Product_Mkt_Price = Convert.ToDecimal(txtMarketPrice.Text); Product.Product_Our_Price = Convert.ToDecimal(txtOurPrice.Text); Product.Product_ShippingCharge = Convert.ToDecimal(txtShippingCharge.Text); Product.Product_Has_Size = (rdbHasSize.SelectedValue == "Yes") ? true : false; Product.Product_Size = (rdbHasSize.SelectedValue == "Yes") ? txtSize.Text : "No Size"; Product.Product_Avail_ZipCode = (txtZipcode.Text != "") ? txtZipcode.Text : "0"; Product.SubCategory_Id = Convert.ToInt32(ddlCategory.SelectedValue); Product.Product_Discount = Convert.ToDecimal(txtDiscount.Text); Product.Product_UpdatedDate = DateTime.Now; Product.Store_Rating = (txtRating.Text != "") ? Convert.ToInt32(txtRating.Text) : 1; bProduct.Update(Product); if (string.IsNullOrEmpty(Product.ErrorMessage)) { ProductHelper.CreateProductFlow(Product.Product_Id, Product.Product_Title, _admin.Administrators_Id, _admin.FullName, "Product Updated and set to Review Pending Status", Product.Product_Status); bProduct.DeleteTopEight(Product.Product_Id); bProduct.DeleteProductFeature(Product.Product_Id); bProduct.DeleteCart(Product.Product_Id); Response.Redirect("/adminvendor/product/productsdetailstatic.aspx?SavePrdId=2000&Productid=" + Product.Product_Id); } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Product cannot be updated. " + Product.ErrorMessage; } }
protected void btnApprove_Click(object sender, EventArgs e) { int AdminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()); Administrators _admin = context.Administrator.ToList().Where(m => m.Administrators_Id == AdminId).FirstOrDefault(); int prdId = Convert.ToInt32(lblProductId.Text); Product _Product = context.Product.ToList().Where(m => m.Product_Id == prdId).FirstOrDefault(); List <ProductBanners> ProductBanners = context.ProductBanner.Where(m => m.Product_Id == _Product.Product_Id).ToList(); if (ProductBanners.Count() > 1 && (!(ProductBanners[0].Product_Banner_Photo == "content/noimage.png" && ProductBanners[0].Product_Banner_Default == 1))) { string currentStatus = _Product.Product_Status; if (_Product.Product_Status != eProductStatus.Published.ToString()) { _Product.Product_Status = ProductHelper.GetProductStatus(currentStatus); context.Entry(_Product).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); ProductHelper.CreateProductFlow(_Product.Product_Id, _Product.Product_Title, _admin.Administrators_Id, _admin.FullName, "Product Updated from" + currentStatus + " to " + _Product.Product_Status, _Product.Product_Status); LoadDetail(_Product.Product_Id.ToString()); pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-success alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Success!!! Product Updated Successfully and Product Status Set to " + _Product.Product_Status + " Status, from " + currentStatus + " Status"; } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Oops!!! You cannot Update the product status to " + _Product.Product_Status + " from " + currentStatus + " Because, Product status is in published status. You can reject the product."; } } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Oops!!! You cannot Update the product status to " + _Product.Product_Status + " Because, there is no enough product banner available(Bnner should not be no image banner and also allease Minimum two banners required). Product should not have default banner."; } }
private void InsertExcelRecords(string FilePath) { List <Product> _products = new List <Product>(); var csvData = System.IO.File.ReadAllLines(FilePath).Skip(1); int insertCount = 0; int updateCount = 0; try { //Execute a loop over the rows. foreach (string row in csvData) { if (!string.IsNullOrEmpty(row)) { if (row != ",,,,,,,,,,,,,,,,") { _products.Add(new Product { Product_Id = Convert.ToInt32(row.Split(',')[0]), SubCategory_Id = Convert.ToInt32(row.Split(',')[1]), Product_Title = row.Split(',')[2], Product_Description = row.Split(',')[3], Product_Specification = row.Split(',')[4], Product_Qty = Convert.ToInt32(row.Split(',')[5]), Product_Qty_Alert = Convert.ToInt32(row.Split(',')[6]), Product_Delivery_Time = Convert.ToInt32(row.Split(',')[7]), Product_Max_Purchase = Convert.ToInt32(row.Split(',')[8]), Product_Mkt_Price = Convert.ToDecimal(row.Split(',')[9]), Product_Our_Price = Convert.ToDecimal(row.Split(',')[10]), Product_ShippingCharge = Convert.ToDecimal(row.Split(',')[11]), Product_Has_Size = Convert.ToBoolean(row.Split(',')[12].ToLower()), Product_Size = row.Split(',')[13], Product_Avail_ZipCode = row.Split(',')[14], Product_Discount = Convert.ToDecimal(row.Split(',')[15]), Product_CreatedDate = DateTime.Now, Product_UpdatedDate = DateTime.Now, Product_Status = eProductStatus.ReviewPending.ToString() }); } } } } catch (Exception ex) { } int AdminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()); Administrators _admin = context.Administrator.ToList().Where(m => m.Administrators_Id == AdminId).FirstOrDefault(); foreach (var item in _products) { SubCategories _subCategory = context.SubCategory.Where(m => m.SubCategory_Id == item.SubCategory_Id).FirstOrDefault(); item.Administrators_Id = _admin.Administrators_Id; item.Store_Id = _admin.Store_Id; if (_subCategory != null) { if (item.Product_Id == 0) { Product Product = new Product() { Store_Id = _admin.Store_Id, Product_Title = item.Product_Title, Product_Description = item.Product_Description, Product_Specification = item.Product_Specification, Administrators_Id = _admin.Administrators_Id, Product_Qty = item.Product_Qty, Product_Qty_Alert = item.Product_Qty_Alert, Product_Delivery_Time = item.Product_Delivery_Time, Product_Max_Purchase = item.Product_Max_Purchase, Product_Mkt_Price = item.Product_Mkt_Price, Product_Our_Price = item.Product_Our_Price, Product_ShippingCharge = item.Product_ShippingCharge, Product_Has_Size = item.Product_Has_Size, Product_Size = (item.Product_Has_Size == true) ? item.Product_Size : "No Size", Product_Avail_ZipCode = item.Product_Avail_ZipCode, Product_Discount = item.Product_Discount, SubCategory_Id = item.SubCategory_Id, Product_CreatedDate = item.Product_CreatedDate, Product_UpdatedDate = item.Product_UpdatedDate, Product_Status = item.Product_Status }; try { int maxAdminId = 1; if (context.Product.ToList().Count > 0) { maxAdminId = context.Product.Max(m => m.Product_Id); } maxAdminId = (maxAdminId == 1 && context.Product.ToList().Count > 0) ? (maxAdminId + 1) : maxAdminId; Product.ProductCode = "PRDTRACH" + maxAdminId + "TERA" + (maxAdminId + 1); context.Product.Add(Product); context.SaveChanges(); ProductHelper.CreateProductFlow(Product.Product_Id, Product.Product_Title, _admin.Administrators_Id, _admin.FullName, "New Product Created", Product.Product_Status); item.Product_Id = Product.Product_Id; insertCount = insertCount + 1; ProductBanners ProductBanner = new ProductBanners() { Product_Id = Product.Product_Id, Administrators_Id = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()), Product_Banner_Default = 1, Product_Banner_Photo = "content/noimage.png", Product_Banner_CreatedDate = DateTime.Now, Product_Banner_UpdatedDate = DateTime.Now }; int maxBnrAdminId = 1; if (context.ProductBanner.ToList().Count > 0) { maxBnrAdminId = context.ProductBanner.Max(m => m.Product_Id); } maxBnrAdminId = (maxBnrAdminId == 1 && context.ProductBanner.ToList().Count > 0) ? (maxBnrAdminId + 1) : maxBnrAdminId; ProductBanner.Product_BannerCode = "PRDBNRTRACH" + maxBnrAdminId + "TERA" + (maxBnrAdminId + 1); context.ProductBanner.Add(ProductBanner); context.SaveChanges(); } catch { } } else { Product _product = context.Product.ToList().Where(m => m.Product_Id == item.Product_Id).FirstOrDefault(); if (_product != null) { _product.Store_Id = _admin.Store_Id; _product.Product_Title = item.Product_Title; _product.Product_Description = item.Product_Description; _product.Product_Specification = item.Product_Specification; _product.Administrators_Id = _admin.Administrators_Id; _product.Product_Qty = item.Product_Qty; _product.Product_Qty_Alert = item.Product_Qty_Alert; _product.Product_Delivery_Time = item.Product_Delivery_Time; _product.Product_Max_Purchase = item.Product_Max_Purchase; _product.Product_Mkt_Price = item.Product_Mkt_Price; _product.Product_Our_Price = item.Product_Our_Price; _product.Product_ShippingCharge = item.Product_ShippingCharge; _product.Product_Size = item.Product_Size; _product.Product_Avail_ZipCode = item.Product_Title; _product.Product_Discount = item.Product_Discount; _product.SubCategory_Id = item.SubCategory_Id; _product.Product_UpdatedDate = item.Product_UpdatedDate; _product.Product_Status = item.Product_Status; try { updateCount = updateCount + 1; context.Entry(_product).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } catch { } } else { item.Product_Status = "Invalid Product Id"; } } } else { item.Product_Status = "Invalid Sub Category Id"; } } pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-success alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "We are done!! " + insertCount + " Products Inserted and " + updateCount + " Products Updated Successfully also we have dowloaded the updated excel. Please check your download folder."; DataTable dt = ConvertToDataTable(_products); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Products.xls")); Response.ContentType = "application/ms-excel"; string str = string.Empty; foreach (DataColumn dtcol in dt.Columns) { Response.Write(str + dtcol.ColumnName); str = "\t"; } Response.Write("\n"); foreach (DataRow dr in dt.Rows) { str = ""; for (int j = 0; j < dt.Columns.Count; j++) { Response.Write(str + Convert.ToString(dr[j])); str = "\t"; } Response.Write("\n"); } Response.End(); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { int id = Convert.ToInt32(hdnCatId.Value); Categories _otherCat = bCategory.List().Where(m => m.Category_Id != id && m.Category_Title == txtCategory.Text).FirstOrDefault(); int adminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()); if (_otherCat == null) { Categories Categories = bCategory.List().Where(m => m.Category_Id == id).FirstOrDefault(); Categories.Category_Title = txtCategory.Text; Categories.Category_UpdatedDate = DateTime.Now; Categories.Administrators_Id = adminId; Categories.Category_Status = (chkIsActive.Checked) ? eStatus.Active.ToString() : eStatus.InActive.ToString(); if (imgInp.HasFile) { Categories.Category_Photo = "files/category/" + "Category_" + Categories.Category_Id + ".png"; string path = Server.MapPath("../" + Categories.Category_Photo); FileInfo file = new FileInfo(path); if (file.Exists)//check file exsit or not { file.Delete(); } Upload(Categories.Category_Id); } Categories = bCategory.Update(Categories); if (string.IsNullOrEmpty(Categories.ErrorMessage) && Categories.Category_Status == eStatus.InActive.ToString()) { List <SubCategories> subCategories = new List <SubCategories>(); List <Product> products = new List <Product>(); subCategories = bSubCategory.List().Where(m => m.Category_Id == Categories.Category_Id && m.SubCategory_Status == eStatus.Active.ToString()).ToList(); foreach (var item113 in subCategories) { List <Product> productsTemp = new List <Product>(); productsTemp = bProduct.List().Where(m => m.Product_Status == eProductStatus.Published.ToString() && m.SubCategory.SubCategory_Id == item113.SubCategory_Id).ToList(); products.AddRange(productsTemp); } foreach (var item in products) { item.Product_Status = eProductStatus.ReviewPending.ToString(); bProduct.Update(item); ProductHelper.CreateProductFlow(item.Product_Id, item.Product_Title, adminId, "System", "Category In Active : Product Updated and set to Review Pending Status", item.Product_Status); bProduct.DeleteTopEight(item.Product_Id); bProduct.DeleteProductFeature(item.Product_Id); bProduct.DeleteCart(item.Product_Id); } } ActivityHelper.Create("Update Category", "New Category Updated On " + DateTime.Now.ToString("D") + " Successfully and Title is " + Categories.Category_Title + ".", adminId); Response.Redirect("/administration/categories/category.aspx?id=2000&redirecturl=admin-category-RachnaTeracotta"); } else { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = "Oops!! Category not updated successfully, category name should not be same as other"; } } catch (Exception ex) { pnlErrorMessage.Attributes.Remove("class"); pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable"; pnlErrorMessage.Visible = true; lblMessage.Text = ex.InnerException.InnerException.Message; } }