private void GetItemTemplateNSetGridview(string TemplateNo)
{
MAS_TEMPLATECOLNAME value = new MAS_TEMPLATECOLNAME();
try
{
Int64 pkItemCol = Int64.Parse(TemplateNo);
Mas_TemplateColName_Manage manage = new Mas_TemplateColName_Manage();
MAS_TEMPLATECOLNAME para = new MAS_TEMPLATECOLNAME();
para.TemplateNo = pkItemCol;
value = manage.GetMasTemplateColNameByKey(para);
ViewState["ColNameByPk"] = value;
if (value != null && !string.IsNullOrWhiteSpace(value.TemplateNo.ToString()))
{
BindItemProjectData(value);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialDropDownList()
{
List <MAS_TEMPLATECOLNAME> lData = new List <MAS_TEMPLATECOLNAME>();
Mas_TemplateColName_Manage manage = new Mas_TemplateColName_Manage();
lData = manage.ListMasTemplateName();
ddlItemTemplate.DataSource = lData;
ddlItemTemplate.DataBind();
ddlItemTemplate.Items.Insert(0, new ListItem("== เลือกรายการ Template ==", "0"));
}
private List <MAS_TEMPLATECOLNAME> GetTemplateProject()
{
List <MAS_TEMPLATECOLNAME> ret = new List <MAS_TEMPLATECOLNAME>();
try
{
Mas_TemplateColName_Manage manage = new Mas_TemplateColName_Manage();
ret = manage.ListMasTemplateColName();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(ret);
}
protected void gvListTemplate_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string pk = gvListTemplate.DataKeys[e.RowIndex].Value.ToString().Trim();
MAS_TEMPLATECOLNAME data = new MAS_TEMPLATECOLNAME();
data.TemplateNo = Int64.Parse(pk);
Mas_TemplateColName_Manage manage = new Mas_TemplateColName_Manage();
bool bDel = manage.DeleteMasTemplateColName(data);
if (bDel)
{
InitialControl();
}
else
{
MessageUtil util = new MessageUtil();
util.MsgBox("ไม่สามารถลบข้อมูลได้!", this.Page, this);
}
}
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);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
DataTable dt = (DataTable)Session["tbColumnName"];
if (dt != null && dt.Rows.Count > 0)
{
//=== Sort Column Grid ===== //
DataTable dtSort = null;
dt.DefaultView.Sort = "ColumnNo asc";
dtSort = dt.DefaultView.ToTable();
//===========================//
MAS_TEMPLATECOLNAME data = new MAS_TEMPLATECOLNAME();
data.TemplateName = txtProjectName.Text.Trim();
data.ColumnName1 = dtSort.Rows.Count > 0 ? dtSort.Rows[0]["ColumnName"].ToString().Trim() : "";
data.ColumnName2 = dtSort.Rows.Count > 1 ? dtSort.Rows[1]["ColumnName"].ToString().Trim() : "";
data.ColumnName3 = dtSort.Rows.Count > 2 ? dtSort.Rows[2]["ColumnName"].ToString().Trim() : "";
data.ColumnName4 = dtSort.Rows.Count > 3 ? dtSort.Rows[3]["ColumnName"].ToString().Trim() : "";
data.ColumnName5 = dtSort.Rows.Count > 4 ? dtSort.Rows[4]["ColumnName"].ToString().Trim() : "";
data.ColumnName6 = dtSort.Rows.Count > 5 ? dtSort.Rows[5]["ColumnName"].ToString().Trim() : "";
data.ColumnName7 = dtSort.Rows.Count > 6 ? dtSort.Rows[6]["ColumnName"].ToString().Trim() : "";
data.ColumnName8 = dtSort.Rows.Count > 7 ? dtSort.Rows[7]["ColumnName"].ToString().Trim() : "";
data.CreatedBy = "System Admin";
data.CreatedDate = DateTime.Now;
data.UpdatedBy = "System Admin";
data.UpdatedDate = DateTime.Now;
Mas_TemplateColName_Manage ins = new Mas_TemplateColName_Manage();
bool bIns = ins.InsertMasTemplateColName(data);
if (bIns)
{
MessageUtil util = new MessageUtil();
util.MsgBox("บันทึกข้อมูลสำเร็จ", this.Page, this);
Response.Redirect("~/Form/ItemProjectList.aspx");
}
else
{
MessageUtil util = new MessageUtil();
util.MsgBox("เกิดปัญหา ไม่สามารถบันทึกข้อมูลได้!", this.Page, this);
}
}
else
{
MessageUtil util = new MessageUtil();
util.MsgBox("กรุณาระบุข้อมูล ลำดับและชื่อคอลัมน์", this.Page, this);
return;
}
}
else
{
return;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
MessageUtil util = new MessageUtil();
util.MsgBox("เกิดปัญหา ไม่สามารถบันทึกข้อมูลได้!", this.Page, this);
}
}
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);
}
}
