protected void Page_Load(object sender, System.EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.VENDOR)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(IsPostBack))
{
if (Session[Constant.SESSION_USERID] != null)
{
ViewState[Constant.SESSION_USERID] = Session[Constant.SESSION_USERID].ToString().Trim();
// Get bid general details
if (Session[Constant.SESSION_BIDREFNO] != null)
{
ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim();
}
CategoryTransaction catTrans = new CategoryTransaction();
BidItem bidItem = BidItemTransaction.GetBidDetailsByRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
lblPRNumber.Text = bidItem.PRRefNo.ToString();
lblBidReferenceNumber.Text = bidItem.BidRefNo.ToString();
lblCategory.Text = catTrans.GetCategoryByID(bidItem.Category).CategoryName;
lblBidSubmissionDeadline.Text = bidItem.Deadline;
lblDeliveryDate.Text = bidItem.DeliveryDate;
lblBidItemDescription.Text = bidItem.ItemDescription;
ShowBidTenders();
}
}
}
private void displayDetails()
{
if (ViewState[Constant.SESSION_BIDREFNO] != null)
{
BidItem biditem = BidItemTransaction.QueryBidItemInfo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction dte = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, biditem.CompanyId.ToString().Trim());
lblRequestor.Text = biditem.Requestor.ToString().Trim();
lblPRNumber.Text = biditem.PRRefNo.ToString().Trim();
lblPRDate.Text = biditem.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, biditem.GroupDeptSec.ToString().Trim());
lblBidReferenceNumber.Text = biditem.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, biditem.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = biditem.Deadline.ToString().Trim();
lblBidItemDescription.Text = biditem.ItemDescription;
lblDeliverTo.Text = biditem.DeliverTo;
lblIncoterm.Text = inc.GetIncotermName(connstring, biditem.Incoterm);
hdBidEventType.Value = biditem.BidStatus.ToString().Trim();
displayItemDetails();
displaySuppliers();
}
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!IsPostBack)
{
PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Add Sub Category");
if (Session["CategoryId"] != null)
{
ViewState["CategoryId"] = Session["CategoryId"].ToString().Trim();
}
CategoryTransaction c = new CategoryTransaction();
ddlCategory.DataSource = c.GetAllCategories(connstring);
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryId";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, "");
if (ViewState["CategoryId"] != null)
{
ddlCategory.SelectedIndex = ddlCategory.Items.IndexOf(ddlCategory.Items.FindByValue(ViewState["CategoryId"].ToString().Trim()));
}
}
}
private void DisplayDetails()
{
AuctionItem auctionItem = AuctionItemTransaction.QueryAuctionItemInfo(ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim());
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
OtherTransaction dte = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, auctionItem.CompanyId.ToString().Trim());
lblRequestor.Text = auctionItem.Requestor.ToString().Trim();
lblPRNumber.Text = auctionItem.PRRefNo.ToString().Trim();
lblPRDate.Text = auctionItem.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, auctionItem.GroupDeptSec.ToString().Trim());
lblAuctionReferenceNumber.Text = auctionItem.AuctionRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, auctionItem.Category.ToString().Trim());
// lblDeadline.Text = auctionItem.Deadline.ToString().Trim();
lblDeliveryDate.Text = auctionItem.DeliveryDate.ToString().Trim();
lblItemDesc.Text = auctionItem.ItemDescription.ToString().Trim();
lblAuctionType.Text = AuctionItemTransaction.GetAuctionTypeById(auctionItem.AuctionType.ToString().Trim());
lblAuctionDeadline.Text = auctionItem.AuctionDeadline.ToString().Trim();
lblAuctionDate.Text = auctionItem.AuctionStartDate.ToString().Trim();
lblAuctionStartTime.Text = auctionItem.AuctionStartTime.ToString().Trim();
lblAuctionEndTime.Text = auctionItem.AuctionEndTime.ToString().Trim();
lblBidCurrency.Text = AuctionItemTransaction.getBidCurrency(auctionItem.BidCurrency.ToString().Trim());
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(IsPostBack))
{
Session[Constant.SESSION_COMMENT_TYPE] = "1";
if (Request.QueryString["AuctionRefNo"] != null)
{
Session["AuctionRefNo"] = Request.QueryString["AuctionRefNo"].ToString().Trim();
}
if (Session["AuctionRefNo"] != null)
{
hdnAuctionRefNo.Value = Session["AuctionRefNo"].ToString().Trim();
}
if (hdnAuctionRefNo.Value.Trim() != "")
{
AuctionTransaction au = new AuctionTransaction();
AuctionItem ai = au.GetAuctionByAuctionRefNo(connstring, hdnAuctionRefNo.Value.Trim());
CompanyTransaction cmp = new CompanyTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CategoryTransaction cat = new CategoryTransaction();
OtherTransaction oth = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, ai.CompanyId.ToString().Trim());
lblRequestor.Text = ai.Requestor.ToString().Trim();
lblPRNumber.Text = ai.PRRefNo.ToString().Trim();
lblPRDate.Text = ai.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, ai.GroupDeptSec.ToString().Trim());
lblSubCategory.Text = cat.GetCategoryNameById(connstring, ai.Category.ToString().Trim());
lblDeadline.Text = ai.AuctionDeadline.ToString().Trim();
lblDeliveryDate.Text = ai.DeliveryDate.ToString().Trim();
lblItemDescription.Text = ai.ItemDescription.ToString().Trim();
lblReferenceNumber.Text = hdnAuctionRefNo.Value.Trim();
lblAuctionType.Text = au.GetAuctionTypeNameById(connstring, ai.AuctionType.ToString().Trim());
lblAuctionConfirmationDeadline.Text = ai.AuctionDeadline.ToString().Trim();
lblAuctionEventDate.Text = ai.AuctionStartDate.ToString().Trim();
lblAuctionStartTime.Text = ai.AuctionStartTimeHour.ToString().Trim() + ":" +
ai.AuctionStartTimeMin.ToString().Trim() + ":" +
ai.AuctionStartTimeSec.ToString().Trim() + " " +
ai.AuctionStartTimeAMPM.ToString().Trim();
lblAuctionEndTime.Text = ai.AuctionEndTimeHour.ToString().Trim() + ":" +
ai.AuctionEndTimeMin.ToString().Trim() + ":" +
ai.AuctionEndTimeSec.ToString().Trim() + " " +
ai.AuctionEndTimeAMPM.ToString().Trim();
lblBidCurrency.Text = oth.GetBidCurrency(ai.BidCurrency.ToString().Trim());
ShowSuppliers();
ShowFiles(ai.FileAttachments.ToString().Trim());
ShowAuctionItems();
}
}
}
public ActionResult Create([Bind(Include = "CategoryId,CategoryName")] ItemCategory itemCategory)
{
if (ModelState.IsValid)
{
itemCategory = new CategoryTransaction().Insert(itemCategory);
return RedirectToAction("Index");
}
return View(itemCategory);
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (Request.QueryString["brn"] != null)
{
Session[Constant.SESSION_BIDREFNO] = Request.QueryString["brn"].ToString();
}
if (!(Page.IsPostBack))
{
if (Request.QueryString[Constant.SESSION_BIDREFNO] != null)
{
Session[Constant.SESSION_BIDREFNO] = Request.QueryString[Constant.SESSION_BIDREFNO].ToString().Trim();
}
if (Session["ORDERBY"] == null)
{
Session["ORDERBY"] = "DESC";
}
BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
VendorTransaction vnd = new VendorTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction obj = new OtherTransaction();
lblBidReferenceNumber.Text = bid.BidRefNo.ToString().Trim();
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblRequestor.Text = bid.Requestor.ToString().Trim();
lblPRNumber.Text = bid.PRRefNo.ToString().Trim();
lblPRDate.Text = bid.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
lblBidRefNo.Text = bid.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim();
lblDeliverTo.Text = bid.DeliverTo.ToString().Trim();
lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
DisplayDetails();
Bind();
}
}
private void ShowBidInfo()
{
CategoryTransaction catTrans = new CategoryTransaction();
BidItem bid = new BidItem();
bid = BidItemTransaction.QueryFactsAboutABidItemByBidRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
lblBidReferenceNumber.Text = bid.BidRefNo.ToString();
lblCategory.Text = ((Category)catTrans.GetCategoryByID(bid.Category)).CategoryName;
lblBidSubmissionDeadline.Text = bid.Deadline;
lblDeliveryDate.Text = bid.DeliveryDate;
lblDeliverTo.Text = bid.DeliverTo;
}
// GET: Common/Item/Create
public ActionResult Create()
{
var categories = new CategoryTransaction().GetList();
IEnumerable<SelectListItem> categoryList = categories.ToList().Select(x => new SelectListItem()
{
Value = x.CategoryId.ToString(),
Text = x.CategoryName
});
var viewItem = new ItemViewPopulated();
viewItem.Categories = new SelectList(categoryList, "Value", "Text");
return View(viewItem);
}
// GET: Admin/ItemCategories/Details/5
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
ItemCategory itemCategory = new CategoryTransaction().GetById(id);
if (itemCategory == null)
{
return HttpNotFound();
}
return View(itemCategory);
}
public async Task DeleteTransactionAsync(int transactionId)
{
var thing = _dbContext.ChangeTracker.Entries();
TransactionBase transaction = new CategoryTransaction
{
Id = transactionId
};
_dbContext.Remove(transaction);
await _dbContext.SaveChangesAsync();
}
private void FillBidInfo()
{// Get bid general details
CategoryTransaction cat = new CategoryTransaction();
IncotermTransaction inc = new IncotermTransaction();
CompanyTransaction cmp = new CompanyTransaction();
BidItem bid = BidItemTransaction.GetBidDetailsByRefNo(hdnBidRefNo.Value.Trim());
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblCategory.Text = cat.GetCategoryNameById(bid.Category.ToString().Trim());
lblBidReferenceNumber.Text = bid.BidRefNo.ToString();
lblBidSubmissionDeadline.Text = bid.Deadline;
lblBidItemDescription.Text = bid.ItemDescription;
lblDeliverTo.Text = bid.DeliverTo;
lblPreferredIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm);
}
protected void Page_Load(object sender, EventArgs e)
{
//FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
//if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
// Response.Redirect("../unauthorizedaccess.aspx");
if (!(IsPostBack))
{
if (Request.QueryString[Constant.QS_CATEGORYID] != null)
{
hdnCategoryId.Value = Request.QueryString[Constant.QS_CATEGORYID].Trim();
}
if (Request.QueryString[Constant.QS_SUBCATEGORYID] != null)
{
hdnSubCategoryId.Value = Request.QueryString[Constant.QS_SUBCATEGORYID].Trim();
}
if (Request.QueryString[Constant.QS_SEARCHTEXT] != null)
{
txtSearch.Text = Request.QueryString[Constant.QS_SEARCHTEXT].Trim();
}
if (Request.QueryString[Constant.QS_CONTROLID] != null)
{
hdnControlId.Value = Request.QueryString[Constant.QS_CONTROLID].Trim();
}
ViewState["SearchString"] = txtSearch.Text.Trim();
ViewState["Mode"] = Constant.SHOWSKU.ToString().Trim();
CategoryTransaction c = new CategoryTransaction();
lblCategory.Text = c.GetCategoryNameById(connstring, hdnCategoryId.Value.Trim());
SubCategory s = new SubCategory();
lblSubCategory.Text = s.GetSubCategoryNameById(connstring, hdnSubCategoryId.Value.Trim());
btnClose.Attributes.Add("onclick", "Close();");
btnOK.Attributes.Add("onclick", "SelectProduct('" + hdnControlId.Value + "');");
ProductsTransaction p = new ProductsTransaction();
lstProducts.DataSource = p.QueryProducts(connstring, ViewState["SearchString"].ToString().Trim(), hdnSubCategoryId.Value.Trim(), hdnCategoryId.Value.Trim(), ViewState["Mode"].ToString().Trim());
lstProducts.DataTextField = ((ViewState["Mode"].ToString().Trim() == Constant.HIDESKU.ToString().Trim()) ? "ItemName_NoSKU" : "ItemName");
lstProducts.DataValueField = "VALUE";
lstProducts.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (!IsPostBack)
{
if (!String.IsNullOrEmpty(Request.QueryString[Constant.QS_CATEGORYID]))
{
ViewState[Constant.QS_CATEGORYID] = Request.QueryString[Constant.QS_CATEGORYID];
ViewState[Constant.QS_SUBCATEGORYID] = Request.QueryString[Constant.QS_SUBCATEGORYID];
CategoryTransaction ct = new CategoryTransaction();
lblCategory.Text = ct.GetCategoryNameById(connstring, Request.QueryString[Constant.QS_CATEGORYID]);
SubCategory st = new SubCategory();
lblSubCategory.Text = st.GetSubCategoryNameById(connstring, Request.QueryString[Constant.QS_SUBCATEGORYID]).Trim() == "" ? "ALL" : st.GetSubCategoryNameById(Request.QueryString[Constant.QS_SUBCATEGORYID]);
}
PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Add One-Time Supplier");
}
}
public CartPrintResult(Cart cart)
{
List <Category> categories = CategoryTransaction.GetCategories();
List <IGrouping <Category, CartItem> > productListGroupping = cart.ProductList.GroupBy(item =>
categories.Where(category => category.Id == item.Product.CategoryId).FirstOrDefault()).ToList();
List <CartPrintItem> cartPrintItems = new List <CartPrintItem>();
productListGroupping.ForEach(productList =>
{
CartPrintItem cartPrintItem = new CartPrintItem();
cartPrintItem.Category = productList.Key;
cartPrintItem.CartItems = productList.ToList();
cartPrintItems.Add(cartPrintItem);
});
CartPrintItems = cartPrintItems;
TotalAmount = cart.GetTotalAmount();
CampaignDiscountAmount = cart.GetCampaignDiscount();
CouponDiscountAmount = cart.GetCouponDiscount();
TotalAmountAfterDiscounts = cart.GetTotalAmountAfterDiscounts();
DeliveryCost = cart.GetDeliveryCost();
}
private void displayDetails()
{
if (Request.QueryString[Constant.SESSION_AUCTIONREFNO] != null)
{
Session[Constant.SESSION_AUCTIONREFNO] = Request.QueryString[Constant.SESSION_AUCTIONREFNO];
}
AuctionItem auctionItem = AuctionItemTransaction.QueryAuctionItemInfo(Session[Constant.SESSION_AUCTIONREFNO].ToString().Trim());
CategoryTransaction category = new CategoryTransaction();
lblAuctionReferenceNumber.Text = auctionItem.AuctionRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(auctionItem.Category.ToString().Trim());
lblDeliveryDate.Text = auctionItem.DeliveryDate.ToString().Trim();
lblItemDesc.Text = auctionItem.ItemDescription.ToString().Trim();
lblAuctionDeadline.Text = auctionItem.AuctionDeadline.ToString().Trim();
lblAuctionDate.Text = auctionItem.AuctionStartDate.ToString().Trim();
lblAuctionStartTime.Text = auctionItem.AuctionStartTime.ToString().Trim();
lblAuctionEndTime.Text = auctionItem.AuctionEndTime.ToString().Trim();
DisplayItemDetails(auctionItem.BidRefNo.ToString().Trim());
}
private void FillDropDownList()
{
SupplierTransaction vnd = new SupplierTransaction();
CategoryTransaction subCat = new CategoryTransaction();
DataSet dsVendors = vnd.GetAllVendors(connstring);
DataTable dsSubCategories = subCat.GetAllCategories(connstring);
ddlCompanies.DataSource = dsVendors.Tables[0];
ddlCompanies.DataTextField = "VendorName";
ddlCompanies.DataValueField = "VendorID";
ddlCompanies.DataBind();
ddlCompanies.Items.Insert(0, new ListItem("[Company]", "0"));
ddlSubCat.DataSource = dsSubCategories;
//ddlSubCat.DataTextField = "SubCategoryName";
//ddlSubCat.DataValueField = "SubCategoryId";
ddlSubCat.DataTextField = "CategoryName";
ddlSubCat.DataValueField = "CategoryId";
ddlSubCat.DataBind();
ddlSubCat.Items.Insert(0, new ListItem("[Sub-category]", "9999"));
}
/// <summary>
/// Returns is campaign usable or not
/// </summary>
/// <param name="cart"></param>
/// <returns></returns>
public bool IsUsable(Cart cart)
{
return(cart.ProductList.Where((cartItem) => cartItem.Product.CategoryId == _categoryId || CategoryTransaction.GetParentCategoryId(cartItem.Product.CategoryId) == _categoryId)
.Sum(cartItem => cartItem.Quantity) >= _minimumItemCount);
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
Session[Constant.SESSION_COMMENT_TYPE] = "0";
if (Request.QueryString["BidRefNo"] != null)
{
Session["BidRefNo"] = Request.QueryString["BidRefNo"].ToString().Trim();
}
BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Request.QueryString["BidRefNo"].ToString().Trim());
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
VendorTransaction vnd = new VendorTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction obj = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblRequestor.Text = bid.Requestor.ToString().Trim();
lblPRNumber.Text = bid.PRRefNo.ToString().Trim();
lblPRDate.Text = bid.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
lblBidRefNo.Text = bid.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim();
lblDeliverTo.Text = bid.DeliverTo.ToString().Trim();
lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
DataTable dtSuppliers = BidItemTransaction.GetSuppliers(connstring, Session["BidRefNo"].ToString().Trim());
gvSuppliers.DataSource = dtSuppliers;
gvSuppliers.DataBind();
DataTable dtFileAttachment = new DataTable();
DataColumn dcol1 = new DataColumn("FILES", typeof(System.String));
dtFileAttachment.Columns.Add(dcol1);
string Files = bid.FileAttachments;
string[] Files1 = Files.Split(Convert.ToChar("|"));
for (int i = 0; i < Files1.Length; i++)
{
//Create a new row
DataRow drow = dtFileAttachment.NewRow();
drow["FILES"] = Files1[i];
dtFileAttachment.Rows.Add(drow);
}
gvFileAttachments.DataSource = dtFileAttachment;
gvFileAttachments.DataBind();
}
}
private void PutDataToComboBoxes()
{
BrandsTransaction brands = new BrandsTransaction();
ItemsCarriedTransaction items = new ItemsCarriedTransaction();
LocationsTransaction loc = new LocationsTransaction();
ServicesTransaction serv = new ServicesTransaction();
CategoryTransaction cat = new CategoryTransaction();
SubCategory sub = new SubCategory();
PCABClassTransaction pcab = new PCABClassTransaction();
ISOStandard iso = new ISOStandard();
ddlBrands.DataSource = brands.GetAllBrands(connstring);
ddlBrands.DataTextField = "BrandName";
ddlBrands.DataValueField = "BrandId";
ddlBrands.DataBind();
ListItem lst = new ListItem();
lst.Text = "Select Brands";
lst.Value = "";
ddlBrands.Items.Insert(0, lst);
ddlItemsCarried.DataSource = items.GetAllItemsCarried(connstring);
ddlItemsCarried.DataTextField = "ItemsCarried";
ddlItemsCarried.DataValueField = "ItemNo";
ddlItemsCarried.DataBind();
ListItem lst1 = new ListItem();
lst1.Text = "Select Items";
lst1.Value = "";
ddlItemsCarried.Items.Insert(0, lst1);
ddlLocations.DataSource = loc.GetAllLocations(connstring);
ddlLocations.DataTextField = "LocationName";
ddlLocations.DataValueField = "LocationId";
ddlLocations.DataBind();
ListItem lst2 = new ListItem();
lst2.Text = "Select Locations";
lst2.Value = "";
ddlLocations.Items.Insert(0, lst2);
ddlServices.DataSource = serv.GetAllServices(connstring);
ddlServices.DataTextField = "ServiceName";
ddlServices.DataValueField = "ServiceId";
ddlServices.DataBind();
ListItem lst3 = new ListItem();
lst3.Text = "Select Services";
lst3.Value = "";
ddlServices.Items.Insert(0, lst3);
ddlCategory.DataSource = cat.GetCategories(connstring);
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryId";
ddlCategory.DataBind();
ListItem lst4 = new ListItem();
lst4.Text = "Select Category";
lst4.Value = "";
ddlCategory.Items.Insert(0, lst4);
ddlSubCategory.DataSource = sub.GetSubCategoryByCategoryId(connstring, ddlCategory.SelectedItem.Value);
ddlSubCategory.DataTextField = "SubCategoryName";
ddlSubCategory.DataValueField = "SubCategoryId";
ddlSubCategory.DataBind();
ListItem lst5 = new ListItem();
lst5.Text = "Select Sub-category";
lst5.Value = "";
ddlSubCategory.Items.Insert(0, lst5);
ddlPCAAB.DataSource = pcab.GetAllPCABClass(connstring);
ddlPCAAB.DataTextField = "PCABClassName";
ddlPCAAB.DataValueField = "PCABClassId";
ddlPCAAB.DataBind();
ListItem lst6 = new ListItem();
lst6.Text = "PCAB Class";
lst6.Value = "";
ddlPCAAB.Items.Insert(0, lst6);
chkISOStandard.DataSource = iso.GetISOStandard(connstring);
//chkISOStandard.DataSource = iso.GetISOStandard(connstring);
chkISOStandard.DataTextField = "ISOStandardName";
chkISOStandard.DataValueField = "ISOStandardId";
chkISOStandard.DataBind();
}
private void Display()
{
BidItem biditem = BidItemTransaction.QueryBidItemInfo(connstring, ViewState["BidRefNo"].ToString().Trim());
//BidItemInfo biditem = obj.Query("91000");
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction dte = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, biditem.CompanyId.ToString().Trim());
lblRequestorName.Text = biditem.Requestor.ToString().Trim();
lblPRNumber.Text = biditem.PRRefNo.ToString().Trim();
lblPRDate.Text = biditem.PRDate.ToString().Trim();
lblGroupDeptSec.Text = grp.GetGroupDeptSecNameById(connstring, biditem.GroupDeptSec.ToString().Trim());
lblBidRefNum.Text = biditem.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, biditem.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = biditem.Deadline.ToString().Trim();
lblBidItemDescription.Text = biditem.ItemDescription;
lblDeliverTo.Text = biditem.DeliverTo;
lblIncoterm.Text = inc.GetIncotermName(connstring, biditem.Incoterm);
DataTable dtSuppliers = new DataTable();
DataColumn dcol = new DataColumn("SUPPLIER", typeof(System.String));
dtSuppliers.Columns.Add(dcol);
string suppliers = biditem.Suppliers;
/*
* if (suppliers != "")
* btnSubmit.Enabled = true;
*/
string[] suppliers1 = suppliers.Split(Convert.ToChar(","));
for (int i = 0; i < suppliers1.Length; i++)
{
//Create a new row
DataRow drow = dtSuppliers.NewRow();
drow["SUPPLIER"] = suppliers1[i];
dtSuppliers.Rows.Add(drow);
}
gvSuppliers.DataSource = dtSuppliers;
gvSuppliers.DataBind();
DataTable dtFileAttachment = new DataTable();
DataColumn dcol1 = new DataColumn("FILES", typeof(System.String));
dtFileAttachment.Columns.Add(dcol1);
string Files = biditem.FileAttachments;
string[] Files1 = Files.Split(Convert.ToChar("|"));
for (int i = 0; i < Files1.Length; i++)
{
//Create a new row
DataRow drow = dtFileAttachment.NewRow();
drow["FILES"] = Files1[i];
dtFileAttachment.Rows.Add(drow);
}
gvFileAttachments.DataSource = dtFileAttachment;
gvFileAttachments.DataBind();
}
protected void Page_Load(object sender, System.EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
if (Session["BidRefNo"] != null)
{
hdnBidRefNo.Value = Session["BidRefNo"].ToString().Trim();
BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, hdnBidRefNo.Value.Trim());
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
SupplierTransaction vnd = new SupplierTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction dte = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblRequestor.Text = bid.Requestor.ToString().Trim();
lblPRNumber.Text = bid.PRRefNo.ToString().Trim();
lblPRDate.Text = bid.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
lblBidReferenceNo.Text = bid.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
lblBidItemDescription.Text = bid.ItemDescription.ToString().Trim();
lblDeliverTo.Text = bid.DeliverTo.ToString().Trim();
lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
lblBidRefNo2.Text = bid.BidRefNo.ToString().Trim();
FillBidItemDetails();
//no checking because when bids are submitted they have suppliers
gvSuppliers.DataSource = BidItemTransaction.GetSuppliers(connstring, hdnBidRefNo.Value.Trim());
gvSuppliers.DataBind();
//DataTable dtFileAttachment = new DataTable();
//DataColumn dcol1 = new DataColumn("FILES", typeof(System.String));
//dtFileAttachment.Columns.Add(dcol1);
//string Files = bid.FileAttachments;
//string[] Files1 = Files.Split(Convert.ToChar("|"));
//for (int i = 0; i < Files1.Length; i++)
//{
// //Create a new row
// DataRow drow = dtFileAttachment.NewRow();
// drow["FILES"] = Files1[i];
// dtFileAttachment.Rows.Add(drow);
//}
//gvFileAttachments.DataSource = dtFileAttachment;
//gvFileAttachments.DataBind();
}
else
{
Response.Redirect("index.aspx");
}
}
}
private void DisplayAvailableAndSelectedSuppliers()
{
if (hdnCategoryId.Value.Trim() != "")
{
CategoryTransaction cat = new CategoryTransaction();
lblSupplierCategory.Text = cat.GetCategoryNameById(connstring, hdnCategoryId.Value.Trim());
string allSelectedVendors = "";
if (hdnSuppliers.Value.Trim() == "")
{
if (hdnOTS.Value.Trim() == "")
{
allSelectedVendors = "";
}
else
{
allSelectedVendors = hdnOTS.Value.Trim();
}
}
else
if (hdnOTS.Value.Trim() == "")
{
allSelectedVendors = hdnSuppliers.Value.Trim();
}
else
{
allSelectedVendors = hdnSuppliers.Value.Trim() + "," + hdnOTS.Value.Trim();
}
SupplierTransaction sup = new SupplierTransaction();
DataSet ds = sup.GetSuppliersByCategoryId_FilteredList(connstring, hdnCategoryId.Value.Trim(), "", allSelectedVendors);
DataTable dtAvailable = new DataTable();
DataTable dtSelected = new DataTable();
if (ds.Tables.Count > 0)
{
try
{
if (ds.Tables[0] != null)
{
dtAvailable = ds.Tables[0];
}
if (ds.Tables.Count > 1)
{
if (ds.Tables[1] != null)
{
dtSelected = ds.Tables[1];
}
}
}
catch
{
}
}
lstSupplierA.DataSource = dtAvailable;
lstSupplierA.DataTextField = "VendorName";
lstSupplierA.DataValueField = "VendorId";
lstSupplierA.DataBind();
lstSupplierB.DataSource = dtSelected;
lstSupplierB.DataTextField = "VendorName";
lstSupplierB.DataValueField = "VendorId";
lstSupplierB.DataBind();
}
}
public override double CalculateTotalDiscount(Cart cart)
{
return(Math.Round(cart.ProductList.Where((cartItem) => cartItem.Product.CategoryId == CategoryId || CategoryTransaction.GetParentCategoryId(cartItem.Product.CategoryId) == CategoryId)
.Sum(cartItem => cartItem.Product.Price * cartItem.Quantity) * DiscountAmount / 100, 2));
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = HttpContext.Current.Session["ConnectionString"].ToString();
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.ADMINISTRATOR)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
if (Session["SKU"] != null)
{
ViewState["SKU"] = Session["SKU"].ToString().Trim();
}
BrandsTransaction brand = new BrandsTransaction();
ServicesTransaction serv = new ServicesTransaction();
SubCategory sub = new SubCategory();
CategoryTransaction c = new CategoryTransaction();
ServicesTransaction s = new ServicesTransaction();
UnitOfMeasurementTransaction u = new UnitOfMeasurementTransaction();
ddlUnitOfMeasure.DataSource = u.GetAllUnitsOfMeasurement(connstring);
ddlUnitOfMeasure.DataTextField = "UnitOfMeasureName";
ddlUnitOfMeasure.DataValueField = "UnitOfMeasureID";
ddlUnitOfMeasure.DataBind();
ddlUnitOfMeasure.Items.Insert(0, "");
ddlCategory.DataSource = c.GetAllCategories(connstring);
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryId";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, "");
ddlSubCategory.DataSource = sub.GetAllSubCategories(connstring);
ddlSubCategory.DataTextField = "SubCategoryName";
ddlSubCategory.DataValueField = "SubCategoryId";
ddlSubCategory.DataBind();
ddlSubCategory.Items.Insert(0, "");
ddlBrand.DataSource = brand.GetAllBrands(connstring);
ddlBrand.DataTextField = "BrandName";
ddlBrand.DataValueField = "BrandId";
ddlBrand.DataBind();
ddlBrand.Items.Insert(0, "");
ddlServiceType.DataSource = s.GetAllServices(connstring);
ddlServiceType.DataTextField = "ServiceName";
ddlServiceType.DataValueField = "ServiceId";
ddlServiceType.DataBind();
ddlServiceType.Items.Insert(0, "");
if (ViewState["SKU"] != null)
{
ProductsTransaction p = new ProductsTransaction();
Product po = new Product();
po = p.QueryProductBySKU(ViewState["SKU"].ToString().Trim(), connstring);
txtSKU.Enabled = false;
txtSKU.Text = po.SKU.Trim();
txtItemName.Text = po.ItemName.Trim();
txtProductDescription.Text = po.ProductDescription.Trim();
ddlUnitOfMeasure.SelectedIndex = ddlUnitOfMeasure.Items.IndexOf(ddlUnitOfMeasure.Items.FindByValue(po.UnitOfMeasure.Trim()));
ddlCategory.SelectedIndex = ddlCategory.Items.IndexOf(ddlCategory.Items.FindByValue(po.Category.Trim()));
ddlSubCategory.SelectedIndex = ddlSubCategory.Items.IndexOf(ddlSubCategory.Items.FindByValue(po.SubCategory.Trim()));
ddlBrand.SelectedIndex = ddlBrand.Items.IndexOf(ddlBrand.Items.FindByValue(po.Brand.Trim()));
ddlServiceType.SelectedIndex = ddlServiceType.Items.IndexOf(ddlServiceType.Items.FindByValue(po.ServiceType.Trim()));
btnDelete.Visible = true;
}
}
}
