private void GetCompanyAddress() { string _companyNo = ConfigurationManager.GetConfiguration().CompanyNo; MAS_COMPANY cData = new MAS_COMPANY(); Mas_Company_Manage manage = new Mas_Company_Manage(); cData = manage.GetMasCompanyByID(_companyNo); txtContactAdd.Text = cData.CompanyAddressTH; }
public MAS_COMPANY GetCompanyByID(string CompanyNo) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); MAS_COMPANY dataRet = new MAS_COMPANY(); try { string strQuery = "SELECT [CompanyNo],[CompanyNameTH],[CompanyNameEN],[CompanyAddressTH] " + "FROM [tb_mas_Company] WHERE [IsActive] = 1 and CompanyNo = @CompanyNo "; SqlCommand command = new SqlCommand(strQuery, _conn); command.Parameters.AddWithValue("@CompanyNo", CompanyNo); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { MAS_COMPANY data = new MAS_COMPANY(); if (!DBNull.Value.Equals(reader["CompanyNo"])) { data.CompanyNo = (Int64)reader["CompanyNo"]; } if (!DBNull.Value.Equals(reader["CompanyNameTH"])) { data.CompanyNameTH = (string)reader["CompanyNameTH"]; } if (!DBNull.Value.Equals(reader["CompanyNameEN"])) { data.CompanyNameEN = (string)reader["CompanyNameEN"]; } if (!DBNull.Value.Equals(reader["CompanyAddressTH"])) { data.CompanyAddressTH = (string)reader["CompanyAddressTH"]; } dataRet = data; } } } catch (SqlException sqlEx) { logger.Error(sqlEx); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(dataRet); }
public List <MAS_COMPANY> ListCompanyName() { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); List <MAS_COMPANY> lRet = new List <MAS_COMPANY>(); try { string strQuery = "SELECT [CompanyNo],[CompanyNameTH],[CompanyNameEN] " + "FROM [tb_mas_Company] WHERE [IsActive] = 1 "; SqlCommand command = new SqlCommand(strQuery, _conn); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { MAS_COMPANY data = new MAS_COMPANY(); if (!DBNull.Value.Equals(reader["CompanyNo"])) { data.CompanyNo = (Int64)reader["CompanyNo"]; } if (!DBNull.Value.Equals(reader["CompanyNameTH"])) { data.CompanyNameTH = (string)reader["CompanyNameTH"]; } if (!DBNull.Value.Equals(reader["CompanyNameEN"])) { data.CompanyNameEN = (string)reader["CompanyNameEN"]; } lRet.Add(data); } } } catch (SqlException sqlEx) { logger.Error(sqlEx); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lRet); }
public MAS_COMPANY GetMasCompanyByID(string CompanyNo) { IDbConnection conn = null; MAS_COMPANY ret = new MAS_COMPANY(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_CompanyBL bl = new Mas_CompanyBL(conn); ret = bl.GetCompanyByID(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); }