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();
}
