// Method to add the clients
        public static int AddClient(CompanyModel.Client ObjClient)
        {
            int intResult = 0;

            using (DALHelper dalHelper = new DALHelper())
            {
                dalHelper.OpenConnectionWithTransaction();
                intResult = dalHelper.GetDAL_CompanyDetails(true).AddClient(ObjClient);
                dalHelper.EndConnectionAndCommitTransaction();
            }
            return(intResult);
        }
        // Method to update the clienst
        public static int UpdateClientbyClientID(CompanyModel.Client ObjUpClient)
        {
            int intResult = 0;

            using (DALHelper dalHelper = new DALHelper())
            {
                try
                {
                    dalHelper.OpenConnectionWithTransaction();
                    intResult = dalHelper.GetDAL_CompanyDetails(true).UpdateClientbyClientID(ObjUpClient);
                    dalHelper.EndConnectionAndCommitTransaction();
                }
                catch (Exception)
                {
                    dalHelper.EndConnectionAndRollBackTransaction();
                    throw;
                }
            }
            return(intResult);
        }