private void GetProjectBidding()
{
Mas_ProjectBidding_Manage bl = new Mas_ProjectBidding_Manage();
MAS_PROJECTBIDDING projData = new MAS_PROJECTBIDDING();
projData.ProjectNo = Int64.Parse(string.IsNullOrWhiteSpace(hdfProjectNo.Value.ToString()) ? "0" : hdfProjectNo.Value.ToString());
//Convert.ToInt64((string)ViewState["ProjectNo"]);
projData = bl.GetMasProjItemBidding(projData);
/**************** Retrieve Data ********************/
hdfProjectNo.Value = projData.ProjectNo.ToString();
lblBiddingCode.Text = projData.BiddingCode;
lblContactName.Text = projData.ContactName;
lblEmail.Text = projData.Email;
lblEndDate.Text = projData.EndDate.ToString(@"dd\/MM\/yyyy");
lblPhoneNo.Text = projData.PhoneNo;
lblProjectName.Text = projData.ProjectName;
lblStartDate.Text = projData.StartDate.ToString(@"dd\/MM\/yyyy");
ViewState["TemplateNo"] = projData.TemplateNo.ToString();
hdfBiddingCode.Value = projData.BiddingCode;
BindItemProject(projData.TemplateNo.ToString());
/***************************************************/
}
private void BindCompanyBidding()
{
try
{
/*************** List Item Project ********************************/
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
List <INF_PROJECTBIDDINGDETAIL_DTO> lItemProj = new List <INF_PROJECTBIDDINGDETAIL_DTO>();
string _projectNo = string.IsNullOrWhiteSpace(hdfProjectNo.Value) ? "0" : hdfProjectNo.Value.ToString();
lItemProj = manage.ListBiddingProjectHistoryDet(_projectNo);
/*****************************************************************/
/********************** For Sort Gridview ************************/
string _sortBy = (string)ViewState["SortGridview"];
switch (_sortBy.Trim())
{
case "CreatedDate":
lItemProj = lItemProj.OrderBy(x => x.CreatedDate).ToList();
break;
case "CreatedDate DESC":
lItemProj = lItemProj.OrderByDescending(x => x.CreatedDate).ToList();
break;
case "CompanyName":
lItemProj = lItemProj.OrderBy(x => x.CompanyName).ToList();
break;
case "CompanyName DESC":
lItemProj = lItemProj.OrderByDescending(x => x.CompanyName).ToList();
break;
case "TaxID":
lItemProj = lItemProj.OrderBy(x => x.TaxID).ToList();
break;
case "TaxID DESC":
lItemProj = lItemProj.OrderByDescending(x => x.TaxID).ToList();
break;
case "BiddingPrice":
lItemProj = lItemProj.OrderBy(x => x.BiddingPrice).ToList();
break;
case "BiddingPrice DESC":
lItemProj = lItemProj.OrderByDescending(x => x.BiddingPrice).ToList();
break;
}
/*****************************************************************/
gvListProject.DataSource = lItemProj;
gvListProject.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetProjectBidding()
{
try
{
Mas_ProjectBidding_Manage bl = new Mas_ProjectBidding_Manage();
MAS_PROJECTBIDDING projData = new MAS_PROJECTBIDDING();
projData.ProjectNo = Int64.Parse(hdfProjectNo.Value.ToString().Trim());
projData = bl.GetMasProjItemBidding(projData);
/**************** Retrieve Data ********************/
lblAddress.Text = projData.CompanyAddress;
lblBiddingCode.Text = projData.BiddingCode;
lblContactName.Text = projData.ContactName;
lblEmail.Text = projData.Email;
lblEndDate.Text = projData.EndDate.ToString(@"dd\/MM\/yyyy");
lblPhoneNo.Text = projData.PhoneNo;
lblProjectName.Text = projData.ProjectName;
lblStartDate.Text = projData.StartDate.ToString(@"dd\/MM\/yyyy");
lblDepartment.Text = projData.DepartmentName.Trim();
ViewState["PathFile"] = projData.AttachFilePath;
SetDownloadAttachFile(projData.AttachFilePath);
/**************** Check End Date *******************/
int _totalDaysStart = (DateTime.Now - projData.StartDate).Days;
if (_totalDaysStart < 0)
{
btnAccept.Visible = false;
btnCancel.Visible = false;
btnBack.Visible = true;
}
else
{
int _totalDays = (projData.EndDate - DateTime.Now).Days;
if (_totalDays < 0)
{
btnAccept.Visible = false;
btnCancel.Visible = false;
btnBack.Visible = true;
}
}
/***************************************************/
BindItemProject(projData.TemplateNo.ToString());
/***************************************************/
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void ListBDProject()
{
List <MAS_PROJECTBIDDING_DTO> lItemRet = new List <MAS_PROJECTBIDDING_DTO>();
MAS_PROJECTBIDDING data = new MAS_PROJECTBIDDING();
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
lItemRet = manage.ListAllProjBidingActive();
ddlBDProject.DataSource = lItemRet;
ddlBDProject.DataBind();
ddlBDProject.Items.Insert(0, new ListItem("== เลือกรายการ ==", "0"));
}
private void BindGridview()
{
try
{
List <MAS_PROJECTBIDDING_DTO> lItemRet = new List <MAS_PROJECTBIDDING_DTO>();
MAS_PROJECTBIDDING data = new MAS_PROJECTBIDDING();
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
string BiddingCode = "";
string ProjectName = "";
string BiddingMonth = "";
string Department = "";
if (ddlSearch.SelectedIndex != 0)
{
switch (ddlSearch.SelectedValue)
{
case "1":
BiddingCode = txtSearch.Text.Trim();
break;
case "2":
ProjectName = txtSearch.Text.Trim();
break;
case "3":
Department = txtSearch.Text.Trim();
break;
}
}
if (ddlSelMonth.SelectedIndex != 0)
{
BiddingMonth = ddlSelMonth.SelectedValue;
}
lItemRet = manage.ListProjectDefault(BiddingCode, ProjectName, BiddingMonth, Department);
gvListProject.DataSource = lItemRet;
gvListProject.DataBind();
Session["ProjectBiddingRPT"] = lItemRet;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetProjectBidding()
{
Mas_ProjectBidding_Manage bl = new Mas_ProjectBidding_Manage();
MAS_PROJECTBIDDING projData = new MAS_PROJECTBIDDING();
projData.ProjectNo = Convert.ToInt64(string.IsNullOrWhiteSpace(hdfProjectNo.Value) ? "0" : hdfProjectNo.Value.ToString());
projData = bl.GetMasProjItemBidding(projData);
/**************** Retrieve Data ********************/
lblBiddingCode.Text = projData.BiddingCode;
lblProjectName.Text = projData.ProjectName;
lblStartDate.Text = projData.StartDate.ToString(@"dd\/MM\/yyyy");
lblEndDate.Text = projData.EndDate.ToString(@"dd\/MM\/yyyy");
//lblContactName.Text = projData.ContactName;
//lblEmail.Text = projData.Email;
//lblPhoneNo.Text = projData.PhoneNo;
/***************************************************/
}
private void GetProjectBidding()
{
Mas_ProjectBidding_Manage bl = new Mas_ProjectBidding_Manage();
MAS_PROJECTBIDDING projData = new MAS_PROJECTBIDDING();
projData.ProjectNo = Int64.Parse(string.IsNullOrWhiteSpace(hdfProjectNo.Value.ToString()) ? "0" : hdfProjectNo.Value.ToString());
projData = bl.GetMasProjItemBidding(projData);
/**************** Retrieve Data ********************/
hdfProjectNo.Value = projData.ProjectNo.ToString();
lblBiddingCode.Text = projData.BiddingCode;
lblProjectName.Text = projData.ProjectName;
ViewState["TemplateNo"] = projData.TemplateNo.ToString();
hdfBiddingCode.Value = projData.BiddingCode;
BindItemProject(projData.TemplateNo.ToString());
/***************************************************/
}
private void BindGridview()
{
List <MAS_PROJECTBIDDING_DTO> lItemRet = new List <MAS_PROJECTBIDDING_DTO>();
MAS_PROJECTBIDDING data = new MAS_PROJECTBIDDING();
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
string BiddingCode = "";
string ProjectName = "";
string BiddingMonth = "";
string UserName = "";
if (hdfRoleNo.Value.Trim().Equals("2"))
{
UserName = hdfUserName.Value.Trim();
}
if (ddlSearch.SelectedIndex != 0)
{
switch (ddlSearch.SelectedValue)
{
case "1":
BiddingCode = txtSearch.Text.Trim();
break;
case "2":
ProjectName = txtSearch.Text.Trim();
break;
}
}
if (ddlSelMonth.SelectedIndex != 0)
{
BiddingMonth = ddlSelMonth.SelectedValue;
}
lItemRet = manage.ListBiddingProject(BiddingCode, ProjectName, BiddingMonth, UserName);
gvListProject.DataSource = lItemRet;
gvListProject.DataBind();
}
private void BindGridview()
{
try
{
string _biddingCode = "";
string _projectName = "";
if (ddlSearch.SelectedIndex != 0)
{
switch (ddlSearch.SelectedValue)
{
case "1":
_biddingCode = txtSearch.Text.Trim();
break;
case "2":
_projectName = txtSearch.Text.Trim();
break;
}
}
List <INF_PROJECTBIDDINGDETAIL_DTO> lItemRet = new List <INF_PROJECTBIDDINGDETAIL_DTO>();
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
string _companyNo = hdfCompanyNo.Value.ToString();
lItemRet = manage.ListBiddingVendorProject(_companyNo, _projectName, _biddingCode);
/********************** For Sort Gridview ************************/
string _sortBy = (string)ViewState["SortGridview"];
switch (_sortBy.Trim())
{
case "BiddingCode":
lItemRet = lItemRet.OrderBy(x => x.BiddingCode).ToList();
break;
case "BiddingCode DESC":
lItemRet = lItemRet.OrderByDescending(x => x.CompanyName).ToList();
break;
case "ProjectName":
lItemRet = lItemRet.OrderBy(x => x.ProjectName).ToList();
break;
case "ProjectName DESC":
lItemRet = lItemRet.OrderByDescending(x => x.ProjectName).ToList();
break;
case "CreatedDate":
lItemRet = lItemRet.OrderBy(x => x.CreatedDate).ToList();
break;
case "CreatedDate DESC":
lItemRet = lItemRet.OrderByDescending(x => x.CreatedDate).ToList();
break;
case "BiddingPrice":
lItemRet = lItemRet.OrderBy(x => x.BiddingPrice).ToList();
break;
case "BiddingPrice DESC":
lItemRet = lItemRet.OrderByDescending(x => x.BiddingPrice).ToList();
break;
}
/*****************************************************************/
gvListProject.DataSource = lItemRet;
gvListProject.DataBind();
Session["VendorBiddingDetailRPT"] = lItemRet;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void BindCompanyBidding()
{
try
{
/*************** List All Company Bidding **************************/
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
List <INF_PROJECTBIDDINGDETAIL_DTO> lItemProj = new List <INF_PROJECTBIDDINGDETAIL_DTO>();
/********************* Criteria search ****************************/
string _companyName = "";
string _taxID = "";
if (ddlSearch.SelectedIndex != 0)
{
switch (ddlSearch.SelectedValue)
{
case "1":
_companyName = txtSearch.Text.Trim();
break;
case "2":
_taxID = txtSearch.Text.Trim();
break;
}
}
/******************************************************************/
lItemProj = manage.ListAllCompanyBiddingHistory(_companyName, _taxID);
/*****************************************************************/
/********************** For Sort Gridview ************************/
string _sortBy = (string)ViewState["SortGridview"];
switch (_sortBy.Trim())
{
case "CompanyName":
lItemProj = lItemProj.OrderBy(x => x.CompanyName).ToList();
break;
case "CompanyName DESC":
lItemProj = lItemProj.OrderByDescending(x => x.CompanyName).ToList();
break;
case "TaxID":
lItemProj = lItemProj.OrderBy(x => x.TaxID).ToList();
break;
case "TaxID DESC":
lItemProj = lItemProj.OrderByDescending(x => x.TaxID).ToList();
break;
}
/*****************************************************************/
gvCompanyBidding.DataSource = lItemProj;
gvCompanyBidding.DataBind();
Session["VendorBiddingHistoryRPT"] = lItemProj;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
logger.Info("btnSave_Click-[Start]");
try
{
if (IsValid)
{
/****************** Insert to tb MAS_PROJECTBIDDING ************************/
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
MAS_PROJECTBIDDING insData = new MAS_PROJECTBIDDING();
insData.ProjectName = txtProjectName.Text.Trim();
insData.TemplateNo = Int64.Parse(ddlItemTemplate.SelectedValue.ToString().Trim());
insData.CompanyAddress = txtContactAdd.Text;
//insData.StartDate = Convert.ToDateTime(txtStartDate.Text.Trim());
//insData.EndDate = Convert.ToDateTime(txtEndDate.Text.Trim());
string format = ConfigurationManager.GetConfiguration().DateFormat;
IFormatProvider culture = new System.Globalization.CultureInfo("en-US", true);
string _startDate = txtStartDate.Text.Trim();
insData.StartDate = DateTime.ParseExact(_startDate, format, culture);
string _endDate = txtEndDate.Text.Trim();
insData.EndDate = DateTime.ParseExact(_endDate, format, culture);
insData.ContactName = txtContactPers.Text.Trim();
insData.Email = txtContactEmail.Text.Trim();
insData.PhoneNo = txtContactPhone.Text.Trim();
insData.CreatedBy = hdfUserName.Value.Trim();
insData.CreatedDate = DateTime.Now;
insData.UpdatedBy = hdfUserName.Value.Trim();
insData.UpdatedDate = DateTime.Now;
//*********** AddBy Preecha J. 2018-10-08***********//
insData.DepartmentName = ddlDepartment.SelectedValue.Trim();
//**************************************************//
List <MAS_PROJECTITEMBIDDING> lItemProj = new List <MAS_PROJECTITEMBIDDING>();
lItemProj = (List <MAS_PROJECTITEMBIDDING>)ViewState["AddNewItem"];
logger.Info("InsertMasProjtBidding-[Start]");
string strBiddNo = manage.InsertMasProjtBidding(insData, lItemProj);
logger.Info("InsertMasProjtBidding-[End]");
if (!string.IsNullOrWhiteSpace(strBiddNo))
{
string strPathFile = ConfigurationManager.GetConfiguration().AttachFilePath;
string strPathDate = DateTime.Now.ToString("ddMMyyyy") + "/";
string bdCode = GenBiddingCode(strBiddNo);
string pathUpload = strPathFile + strPathDate + bdCode + "/";
String ServerMapPath = Server.MapPath(pathUpload);
/******************* Update BiddingCode ****************/
MAS_PROJECTBIDDING updData = new MAS_PROJECTBIDDING();
updData.ProjectNo = Convert.ToInt64(strBiddNo);
updData.BiddingCode = bdCode;
updData.AttachFilePath = pathUpload + fuTOR.FileName;
/*******************************************************/
/***************** Upload File ************************/
if (manage.UpdateBiddingCode(updData))
{
if (!System.IO.Directory.Exists(Server.MapPath(pathUpload)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(pathUpload));
}
fuTOR.PostedFile.SaveAs(ServerMapPath + fuTOR.FileName);
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert",
// "alert('สร้างรายการเรียบร้อย..');window.location ='Default.aspx';", true);
lblMsgResult.Text = "สร้างรายการ จัดซื้อ/จัดจ้าง สำเร็จ";
Session["CreateResult"] = "y";
}
else
{
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
// "alertMessage", "alert('ไม่สามารถบันทึกข้อมูลได้! กรุณาติดต่อผู้ดูแลระบบ')", true);
lblMsgResult.Text = "ไม่สามารถสร้างรายการได้! กรุณาติดต่อผู้ดูแลระบบ";
Session["CreateResult"] = "n";
}
}
/***************************************************************/
lbtnPopup_ModalPopupExtender.Show();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ไม่สามารถบันทึกข้อมูลได้! กรุณาติดต่อผู้ดูแลระบบ')", true);
lblMsgResult.Text = "ไม่สามารถบันทึกข้อมูลได้! กรุณาติดต่อผู้ดูแลระบบ";
Session["CreateResult"] = "n";
lbtnPopup_ModalPopupExtender.Show();
}
logger.Info("btnSave_Click-[End]");
}
private void BindGridview()
{
try
{
List <MAS_PROJECTBIDDING_DTO> lItemRet = new List <MAS_PROJECTBIDDING_DTO>();
MAS_PROJECTBIDDING data = new MAS_PROJECTBIDDING();
Mas_ProjectBidding_Manage manage = new Mas_ProjectBidding_Manage();
string BiddingCode = "";
string ProjectName = "";
string BiddingMonth = "";
string CompanyName = "";
string Username = "";
if (hdfRoleNo.Value.Trim().Equals("2"))
{
Username = hdfUserName.Value.Trim();
}
if (ddlSearch.SelectedIndex != 0)
{
switch (ddlSearch.SelectedValue)
{
case "1":
BiddingCode = txtSearch.Text.Trim();
break;
case "2":
ProjectName = txtSearch.Text.Trim();
break;
case "3":
CompanyName = txtSearch.Text.Trim();
break;
}
}
if (ddlSelMonth.SelectedIndex != 0)
{
BiddingMonth = ddlSelMonth.SelectedValue;
}
lItemRet = manage.ListBiddingProjectHistory(BiddingCode, ProjectName, BiddingMonth, Username, CompanyName);
/********************** For Sort Gridview ************************/
string _sortBy = (string)ViewState["SortGridview_BidingHistory"];
switch (_sortBy.Trim())
{
case "BiddingsNo DESC":
lItemRet = lItemRet.OrderByDescending(x => x.BiddingsNo).ToList();
break;
case "BiddingCode":
lItemRet = lItemRet.OrderBy(x => x.BiddingCode).ToList();
break;
case "BiddingCode DESC":
lItemRet = lItemRet.OrderByDescending(x => x.BiddingCode).ToList();
break;
case "ProjectName":
lItemRet = lItemRet.OrderBy(x => x.ProjectName).ToList();
break;
case "ProjectName DESC":
lItemRet = lItemRet.OrderByDescending(x => x.ProjectName).ToList();
break;
case "EndDate":
lItemRet = lItemRet.OrderBy(x => x.EndDate).ToList();
break;
case "EndDate DESC":
lItemRet = lItemRet.OrderByDescending(x => x.EndDate).ToList();
break;
case "BiddingPrice":
lItemRet = lItemRet.OrderBy(x => x.BiddingPrice).ToList();
break;
case "BiddingPrice DESC":
lItemRet = lItemRet.OrderByDescending(x => x.BiddingPrice).ToList();
break;
case "CompanyName":
lItemRet = lItemRet.OrderBy(x => x.CompanyName).ToList();
break;
case "CompanyName DESC":
lItemRet = lItemRet.OrderByDescending(x => x.CompanyName).ToList();
break;
}
/*****************************************************************/
gvListProject.DataSource = lItemRet;
gvListProject.DataBind();
Session["BidingProjectHistoryRPT"] = lItemRet;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
