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 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();
}
public List <MAS_PROJECTBIDDING> ListALLProject(MAS_PROJECTBIDDING data)
{
IDbConnection conn = null;
List <MAS_PROJECTBIDDING> ret = null;
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
ret = new List <MAS_PROJECTBIDDING>();
Mas_ProjectBiddingBL bl = new Mas_ProjectBiddingBL(conn);
ret = bl.ListAllData(data);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
}
return(ret);
}
public string InsertMasProjtBidding(MAS_PROJECTBIDDING data, List <MAS_PROJECTITEMBIDDING> lItemData)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
IDbConnection conn = null;
IDbTransaction tran = null;
string ret = string.Empty;
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
tran = conn.BeginTransaction(IsolationLevel.Serializable);
Mas_ProjectBiddingBL bidBL = new Mas_ProjectBiddingBL(conn, tran);
Mas_ProjectITemBiddingBL itemBl = new Mas_ProjectITemBiddingBL(conn, tran);
string pkProjectBD = string.Empty;
pkProjectBD = bidBL.InsertData(data);
if (!string.IsNullOrWhiteSpace(pkProjectBD))
{
ret = pkProjectBD;
foreach (MAS_PROJECTITEMBIDDING item in lItemData)
{
MAS_PROJECTITEMBIDDING insItem = new MAS_PROJECTITEMBIDDING();
insItem.ProjectNo = pkProjectBD;
insItem.ItemColumn1 = item.ItemColumn1;
insItem.ItemColumn2 = item.ItemColumn2;
insItem.ItemColumn3 = item.ItemColumn3;
insItem.ItemColumn4 = item.ItemColumn4;
insItem.ItemColumn5 = item.ItemColumn5;
insItem.ItemColumn6 = item.ItemColumn6;
insItem.ItemColumn7 = item.ItemColumn7;
insItem.ItemColumn8 = item.ItemColumn8;
insItem.CreatedBy = data.CreatedBy;
insItem.CreatedDate = DateTime.Now;
insItem.UpdatedBy = data.UpdatedBy;
insItem.UpdatedDate = DateTime.Now;
itemBl.InsertData(insItem);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
ret = string.Empty;
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
finally
{
if (tran != null)
{
tran.Dispose();
}
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
}
return(ret);
}
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);
}
}