public List <CompanyBeans> getAllCompany(string sql, Dictionary <string, string> parameters) { List <CompanyBeans> companyDataSource = new List <CompanyBeans>(); try { DataTable companyResult = new ConnectionManager().select(sql, parameters); for (int i = 0; i < companyResult.Rows.Count; i++) { CompanyBeans compBean = new CompanyBeans(); compBean.id = int.Parse(companyResult.Rows[i]["id"].ToString()); compBean.cmp_code = companyResult.Rows[i]["cmp_code"].ToString(); compBean.cmp_nme = companyResult.Rows[i]["cmp_nme"].ToString(); compBean.cmp_lng_nme = companyResult.Rows[i]["cmp_lng_nme"].ToString(); compBean.address = companyResult.Rows[i]["address"].ToString(); compBean.telephone = companyResult.Rows[i]["telephone"].ToString(); compBean.mobile = companyResult.Rows[i]["mobile"].ToString(); companyDataSource.Add(compBean); } } catch (Exception ex) { myLog.Error(ex); } return(companyDataSource); }
public CompanyBeans getCompanyByID(int id) { CompanyBeans companyDataSource = new CompanyBeans(); try { string sql = " select * from pos.tcompany where id=@ID"; Dictionary <string, string> parameter = new Dictionary <string, string>(); parameter.Add("@ID", id + ""); List <CompanyBeans> result = getAllCompany(sql, parameter); companyDataSource = result[0]; } catch (Exception ex) { myLog.Error(ex); } return(companyDataSource); }