public bool InsertCompanyAttach(List <MAS_COMPANYATTACHMENT> lData) { 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); /******* Inset table [tb_mas_CompanyAttachment] *******/ foreach (var item in lData) { MAS_COMPANYATTACHMENT data = new MAS_COMPANYATTACHMENT(); data = item; ret = bl.InsertCompanyAttachData(data); } /******************************************************/ } catch (Exception ex) { ret = false; logger.Error(ex.Message); logger.Error(ex.StackTrace); } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } } return(ret); }
public bool IsExistCompany(string TaxID, string ProjectNo) { 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); MAS_BIDDINGCOMPANY retData = new MAS_BIDDINGCOMPANY(); retData = bl.GetCompanyByTaxIDNProjectNo(TaxID, ProjectNo); if (retData != null && retData.CompanyNo > 0) { ret = true; } } 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 MAS_BIDDINGCOMPANY GetCompanyByTaxID(string TaxID) { IDbConnection conn = null; MAS_BIDDINGCOMPANY retData = new MAS_BIDDINGCOMPANY(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn); retData = bl.GetCompanyByTaxID(TaxID); } catch (Exception ex) { retData = null; logger.Error(ex.Message); logger.Error(ex.StackTrace); } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } } return(retData); }
public string GetNextUserName(string DefaultUSerName) { 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.GenUserName(DefaultUSerName); } 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 bool UpdateUserStatus(MAS_USERS userData) { 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.UpdateUserStatus(userData); } 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 MAS_COMPANYUSER_DTO GetUserLogin(string UserName) { IDbConnection conn = null; MAS_COMPANYUSER_DTO ret = new MAS_COMPANYUSER_DTO(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn); ret = bl.GetUserByUserName(UserName); } 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 List <MAS_COMPANYATTACHMENT> GetCompanyUserAttachFile(string CompanyNo) { IDbConnection conn = null; List <MAS_COMPANYATTACHMENT> ret = new List <MAS_COMPANYATTACHMENT>(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn); ret = bl.GetCompanyUserAttachFile(CompanyNo); } 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 List <MAS_COMPANYUSER_DTO> ListCompanyUser(string CompanyName, string TaxID, string UserName, string ProjectName) { IDbConnection conn = null; List <MAS_COMPANYUSER_DTO> ret = new List <MAS_COMPANYUSER_DTO>(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn); ret = bl.ListCompanyUser(CompanyName, TaxID, UserName, ProjectName); } 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 bool UpdateCompanyAttach(List <MAS_COMPANYATTACHMENT> lData, string CompanyNo) { IDbConnection conn = null; IDbTransaction tran = null; bool ret = false; 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); /********** Delete CompanyAttach before Insert **********/ bool retDel = bl.DeleteCompanyAttachData(CompanyNo); /********************************************************/ /******* Inset table [tb_mas_CompanyAttachment] After delete *******/ if (retDel) { foreach (MAS_COMPANYATTACHMENT item in lData) { MAS_COMPANYATTACHMENT data = new MAS_COMPANYATTACHMENT(); data = item; ret = bl.InsertCompanyAttachData(data); } } /******************************************************/ tran.Commit(); } catch (Exception ex) { tran.Rollback(); ret = false; 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); }
//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); }