//Edit (Get)
        public POCO.CompanyInfo D_CompanyInfoGetToUpdate(decimal ID)
        {
            ds       = new DataSet();
            oCompany = new POCO.CompanyInfo();
            ds       = ocompanyInfoDAL.D_CompanyInfoGetToUpdate(ID);

            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    oCompany.ID            = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
                    oCompany.CompanyID     = Convert.ToInt32(ds.Tables[0].Rows[0]["CompanyID"]);
                    oCompany.CompanyNameAr = ds.Tables[0].Rows[0]["CompanyNameAr"].ToString();
                    oCompany.CompanyNameEn = ds.Tables[0].Rows[0]["CompanyNameEn"].ToString();
                    oCompany.Address       = ds.Tables[0].Rows[0]["Address"].ToString();
                    oCompany.Fax           = ds.Tables[0].Rows[0]["Fax"].ToString();
                    oCompany.Phone         = ds.Tables[0].Rows[0]["Phone"].ToString();
                    oCompany.FooterLine1   = ds.Tables[0].Rows[0]["FooterLine1"].ToString();
                    oCompany.FooterLine2   = ds.Tables[0].Rows[0]["FooterLine2"].ToString();
                    oCompany.Img           = (byte[])ds.Tables[0].Rows[0]["Img"];
                }
            }

            return(oCompany);
        }