Ejemplo n.º 1
0
        public void ClearFacture()
        {
            FactureModel fm = new FactureModel();

            fm = fm.Get((int)Facture);
            fm.ClearUnclear(true);
        }
Ejemplo n.º 2
0
        public BindableCollection <FactureModel> GetMyUnClearedFacturesWithOldCleared(int id)
        {
            BindableCollection <FactureModel> factures = new BindableCollection <FactureModel>();

            if (this.Id == 0)
            {
                return(null);
            }
            else
            {
                FactureModel fm    = new FactureModel();
                string[]     value = new string[2] {
                    "number", Id.ToString()
                };
                List <KeyValuePair <string, string[]> > Data = new List <KeyValuePair <string, string[]> >
                {
                    new KeyValuePair <string, string[]>("customer_id", value)
                };
                value = new string[2] {
                    "number", "0"
                };
                Data.Add(new KeyValuePair <string, string[]>("cleared", value));
                List <KeyValuePair <string, string[]> > Union = new List <KeyValuePair <string, string[]> >();
                value = new string[2] {
                    "number", id.ToString()
                };
                Union.Add(new KeyValuePair <string, string[]>("id", value));
                DataTable full_table = fm.FindByParameters(Data, Union);
                factures = fm.GiveCollection(full_table);
            }
            return(factures);
        }
Ejemplo n.º 3
0
        public BindableCollection <ReceiptModel> GiveCollection(DataTable cs)
        {
            List <ReceiptModel> output = new List <ReceiptModel>();
            SeasonModel         sm     = new SeasonModel();
            CustomerModel       cm     = new CustomerModel();
            CurrencyModel       cr     = new CurrencyModel();
            FactureModel        fm     = new FactureModel();

            foreach (DataRow row in cs.Rows)
            {
                cm = cm.Get(System.Convert.ToInt32(row[2].ToString()));
                ReceiptModel ctm = new ReceiptModel
                {
                    Id           = System.Convert.ToInt32(row[0].ToString()),
                    Number       = System.Convert.ToInt32(row[1].ToString()),
                    Customer     = cm.Id,
                    CustomerName = cm.Name,
                };
                if (row[3].ToString() != null && row[3].ToString() != string.Empty)
                {
                    sm             = sm.Get(System.Convert.ToInt32(row[3].ToString()));
                    ctm.Season     = sm.Id;
                    ctm.SeasonYear = sm.Year;
                }
                if (row[4].ToString() != null && row[4].ToString() != string.Empty)
                {
                    ctm.Details = row[4].ToString();
                }
                if (row[5].ToString() != null && row[5].ToString() != string.Empty)
                {
                    ctm.Amount = System.Convert.ToDecimal(row[5].ToString());
                    if (row[6].ToString() != null && row[6].ToString() != string.Empty)
                    {
                        cr                 = cr.Get(System.Convert.ToInt32(row[6].ToString()));
                        ctm.Currency       = cr.Id;
                        ctm.CurrencySymbol = cr.Symbol;
                    }
                }
                if (row[7].ToString() != null && row[7].ToString() != string.Empty)
                {
                    ctm.Delivery = System.Convert.ToDateTime(row[7].ToString());
                }
                if (row[8].ToString() != null && row[8].ToString() != string.Empty)
                {
                    fm          = fm.Get(System.Convert.ToInt32(row[8].ToString()));
                    ctm.Facture = fm.Id;
                }
                if (row[9].ToString() != null && row[9].ToString() != string.Empty)
                {
                    ctm.Cheque = row[9].ToString();
                }
                output.Add(ctm);
            }
            return(new BindableCollection <ReceiptModel>(output));
        }
