コード例 #1
0
        public static List <Organization> GetOrganizationsByUser(string whereClause)
        {
            List <Organization> theList = new List <Organization>();
            Organization        theData = null;

            string userName = HttpContext.Current.User.Identity.Name;

            try
            {
                OrganizationTableAdapter             localAdapter = new OrganizationTableAdapter();
                OrganizationDS.OrganizationDataTable theTable     = localAdapter.GetOrganizationsByUser(userName, whereClause);

                if (theTable != null && theTable.Rows.Count > 0)
                {
                    foreach (OrganizationDS.OrganizationRow theRow in theTable)
                    {
                        theData         = FillRecord(theRow);
                        theData.IsOwner = theRow.isOwner;
                        theList.Add(theData);
                    }
                }
            }
            catch (Exception exc)
            {
                log.Error(Resources.Organization.MessageOrganizationList + whereClause, exc);
                throw new Exception(Resources.Organization.MessageOrganizationList);
            }

            return(theList);
        }
コード例 #2
0
        public static List <Organization> GetOrganizationsForAutocomplete(string filter)
        {
            string userName = HttpContext.Current.User.Identity.Name;

            List <Organization> theList = new List <Organization>();
            Organization        theData = null;

            try
            {
                OrganizationTableAdapter             localAdapter = new OrganizationTableAdapter();
                OrganizationDS.OrganizationDataTable theTable     = localAdapter.GetOrganizationsForAutocomplete(userName, filter);
                if (theTable != null && theTable.Rows.Count > 0)
                {
                    foreach (OrganizationDS.OrganizationRow theRow in theTable)
                    {
                        theData = FillRecord(theRow);
                        theList.Add(theData);
                    }
                }
            }
            catch (Exception exc)
            {
                log.Error("Error al obtener una organizacion for autocomplete.", exc);
                throw new Exception(Resources.Organization.MessageErrorObtainOrganization);
            }
            return(theList);
        }
コード例 #3
0
        public static Organization GetOrganizationById(int organizationId)
        {
            if (organizationId <= 0)
            {
                throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
            }

            Organization theData = null;

            try
            {
                OrganizationTableAdapter             localAdapter = new OrganizationTableAdapter();
                OrganizationDS.OrganizationDataTable theTable     = localAdapter.GetOrganizationById(organizationId);

                if (theTable != null && theTable.Rows.Count > 0)
                {
                    OrganizationDS.OrganizationRow theRow = theTable[0];
                    theData = FillRecord(theRow);
                }
            }
            catch (Exception exc)
            {
                log.Error("Ocurrió un error mientras se obtenía la organización de id =" + organizationId.ToString(), exc);
                throw new Exception(Resources.Organization.MessageErrorObtainOrganization);
            }

            return(theData);
        }
コード例 #4
0
        public static int InsertOrganization(string name)
        {
            if (string.IsNullOrEmpty(name))
            {
                throw new ArgumentException(Resources.Organization.MessageEmptyName);
            }

            OrganizationTableAdapter localAdapter = new OrganizationTableAdapter();

            int?   organizacionId = 0;
            string userName       = HttpContext.Current.User.Identity.Name;

            try
            {
                localAdapter.InsertOrganization(userName, name, ref organizacionId);
            }
            catch (Exception exc)
            {
                log.Error(Resources.Organization.MessageErrorCreate, exc);
                throw exc;
            }

            if ((int)organizacionId <= 0)
            {
                log.Error(Resources.Organization.MessageErrorCreate);
                throw new ArgumentException(Resources.Organization.MessageErrorCreate);
            }

            return((int)organizacionId);
        }
コード例 #5
0
ファイル: StockForm.cs プロジェクト: AlexNoBadMan/Stock
 private void Form1_Load(object sender, EventArgs e)
 {
     BalanceTableAdapter.Fill(stockDataSet.Остатки);
     TaxingTableAdapter.Fill(stockDataSet.Таксировка);
     TaxTableAdapter.Fill(stockDataSet.Налоги);
     BankTableAdapter.Fill(stockDataSet.Банк);
     OrganizationTableAdapter.Fill(stockDataSet.Организация);
     InvoiceTableAdapter.Fill(stockDataSet.Накладные);
     MoveProductTableAdapter.Fill(stockDataSet.Движение_товара);
     DivisionsTableAdapter.Fill(stockDataSet.Подразделения);
     ProductTableAdapter.Fill(stockDataSet.Товар);
     CategoryTableAdapter.Fill(stockDataSet.Категории_товара);
 }
コード例 #6
0
        public static void DeletePermanently(int organizationId)
        {
            OrganizationTableAdapter adapter = new OrganizationTableAdapter();

            try
            {
                adapter.DeletePermanentlyOrganization(organizationId);
            }
            catch (Exception ex)
            {
                log.Error(Resources.Organization.MessageErrorDelete, ex);
                throw new Exception(Resources.Organization.MessageErrorDelete);
            }
        }
コード例 #7
0
        public static void DeleteOrganization(int organizationId)
        {
            if (organizationId <= 0)
            {
                throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
            }

            OrganizationTableAdapter localAdapter = new OrganizationTableAdapter();
            string userName = HttpContext.Current.User.Identity.Name;

            try
            {
                localAdapter.DeleteOrganization(organizationId, userName);
            }
            catch (Exception exc)
            {
                log.Error(Resources.Organization.MessageErrorDelete, exc);
                throw new Exception(Resources.Organization.MessageErrorDelete);
            }
        }
コード例 #8
0
        public static void UpdateOrganization(int organizationId, string name)
        {
            if (organizationId <= 0)
            {
                throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
            }

            if (string.IsNullOrEmpty(name))
            {
                throw new ArgumentException(Resources.Organization.MessageEmptyName);
            }

            OrganizationTableAdapter localAdapter = new OrganizationTableAdapter();

            try
            {
                localAdapter.UpdateOrganization(organizationId, name);
            }
            catch (Exception exc)
            {
                log.Error(Resources.Organization.MessageErrorUpdate, exc);
                throw exc;
            }
        }