using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace infoExpediters
{
    public class viewCompanydetails
    {
        public viewCompanydetails()
        {
         //todo:initialisation
        }
        // get all company detail to display in View company details page
        public DataSet ViewDetails(int CompanyId)
        {
            String strCon = ConfigurationSettings.AppSettings["DB_CONNECTION"];

            DataSet ds = new DataSet();
            try
            {
                using (SqlConnection conn = new SqlConnection(strCon))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand("dbo.sp_getcompanyDetails", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@companyId", SqlDbType.Int);
                    cmd.Parameters["@companyId"].Value = CompanyId;
                    cmd.ExecuteNonQuery();
                    SqlDataAdapter da = new SqlDataAdapter();
                    da.SelectCommand = cmd;
                    da.Fill(ds);
                    da.Dispose();
                    conn.Close();
                    conn.Dispose();
                }
                return ds;
            }
            catch (Exception ex)
            {
                throw new ArgumentException(ex.Message);
            }
        }
    }
}