public bool DeleteData(MAS_PROJECTITEMBIDDING data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
bool bRet = false;
try
{
string strQuery = " DELETE FROM [dbo].[tb_mas_ProjectITemBidding] WHERE [ProjectItemNo] = @ProjectItemNo";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@ProjectItemNo", data.ProjectItemNo);
command.ExecuteNonQuery();
bRet = true;
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(bRet);
}
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);
}
public bool DeleteMasProjItemBidding(MAS_PROJECTITEMBIDDING data)
{
IDbConnection conn = null;
bool ret = false;
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
Mas_ProjectITemBiddingBL bl = new Mas_ProjectITemBiddingBL(conn);
ret = bl.DeleteData(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);
}
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);
}
}
public List <MAS_PROJECTITEMBIDDING> ListInfBiddingDetails(string BiddingNo)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
List <MAS_PROJECTITEMBIDDING> lRetData = new List <MAS_PROJECTITEMBIDDING>();
try
{
string strQuery = "SELECT * FROM tb_inf_BiddingDetails WHERE BiddingsNo=@BiddingsNo";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@BiddingsNo", BiddingNo);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
MAS_PROJECTITEMBIDDING retData = new MAS_PROJECTITEMBIDDING();
if (!DBNull.Value.Equals(reader["ItemColumn1"]))
{
retData.ItemColumn1 = (string)reader["ItemColumn1"];
}
if (!DBNull.Value.Equals(reader["ItemColumn2"]))
{
retData.ItemColumn2 = (string)reader["ItemColumn2"];
}
if (!DBNull.Value.Equals(reader["ItemColumn3"]))
{
retData.ItemColumn3 = (string)reader["ItemColumn3"];
}
if (!DBNull.Value.Equals(reader["ItemColumn4"]))
{
retData.ItemColumn4 = (string)reader["ItemColumn4"];
}
if (!DBNull.Value.Equals(reader["ItemColumn5"]))
{
retData.ItemColumn5 = (string)reader["ItemColumn5"];
}
if (!DBNull.Value.Equals(reader["ItemColumn6"]))
{
retData.ItemColumn6 = (string)reader["ItemColumn6"];
}
if (!DBNull.Value.Equals(reader["ItemColumn7"]))
{
retData.ItemColumn7 = (string)reader["ItemColumn7"];
}
if (!DBNull.Value.Equals(reader["ItemColumn8"]))
{
retData.ItemColumn8 = (string)reader["ItemColumn8"];
}
lRetData.Add(retData);
}
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(lRetData);
}
public List <MAS_PROJECTITEMBIDDING> ListDataByProjectNo(MAS_PROJECTITEMBIDDING data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
List <MAS_PROJECTITEMBIDDING> lRetData = new List <MAS_PROJECTITEMBIDDING>();
try
{
string strQuery = "SELECT * FROM [dbo].[tb_mas_ProjectITemBidding] WHERE [ProjectNo] = @ProjectNo ORDER BY [ItemColumn1] ASC ";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@ProjectNo", data.ProjectNo);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
MAS_PROJECTITEMBIDDING retData = new MAS_PROJECTITEMBIDDING();
if (!DBNull.Value.Equals(reader["ProjectItemNo"]))
{
retData.ProjectItemNo = (Int64)reader["ProjectItemNo"];
}
if (!DBNull.Value.Equals(reader["ProjectNo"]))
{
retData.ProjectNo = reader["ProjectNo"].ToString();
}
if (!DBNull.Value.Equals(reader["ItemColumn1"]))
{
retData.ItemColumn1 = (string)reader["ItemColumn1"];
}
if (!DBNull.Value.Equals(reader["ItemColumn2"]))
{
retData.ItemColumn2 = (string)reader["ItemColumn2"];
}
if (!DBNull.Value.Equals(reader["ItemColumn3"]))
{
retData.ItemColumn3 = (string)reader["ItemColumn3"];
}
if (!DBNull.Value.Equals(reader["ItemColumn4"]))
{
retData.ItemColumn4 = (string)reader["ItemColumn4"];
}
if (!DBNull.Value.Equals(reader["ItemColumn5"]))
{
retData.ItemColumn5 = (string)reader["ItemColumn5"];
}
if (!DBNull.Value.Equals(reader["ItemColumn6"]))
{
retData.ItemColumn6 = (string)reader["ItemColumn6"];
}
if (!DBNull.Value.Equals(reader["ItemColumn7"]))
{
retData.ItemColumn7 = (string)reader["ItemColumn7"];
}
if (!DBNull.Value.Equals(reader["ItemColumn8"]))
{
retData.ItemColumn8 = (string)reader["ItemColumn8"];
}
lRetData.Add(retData);
}
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(lRetData);
}
public bool InsertData(MAS_PROJECTITEMBIDDING data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
bool bRet = false;
try
{
string strQuery = "INSERT INTO [dbo].[tb_mas_ProjectITemBidding] " +
"([ProjectNo] " +
",[ItemColumn1] " +
",[ItemColumn2] " +
",[ItemColumn3] " +
",[ItemColumn4] " +
",[ItemColumn5] " +
",[ItemColumn6] " +
",[ItemColumn7] " +
",[ItemColumn8] " +
",[CreatedBy] " +
",[CreatedDate] " +
",[UpdatedBy] " +
",[UpdatedDate]) " +
"VALUES " +
"(@ProjectNo " +
",@ItemColumn1 " +
",@ItemColumn2 " +
",@ItemColumn3 " +
",@ItemColumn4 " +
",@ItemColumn5 " +
",@ItemColumn6 " +
",@ItemColumn7 " +
",@ItemColumn8 " +
",@CreatedBy " +
",@CreatedDate " +
",@UpdatedBy " +
",@UpdatedDate)";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Transaction = _tran;
command.Parameters.AddWithValue("@ProjectNo", Convert.ToInt64(data.ProjectNo));
command.Parameters.AddWithValue("@ItemColumn1", string.IsNullOrWhiteSpace(data.ItemColumn1) ? "" : data.ItemColumn1);
command.Parameters.AddWithValue("@ItemColumn2", string.IsNullOrWhiteSpace(data.ItemColumn2) ? "" : data.ItemColumn2);
command.Parameters.AddWithValue("@ItemColumn3", string.IsNullOrWhiteSpace(data.ItemColumn3) ? "" : data.ItemColumn3);
command.Parameters.AddWithValue("@ItemColumn4", string.IsNullOrWhiteSpace(data.ItemColumn4) ? "" : data.ItemColumn4);
command.Parameters.AddWithValue("@ItemColumn5", string.IsNullOrWhiteSpace(data.ItemColumn5) ? "" : data.ItemColumn5);
command.Parameters.AddWithValue("@ItemColumn6", string.IsNullOrWhiteSpace(data.ItemColumn6) ? "" : data.ItemColumn6);
command.Parameters.AddWithValue("@ItemColumn7", string.IsNullOrWhiteSpace(data.ItemColumn7) ? "" : data.ItemColumn7);
command.Parameters.AddWithValue("@ItemColumn8", string.IsNullOrWhiteSpace(data.ItemColumn8) ? "" : data.ItemColumn8);
command.Parameters.AddWithValue("@CreatedBy", string.IsNullOrWhiteSpace(data.CreatedBy) ? "" : data.CreatedBy);
if (!string.IsNullOrEmpty(data.CreatedDate.ToString()))
{
DateTime dtNew = (DateTime)data.CreatedDate;
string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss");
command.Parameters.AddWithValue("@CreatedDate", dateString);
}
else
{
command.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
}
command.Parameters.AddWithValue("@UpdatedBy", string.IsNullOrWhiteSpace(data.UpdatedBy) ? "" : data.UpdatedBy);
if (!string.IsNullOrEmpty(data.UpdatedDate.ToString()))
{
DateTime dtNew = (DateTime)data.UpdatedDate;
string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss");
command.Parameters.AddWithValue("@UpdatedDate", dateString);
}
else
{
command.Parameters.AddWithValue("@UpdatedDate", DateTime.Now);
}
if (command.ExecuteNonQuery() == 1)
{
bRet = true;
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
throw sqlEx;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
throw ex;
}
return(bRet);
}
public bool UpdateData(MAS_PROJECTITEMBIDDING data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
bool bRet = false;
try
{
string strQuery = "UPDATE [dbo].[tb_mas_ProjectITemBidding] " +
"SET [ProjectNo] = @ProjectNo " +
",[ItemColumn1] = @ItemColumn1 " +
",[ItemColumn2] = @ItemColumn2 " +
",[ItemColumn3] = @ItemColumn3 " +
",[ItemColumn4] = @ItemColumn4 " +
",[ItemColumn5] = @ItemColumn5 " +
",[ItemColumn6] = @ItemColumn6 " +
",[ItemColumn7] = @ItemColumn7 " +
",[ItemColumn8] = @ItemColumn8 " +
",[CreatedBy] = @CreatedBy " +
",[CreatedDate] = @CreatedDate " +
",[UpdatedBy] = @UpdatedBy " +
",[UpdatedDate] = @UpdatedDate " +
"WHERE ProjectItemNo = @ProjectItemNo";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@ProjectItemNo", string.IsNullOrWhiteSpace(data.ProjectNo) ? null : data.ProjectNo);
command.Parameters.AddWithValue("@ItemColumn1", string.IsNullOrWhiteSpace(data.ItemColumn1) ? null : data.ItemColumn1);
command.Parameters.AddWithValue("@ItemColumn2", string.IsNullOrWhiteSpace(data.ItemColumn2) ? null : data.ItemColumn2);
command.Parameters.AddWithValue("@ItemColumn3", string.IsNullOrWhiteSpace(data.ItemColumn3) ? null : data.ItemColumn3);
command.Parameters.AddWithValue("@ItemColumn4", string.IsNullOrWhiteSpace(data.ItemColumn4) ? null : data.ItemColumn4);
command.Parameters.AddWithValue("@ItemColumn5", string.IsNullOrWhiteSpace(data.ItemColumn5) ? null : data.ItemColumn5);
command.Parameters.AddWithValue("@ItemColumn6", string.IsNullOrWhiteSpace(data.ItemColumn6) ? null : data.ItemColumn6);
command.Parameters.AddWithValue("@ItemColumn7", string.IsNullOrWhiteSpace(data.ItemColumn7) ? null : data.ItemColumn7);
command.Parameters.AddWithValue("@ItemColumn8", string.IsNullOrWhiteSpace(data.ItemColumn8) ? null : data.ItemColumn8);
command.Parameters.AddWithValue("@CreatedBy", string.IsNullOrWhiteSpace(data.CreatedBy) ? null : data.CreatedBy);
if (!string.IsNullOrEmpty(data.CreatedDate.ToString()))
{
DateTime dtNew = (DateTime)data.CreatedDate;
string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss");
command.Parameters.AddWithValue("@CreatedDate", dateString);
}
else
{
command.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
}
command.Parameters.AddWithValue("@UpdatedBy", string.IsNullOrWhiteSpace(data.UpdatedBy) ? null : data.UpdatedBy);
if (!string.IsNullOrEmpty(data.UpdatedDate.ToString()))
{
DateTime dtNew = (DateTime)data.UpdatedDate;
string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss");
command.Parameters.AddWithValue("@UpdatedDate", dateString);
}
else
{
command.Parameters.AddWithValue("@UpdatedDate", DateTime.Now);
}
command.Parameters.AddWithValue("@ProjectItemNo", data.ProjectItemNo);
if (command.ExecuteNonQuery() == 1)
{
bRet = true;
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(bRet);
}
protected void gvListItem_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
List <MAS_PROJECTITEMBIDDING> lRet = new List <MAS_PROJECTITEMBIDDING>();
lRet = (List <MAS_PROJECTITEMBIDDING>)ViewState["AddNewItem"];
if (e.CommandName.Equals("AddNew"))
{
MAS_PROJECTITEMBIDDING addItem = new MAS_PROJECTITEMBIDDING();
DropDownList ddlCompany = (DropDownList)gvListItem.FooterRow.FindControl("ddlCompany");
if (ddlCompany != null)
{
addItem.ItemColumn1 = ddlCompany.SelectedItem.Text;
}
TextBox TxtDetail = (TextBox)gvListItem.FooterRow.FindControl("TxtDetail");
if (TxtDetail != null)
{
addItem.ItemColumn2 = TxtDetail.Text;
}
TextBox TxtColumn2 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn2");
if (TxtColumn2 != null)
{
addItem.ItemColumn3 = TxtColumn2.Text;
}
TextBox TxtColumn3 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn3");
if (TxtColumn3 != null)
{
addItem.ItemColumn4 = TxtColumn3.Text;
}
TextBox TxtColumn4 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn4");
if (TxtColumn4 != null)
{
addItem.ItemColumn5 = TxtColumn4.Text;
}
TextBox TxtColumn5 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn5");
if (TxtColumn5 != null)
{
addItem.ItemColumn6 = TxtColumn5.Text;
}
TextBox TxtColumn6 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn6");
if (TxtColumn6 != null)
{
addItem.ItemColumn7 = TxtColumn6.Text;
}
TextBox TxtColumn7 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn7");
if (TxtColumn7 != null)
{
addItem.ItemColumn8 = TxtColumn7.Text;
}
lRet.Add(addItem);
ViewState["AddNewItem"] = lRet;
}
else if (e.CommandName.Equals("Delete"))
{
GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int RowIndex = gvr.RowIndex;
lRet.RemoveAt(RowIndex);
ViewState["AddNewItem"] = lRet;
}
MAS_TEMPLATECOLNAME vsColName = (MAS_TEMPLATECOLNAME)ViewState["ColNameByPk"];
BindItemProjectData(vsColName);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