Ejemplo n.º 4
0
        public BindableCollection <FactureModel> GiveCollection(DataTable cs)
        {
            List <FactureModel> output = new List <FactureModel>();
            SeasonModel         sm     = new SeasonModel();
            CustomerModel       cm     = new CustomerModel();

            foreach (DataRow row in cs.Rows)
            {
                cm = cm.Get(System.Convert.ToInt32(row[4].ToString()));
                FactureModel ctm = new FactureModel
                {
                    Id           = System.Convert.ToInt32(row[0].ToString()),
                    Number       = System.Convert.ToInt32(row[1].ToString()),
                    Customer     = cm.Id,
                    CustomerName = cm.Name,
                    Cleared      = System.Convert.ToBoolean(row[6].ToString()),
                };
                if (row[3] != null && row[3].ToString() != "")
                {
                    sm             = sm.Get(System.Convert.ToInt32(row[3].ToString()));
                    ctm.Season     = sm.Id;
                    ctm.SeasonYear = sm.Year;
                }
                if (row[2].ToString() != null && row[2].ToString() != string.Empty)
                {
                    ctm.Name = row[2].ToString();
                }
                ctm.NameNumber = ctm.Name + " - " + ctm.Number;
                if (row[5].ToString() != null && row[5].ToString() != string.Empty)
                {
                    ctm.Delivery = System.Convert.ToDateTime(row[5].ToString());
                }
                try
                {
                    CurrencyModel c = new CurrencyModel();
                    BindableCollection <CurrencyModel> currencies = c.GiveCollection(c.All());
                    if (currencies.Count > 0)
                    {
                        ctm.Amount = (float)ctm.TotalAmount(currencies[0].Id);
                        Currency   = currencies[0].Id;
                        FullAmount = Amount + " " + currencies[0].Symbol;
                    }
                }
                catch (Exception e)
                {
                }
                output.Add(ctm);
            }
            return(new BindableCollection <FactureModel>(output));
        }
Ejemplo n.º 5
0
        /**
         *  Get All factures for this customers if season is null
         *  Get All factures for this customers that have a season if season is -1
         *  Get All factures in specific season for this customers if season.Id is not 0
         *  Get All factures that don't belong to a seson for this customers if season.Id is 0
         */
        public BindableCollection <FactureModel> GetMyFactures(int?season = null)
        {
            BindableCollection <FactureModel> factures = new BindableCollection <FactureModel>();

            if (this.Id == 0)
            {
                return(null);
            }
            else
            {
                FactureModel fm    = new FactureModel();
                string[]     value = new string[2] {
                    "number", Id.ToString()
                };
                List <KeyValuePair <string, string[]> > Data = new List <KeyValuePair <string, string[]> >
                {
                    new KeyValuePair <string, string[]>("customer_id", value)
                };
                if (season != null)
                {
                    switch (season)
                    {
                    case 0:
                        value = new string[2] {
                            "number", "NULL"
                        };
                        break;

                    case -1:
                        value = new string[2] {
                            "number", "NOT-NULL"
                        };
                        break;

                    default:
                        value = new string[2] {
                            "number", season.ToString()
                        };
                        break;
                    }
                    Data.Add(new KeyValuePair <string, string[]>("season_id", value));
                }
                factures = fm.GiveCollection(fm.FindByParameters(Data));
            }
            return(factures);
        }
Ejemplo n.º 6
0
        /**
         * Get Un-Clearerd factures for this customers if season is null
         *  Get Un-Clearerd factures in specific season for this customers if season.Id is not 0
         *  Get Un-Clearerd factures that don't belong to a seson for this customers if season.Id is 0
         */
        public BindableCollection <FactureModel> GetMyUnClearedFactures(int?season = null)
        {
            BindableCollection <FactureModel> factures = new BindableCollection <FactureModel>();

            if (this.Id == 0)
            {
                return(null);
            }
            else
            {
                FactureModel fm    = new FactureModel();
                string[]     value = new string[2] {
                    "number", Id.ToString()
                };
                List <KeyValuePair <string, string[]> > Data = new List <KeyValuePair <string, string[]> >
                {
                    new KeyValuePair <string, string[]>("customer_id", value)
                };
                value = new string[2] {
                    "number", "0"
                };
                Data.Add(new KeyValuePair <string, string[]>("cleared", value));
                if (season != null)
                {
                    if (season != 0)
                    {
                        value = new string[2] {
                            "number", season.ToString()
                        }
                    }
                    ;
                    else
                    {
                        value = new string[2] {
                            "number", "NULL"
                        }
                    };
                    Data.Add(new KeyValuePair <string, string[]>("season_id", value));
                }
                factures = fm.GiveCollection(fm.FindByParameters(Data));
            }
            return(factures);
        }