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