public static List <ENTVWFRMFIRM> GetAllListFirms() { con = SQL.GetConnection(); cmd = SQL.SetCommand("SELECT * FROM VW_FRM_Firm ORDER BY NAME", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ENTVWFRMFIRM firm = null; List <ENTVWFRMFIRM> firmList = new List <ENTVWFRMFIRM>(); while (dr.Read()) { firm = new ENTVWFRMFIRM(Guid.Parse(dr["ID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Convert.ToByte(dr["CITYID"].ToString()), Convert.ToInt16(dr["DISTRICTID"].ToString()), dr["ADDRESS"].ToString(), dr["FIRMCITYNAME"].ToString(), dr["FIRMDISTRICTNAME"].ToString()); firmList.Add(firm); } con.Close(); return(firmList); }
public static ENTVWFRMFIRM GetFirmInfo(Guid ID) { con = SQL.GetConnection(); cmd = SQL.SetCommand("SELECT * FROM VW_FRM_Firm WHERE ID=@ID", con); cmd.Parameters.AddWithValue("@ID", ID); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ENTVWFRMFIRM firm = null; while (dr.Read()) { firm = new ENTVWFRMFIRM(Guid.Parse(dr["ID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Convert.ToByte(dr["CITYID"].ToString()), Convert.ToInt16(dr["DISTRICTID"].ToString()), dr["ADDRESS"].ToString(), dr["FIRMCITYNAME"].ToString(), dr["FIRMDISTRICTNAME"].ToString()); break; } con.Close(); return(firm); }