protected void GetPriceDetail() { try { string _biddingNo = hdfBiddingNo.Value; Mas_ProjectITemBidding_Manage manage = new Mas_ProjectITemBidding_Manage(); INF_BIDDINGS data = new INF_BIDDINGS(); data = manage.GetInfBidding(_biddingNo); if (data.BiddingsNo != null) { lblSummaryPrice.Text = Convert.ToDouble(data.BiddingPrice).ToString("#,##0.00"); //lblEstimatedTax.Text = Convert.ToDouble(data.BiddingVat7).ToString("#,##0.00"); hdfCompanyNo.Value = data.CompanyNo.ToString(); //lblTotal.Text = Convert.ToDouble(data.BiddingTotalPrice).ToString("#,##0.00"); GetBiddingCompany(data.CompanyNo.ToString()); } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
protected void BindGvAttachFile() { try { string _biddingNo = hdfBiddingNo.Value; Mas_ProjectITemBidding_Manage manage = new Mas_ProjectITemBidding_Manage(); List <INF_BIDDINGATTACHMENT> lAttach = new List <INF_BIDDINGATTACHMENT>(); lAttach = manage.ListInfBiddingAttachments(_biddingNo); gvAttachFile.DataSource = lAttach; gvAttachFile.DataBind(); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
private List <MAS_PROJECTITEMBIDDING> GetListItemProject() { List <MAS_PROJECTITEMBIDDING> lRet = new List <MAS_PROJECTITEMBIDDING>(); try { Mas_ProjectITemBidding_Manage piManage = new Mas_ProjectITemBidding_Manage(); MAS_PROJECTITEMBIDDING para = new MAS_PROJECTITEMBIDDING(); para.ProjectNo = _projectNo; lRet = piManage.ListMasProjItemBiddingByPNo(para); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lRet); }
private void BindItemProject(string TemplateNo) { try { /******************* Get Column Item Project Name ********/ MAS_TEMPLATECOLNAME value = new MAS_TEMPLATECOLNAME(); Int64 pkItemCol = Int64.Parse(TemplateNo); Mas_TemplateColName_Manage manageCol = new Mas_TemplateColName_Manage(); MAS_TEMPLATECOLNAME para = new MAS_TEMPLATECOLNAME(); para.TemplateNo = pkItemCol; value = manageCol.GetMasTemplateColNameByKey(para); /*******************************************************/ /*************** Gen Table & Gridview Column **********/ DataTable dtColumnName = new DataTable(); dtColumnName = CreateTableItemColumn(value); /******************************************************/ /*************** List Item Project ********************************/ Mas_ProjectITemBidding_Manage projItemBL = new Mas_ProjectITemBidding_Manage(); List <MAS_PROJECTITEMBIDDING> lItemProj = new List <MAS_PROJECTITEMBIDDING>(); MAS_PROJECTITEMBIDDING sData = new MAS_PROJECTITEMBIDDING(); sData.ProjectNo = hdfProjectNo.Value.ToString().Trim(); lItemProj = projItemBL.ListMasProjItemBiddingByPNo(sData); /*****************************************************************/ DataRow row; foreach (MAS_PROJECTITEMBIDDING item in lItemProj) { row = dtColumnName.NewRow(); row["ProjectItemNo"] = item.ProjectItemNo; row["ProjectNo"] = item.ProjectNo; if (row.Table.Columns["ItemColumn1"] != null) { row["ItemColumn1"] = item.ItemColumn1; } if (row.Table.Columns["ItemColumn2"] != null) { row["ItemColumn2"] = item.ItemColumn2; } if (row.Table.Columns["ItemColumn3"] != null) { row["ItemColumn3"] = item.ItemColumn3; } if (row.Table.Columns["ItemColumn4"] != null) { row["ItemColumn4"] = item.ItemColumn4; } if (row.Table.Columns["ItemColumn5"] != null) { row["ItemColumn5"] = item.ItemColumn5; } if (row.Table.Columns["ItemColumn6"] != null) { row["ItemColumn6"] = item.ItemColumn6; } if (row.Table.Columns["ItemColumn7"] != null) { row["ItemColumn7"] = item.ItemColumn7; } if (row.Table.Columns["ItemColumn8"] != null) { row["ItemColumn8"] = item.ItemColumn8; } dtColumnName.Rows.Add(row); } /************ Set Empty Row ************/ if (dtColumnName.Rows.Count == 0) { dtColumnName = SetEmptyRows(dtColumnName); } /***************************************/ gvItem.DataSource = dtColumnName; gvItem.DataBind(); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
private void BindItemProject(string TemplateNo) { try { /******************* Get Column Item Project Name ********/ MAS_TEMPLATECOLNAME value = new MAS_TEMPLATECOLNAME(); Int64 pkItemCol = Int64.Parse(TemplateNo); Mas_TemplateColName_Manage manageCol = new Mas_TemplateColName_Manage(); MAS_TEMPLATECOLNAME para = new MAS_TEMPLATECOLNAME(); para.TemplateNo = pkItemCol; value = manageCol.GetMasTemplateColNameByKey(para); /*******************************************************/ /*************** Gen Table & Gridview Column **********/ DataTable dtColumnName = new DataTable(); dtColumnName = CreateTableItemColumn(value); ViewState["TemplateColName"] = dtColumnName; /******************************************************/ /*************** List Item Project ********************************/ Mas_ProjectITemBidding_Manage projItemBL = new Mas_ProjectITemBidding_Manage(); List <MAS_PROJECTITEMBIDDING> lItemProj = new List <MAS_PROJECTITEMBIDDING>(); string _biddingNo = hdfBiddingNo.Value; lItemProj = projItemBL.ListInfBiddingDetails(_biddingNo); /*****************************************************************/ DataRow row; string strComName = string.Empty; foreach (MAS_PROJECTITEMBIDDING item in lItemProj) { row = dtColumnName.NewRow(); //row["ProjectItemNo"] = item.ProjectItemNo; //row["ProjectNo"] = item.ProjectNo; if (row.Table.Columns["ItemColumn1"] != null) { row["ItemColumn1"] = item.ItemColumn1; } if (row.Table.Columns["ItemColumn2"] != null) { row["ItemColumn2"] = item.ItemColumn2; } if (row.Table.Columns["ItemColumn3"] != null) { row["ItemColumn3"] = item.ItemColumn3; } if (row.Table.Columns["ItemColumn4"] != null) { row["ItemColumn4"] = item.ItemColumn4; } if (row.Table.Columns["ItemColumn5"] != null) { row["ItemColumn5"] = item.ItemColumn5; } if (row.Table.Columns["ItemColumn6"] != null) { row["ItemColumn6"] = item.ItemColumn6; } if (row.Table.Columns["ItemColumn7"] != null) { row["ItemColumn7"] = item.ItemColumn7; } if (row.Table.Columns["ItemColumn8"] != null) { row["ItemColumn8"] = item.ItemColumn8; } strComName = item.ItemColumn1; dtColumnName.Rows.Add(row); } gvItem.DataSource = dtColumnName; gvItem.DataBind(); Session["BiddingDetailRPT"] = dtColumnName; } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserLogin"] == null) { Session.Clear(); Session.Abandon(); ViewState.Clear(); FormsAuthentication.SignOut(); Response.Redirect("~/Account/Login.aspx"); } else { if (!IsPostBack) { GlobalFunction fDecrypt = new GlobalFunction(); string _ProjectNo = Request.QueryString["ProjectNo"]; string _BiddingNo = Request.QueryString["BiddingNo"]; if (string.IsNullOrEmpty(_ProjectNo) || string.IsNullOrEmpty(_BiddingNo)) { Session.Clear(); Session.Abandon(); ViewState.Clear(); FormsAuthentication.SignOut(); Response.Redirect("~/Account/Login.aspx"); } else { hdfProjectNo.Value = fDecrypt.Decrypt(_ProjectNo); hdfBiddingNo.Value = fDecrypt.Decrypt(_BiddingNo); } Session["BiddingDetailRPT"] = null; MAS_COMPANYUSER_DTO retUser = (MAS_COMPANYUSER_DTO)Session["UserLogin"]; if (retUser.RolesNo > 0) { if (retUser.RolesNo == 1) { btnExport.Visible = true; } else { btnExport.Visible = false; //********************* Authen User **********************************// if (!retUser.ProjectNo.ToString().Trim().Equals(hdfProjectNo.Value.Trim())) { Session.Clear(); Session.Abandon(); ViewState.Clear(); FormsAuthentication.SignOut(); Response.Redirect("~/Account/Login.aspx"); } Mas_ProjectITemBidding_Manage manage = new Mas_ProjectITemBidding_Manage(); INF_BIDDINGS bData = new INF_BIDDINGS(); bData = manage.GetInfBidding(hdfBiddingNo.Value.Trim()); if (bData.BiddingsNo == null) { Session.Clear(); Session.Abandon(); ViewState.Clear(); FormsAuthentication.SignOut(); Response.Redirect("~/Account/Login.aspx"); } else { if (bData.CompanyNo != retUser.CompanyNo && bData.ProjectNo != retUser.ProjectNo) { Session.Clear(); Session.Abandon(); ViewState.Clear(); FormsAuthentication.SignOut(); Response.Redirect("~/Account/Login.aspx"); } } //******************************************************// } } ViewState["TemplateNo"] = string.Empty; ViewState["TemplateColName"] = null; GetProjectBidding(); BindGvAttachFile(); GetPriceDetail(); linkViewQuestionaire.Attributes["href"] = "~/Form/ViewQuestionnaire.aspx?ProjectNo=" + fDecrypt.Encrypt(hdfProjectNo.Value.Trim()) + "&CompanyNo=" + fDecrypt.Encrypt(hdfCompanyNo.Value.Trim()); } } }