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