public BidTenderGeneral GetBidTenderGeneral(string connstring, string refNo, int vendorId) { BidTenderGeneral bidTenderGeneral = new BidTenderGeneral(); ArrayList arrBidRefNo = new ArrayList(); SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@refNo", SqlDbType.Int); sqlparams[0].Value = Int32.Parse(refNo); sqlparams[1] = new SqlParameter("@vendorId", SqlDbType.Int); sqlparams[1].Value = vendorId; DataSet bidData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_GetBidTendersPassword", sqlparams); if (bidData.Tables[0].Rows.Count > 0) { foreach (DataTable table in bidData.Tables) { foreach (DataRow row in table.Rows) { bidTenderGeneral.Password = row["Password"].ToString(); } } } return(bidTenderGeneral); }
public BidTenderGeneral QueryBidTendersGeneral(string connstring, string BidRefNo, string VendorId) { SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@bidRefNo", SqlDbType.Int); sqlparams[0].Value = Int32.Parse(BidRefNo); sqlparams[1] = new SqlParameter("@vendorId", SqlDbType.Int); sqlparams[1].Value = Int32.Parse(VendorId); DataSet bidData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_QueryBidTendersGeneral", sqlparams); BidTenderGeneral bid = new BidTenderGeneral(); if (bidData.Tables[0].Rows.Count > 0) { DataRow row = bidData.Tables[0].Rows[0]; bid.Currency = row["Currency"].ToString().Trim(); bid.DeliveryCost = (row["DeliveryCost"].ToString().Trim().Length > 0) ? String.Format("{0:f}", float.Parse(row["DeliveryCost"].ToString().Trim())) : "0.00"; bid.Discount = (row["Discount"].ToString().Trim().Length > 0) ? String.Format("{0:f}", float.Parse(row["Discount"].ToString().Trim())) : "0.00"; //bid.TotalCost = (row["TotalCost"].ToString().Trim().Length > 0) ? String.Format("{0:f}", float.Parse(row["TotalCost"].ToString().Trim())) : "0.00"; bid.Incoterm = row["Incoterm"].ToString().Trim(); bid.PaymentTerms = row["PaymentTerms"].ToString().Trim(); bid.PaymentTerms = row["LeadTime"].ToString().Trim(); bid.Warranty = row["Warranty"].ToString().Trim(); bid.Remarks = row["Remarks"].ToString().Trim(); //bid.TotalExtendedCost = (row["TotalExtendedCost"].ToString().Trim().Length > 0) ? String.Format("{0:f}", float.Parse(row["TotalExtendedCost"].ToString().Trim())) : "0.00"; bid.Mode_BidTendersGeneral = "Edit"; } else { bid.Currency = ""; bid.DeliveryCost = "0.00"; bid.Discount = "0.00"; bid.TotalCost = "0.00"; bid.Incoterm = ""; bid.PaymentTerms = ""; bid.Warranty = ""; bid.Remarks = ""; bid.TotalExtendedCost = "0.00"; bid.Mode_BidTendersGeneral = "Add"; } return(bid); }
private void ShowBidTenders() { #region Code for preparing the DataTable BidTenderTransaction bt = new BidTenderTransaction(); int count = 0; DataTable dtTenders = bt.GetBidTenders(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), ViewState[Constant.SESSION_USERID].ToString().Trim(), ref count); Session["Mode_BidTenders"] = ((count == 0) ? "Add" : "Edit"); //Create an instance of DataTable DataTable dt = new DataTable(); DataColumn dcol = new DataColumn(ID, typeof(System.String)); dcol = new DataColumn("ITEM", typeof(System.String)); dt.Columns.Add(dcol); dcol = new DataColumn("AMOUNT", typeof(System.String)); dt.Columns.Add(dcol); dcol = new DataColumn("TENDERDATE", typeof(System.String)); dt.Columns.Add(dcol); dcol = new DataColumn("BIDTENDERNO", typeof(System.String)); dt.Columns.Add(dcol); dcol = new DataColumn("BIDDETAILNO", typeof(System.String)); dt.Columns.Add(dcol); //Now add data for dynamic columns for (int i = 0; i < dtTenders.Rows.Count; i++) { //Create a new row DataRow drow = dt.NewRow(); drow["ITEM"] = dtTenders.Rows[i]["ITEM"].ToString().Trim(); drow["AMOUNT"] = ((i == dtTenders.Rows.Count - 1) ? "Last|" + dtTenders.Rows[i]["AMOUNT"].ToString().Trim() : dtTenders.Rows[i]["AMOUNT"].ToString().Trim()); drow["TENDERDATE"] = "DATE|" + dtTenders.Rows[i]["TENDERDATEMONTH"].ToString().Trim() + "/" + dtTenders.Rows[i]["TENDERDATEDAY"].ToString().Trim() + "/" + dtTenders.Rows[i]["TENDERDATEYEAR"].ToString().Trim(); drow["BIDTENDERNO"] = dtTenders.Rows[i]["BIDTENDERNO"].ToString().Trim(); drow["BIDDETAILNO"] = dtTenders.Rows[i]["BIDDETAILNO"].ToString().Trim(); dt.Rows.Add(drow); } IOClass IO = new IOClass(); IO.WriteIndexToFile(dtTenders.Rows.Count.ToString().Trim(), Session[Constant.SESSION_USERID].ToString().Trim()); BidTenderGeneral bidtender = new BidTenderGeneral(); bidtender = bt.QueryBidTendersGeneral(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), ViewState[Constant.SESSION_USERID].ToString().Trim()); Session["Mode_BidTendersGeneral"] = bidtender.Mode_BidTendersGeneral.ToString().Trim(); DataRow drow1 = dt.NewRow(); drow1["ITEM"] = "Discount"; drow1["AMOUNT"] = "Discount|" + bidtender.Discount.ToString().Trim(); drow1["TENDERDATE"] = "Discount|NONE"; dt.Rows.Add(drow1); DataRow drow2 = dt.NewRow(); drow2["ITEM"] = "Total Cost"; drow2["AMOUNT"] = "Total Cost|" + bidtender.TotalCost.ToString().Trim(); drow2["TENDERDATE"] = "Total Cost|NONE"; dt.Rows.Add(drow2); DataRow drow3 = dt.NewRow(); drow3["ITEM"] = "Delivery Cost"; drow3["AMOUNT"] = "Delivery Cost|" + bidtender.DeliveryCost.ToString().Trim(); drow3["TENDERDATE"] = "Delivery Cost|NONE"; dt.Rows.Add(drow3); DataRow drow4 = dt.NewRow(); drow4["ITEM"] = "Total Extended Cost"; drow4["AMOUNT"] = "Total Extended Cost|" + bidtender.TotalExtendedCost.ToString().Trim(); drow4["TENDERDATE"] = "Total Extended Cost|NONE"; dt.Rows.Add(drow4); DataRow drow5 = dt.NewRow(); drow5["ITEM"] = "Incoterm"; drow5["AMOUNT"] = "Incoterm|" + bidtender.Incoterm.ToString().Trim(); drow5["TENDERDATE"] = "Incoterm|NONE"; dt.Rows.Add(drow5); DataRow drow6 = dt.NewRow(); drow6["ITEM"] = "Payment Terms"; drow6["AMOUNT"] = "Payment Terms|" + bidtender.PaymentTerms.ToString().Trim(); drow6["TENDERDATE"] = "Payment Terms|NONE"; dt.Rows.Add(drow6); DataRow drow7 = dt.NewRow(); drow7["ITEM"] = "Warranty"; drow7["AMOUNT"] = "Warranty|" + bidtender.Warranty.ToString().Trim(); drow7["TENDERDATE"] = "Warranty|NONE"; dt.Rows.Add(drow7); DataRow drow8 = dt.NewRow(); drow8["ITEM"] = "Remarks"; drow8["AMOUNT"] = "Remarks|" + bidtender.Remarks.ToString().Trim(); drow8["TENDERDATE"] = "Remarks|NONE"; dt.Rows.Add(drow8); #endregion //Iterate through the columns of the datatable to set the data bound field dynamically. foreach (DataColumn col in dt.Columns) { //Declare the bound field and allocate memory for the bound field. CustomBoundField bfield = new CustomBoundField(); //Initalize the DataField value. bfield.DataField = col.ColumnName; bfield.HeaderStyle.CssClass = "itemDetails_th"; switch (col.ColumnName) { case "ITEM": //Initialize the HeaderText field value. bfield.HeaderText = "Item"; bfield.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); bfield.ItemStyle.CssClass = "itemDetails_td"; bfield.DataField = "ITEM"; bfield.VendorId = Session[Constant.SESSION_USERID].ToString().Trim(); bfield.Editable = false; bfield.Date = false; bfield.Label2 = false; bfield.Label4 = true; bfield.LabelDate = false; break; case "AMOUNT": //Initialize the HeaderText field value. bfield.HeaderText = "Item Cost"; bfield.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); bfield.DataField = "AMOUNT"; bfield.ItemStyle.CssClass = "valueGridItem"; bfield.VendorId = Session[Constant.SESSION_USERID].ToString().Trim(); bfield.Editable = false; bfield.Date = false; bfield.Label2 = true; bfield.Label4 = false; bfield.LabelDate = false; break; case "TENDERDATE": //Initialize the HeaderText field value. bfield.HeaderText = "Delivery Date"; bfield.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); bfield.ItemStyle.CssClass = "valueGridItem"; bfield.DataField = "TENDERDATE"; bfield.VendorId = Session[Constant.SESSION_USERID].ToString().Trim(); bfield.Editable = false; bfield.Date = false; bfield.Label2 = false; bfield.Label4 = false; bfield.LabelDate = true; break; case "BIDTENDERNO": //Initialize the HeaderText field value. bfield.HeaderText = col.ColumnName; bfield.Visible = false; bfield.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); bfield.DataField = "BIDTENDERNO"; bfield.Editable = false; bfield.Date = false; break; case "BIDDETAILNO": //Initialize the HeaderText field value. bfield.HeaderText = col.ColumnName; bfield.Visible = false; bfield.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); bfield.DataField = "BIDDETAILNO"; bfield.Editable = false; bfield.Date = false; break; } //Add the newly created bound field to the GridView. gvBids.Columns.Add(bfield); } gvBids.DataSource = dt; gvBids.DataBind(); }