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