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