public bool UpdateInfBiddingCompany(MAS_BIDDINGCOMPANY data)
{
IDbConnection conn = null;
bool ret = false;
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn);
ret = bl.UpdateData(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 InsertBiddingCompany(MAS_BIDDINGCOMPANY data)
//{
// IDbConnection conn = null;
// string ret = string.Empty;
// try
// {
// //SET CONNECTION
// conn = ConnectionFactory.GetConnection();
// conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
// //OPEN CONNECTION
// conn.Open();
// Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn);
// ret = bl.InsertData(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;
//}
#endregion
public string RegisterCompany(MAS_BIDDINGCOMPANY companyData, MAS_USERS userData)
{
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_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn, tran);
string _companyNo = string.Empty;
if (companyData.CompanyNo != null)
{
//************* For Update Company Register *************//
_companyNo = companyData.CompanyNo.ToString().Trim();
bool bRet = bl.UpdateData(companyData);
}
else
{
_companyNo = bl.InsertData(companyData);
}
if (!string.IsNullOrWhiteSpace(_companyNo))
{
userData.CompanyNo = Int64.Parse(_companyNo);
/************ Generate UserName *********************/
string _userName = GenUserName(_companyNo);
userData.UserName = _userName;
/****************************************************/
string userNo = bl.InsertUsersData(userData);
if (!string.IsNullOrWhiteSpace(userNo))
{
ret = _companyNo + ";" + _userName;
#region #### Insert Attach (Not Use) ####
/******* Inset table [tb_mas_CompanyAttachment] *******/
//foreach (var item in lCompanyAttach)
//{
// MAS_COMPANYATTACHMENT data = new MAS_COMPANYATTACHMENT();
// data.CompanyNo = Int64.Parse(_companyNo);
// data.AttachFilePath = item.AttachFilePath;
// data.FileName = item.FileName;
// data.Description = item.Description;
// data.CreatedBy = item.CreatedBy;
// data.CreatedDate = item.CreatedDate;
// data.UpdatedBy = item.UpdatedBy;
// data.UpdatedDate = item.UpdatedDate;
// bl.InsertCompanyAttachData(data);
//}
/******************************************************/
#endregion
}
}
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);
}
