示例#1
0
    public static string DeleteInvoice(int invoiceId)
    {
        clsLst cls = new clsLst();
        cls.iInvoiceId = invoiceId;

        return cls.InsertUpdateDeleteInvoice(cls.TYPE_DELETE);
    }
示例#2
0
    public static string GenerateInvoice(int invoiceId)
    {
        clsLst cls = new clsLst();
        cls.iInvoiceId = invoiceId;

        return cls.InsertUpdateDeleteInvoice(cls.TYPE_APPROVE);
    }
示例#3
0
    public static string deleteInvoiceProduct(int id)
    {
        clsLst lst = new clsLst();
        lst.iDetail_Id = id;

        return  lst.InsertUpdateDeleteProductInvoiceDetail(lst.TYPE_DELETE);
    }
示例#4
0
    public static string ChangeTableInvoice(int tableAdmin, int tableId)
    {
        clsLst cls = new clsLst();
        cls.iTableId = tableId;
        cls.iTableAdmin = tableAdmin;

        return cls.UpdateTableIdToInvoice();
    }
示例#5
0
    public static string DeleteSupplier(int id)
    {
        clsLst lst = new clsLst();
        lst.iSupplierId = id;
        string result = lst.InsertUpdateDeleteSuppliers(lst.TYPE_DELETE);

        return result;
    }
示例#6
0
    public static string DeleteProduct(int id)
    {
        clsLst lst = new clsLst();
        lst.iProductId = id;
        string result = lst.InsertUpdateDeleteProducts(lst.TYPE_DELETE);

        return result;
    }
    public static string CancelEntry(int id)
    {
        clsLst lst = new clsLst();
         lst.iEntryId = id;
         string result = lst.InsertUpdateDeleteProductEntry(lst.TYPE_DELETE,"","","","","");

         return result;
    }
    public static string approveEntry(int id)
    {
        clsLst lst = new clsLst();
         lst.iEntryId = id;
         string result = lst.InsertUpdateDeleteProductEntry(lst.TYPE_APPROVE, "", "", "", "","");

         return result;
    }
示例#9
0
 public static string GetGridDataDetail(string xWaiter)
 {
     clsLst lst = new clsLst();
     ClsData data = new ClsData();
     System.Data.DataTable dt = new System.Data.DataTable("data");
     dt = lst.fgetWaiterDetail(xWaiter);
     return data.fGetJson(dt);
 }
示例#10
0
 public static string addInvoice(int tableid, int invoiceno, string description, int waiters, string user)
 {
     clsLst lst = new clsLst();
     lst.iTableId = tableid;
     lst.iNumber_Invoice = invoiceno;
     lst.sDescription = description;
     lst.iWaiterId = waiters;
     lst.sUser = user;
     return lst.InsertUpdateDeleteInvoice(lst.TYPE_INSERT);
 }
示例#11
0
    public static string addInvoiceDetail(int invoice,int productid,int  quantity, decimal price, string user)
    {
        clsLst lst = new clsLst();
        lst.iInvoiceId = invoice;
        lst.iProductId = productid;
        lst.iQuantity = quantity;
        lst.dPrice = price;
        lst.sUser = user;

        return lst.InsertUpdateDeleteProductInvoiceDetail(lst.TYPE_INSERT);
    }
示例#12
0
    public static String save(int type,int tableid, string descripcion, int status)
    {
        clsLst cls = new clsLst();

        string result = "";

        cls.iTableId = tableid;
        cls.sDescription = descripcion;
        cls.iStatus = status;

        result = cls.InsertUpdateTables(type);

        return result;
    }
    public static string getProductFind(string reference)
    {
        clsLst lst = new clsLst();
        ClsData data = new ClsData();

        if (lst.findProductByReference(reference).Rows.Count <= 0)
        {
            return "error";
        }
        else
        {
            return data.fGetJson(lst.findProductByReference(reference));
        }
    }
示例#14
0
    public static string CrudProducts(int id, string description, string reference, string barcode, decimal price, int category, int supplier, string userName, int type)
    {
        clsLst lst = new clsLst();
        lst.iProductId = id;
        lst.sDescription = description;
        lst.sReference = reference;
        lst.sBarcode = barcode;
        lst.dPrice = price;
        lst.iCategoryId = category;
        lst.iSupplierId = supplier;
        lst.sUser = userName;

        string result = lst.InsertUpdateDeleteProducts(type);

        return result;
    }
示例#15
0
    public static string CrudSupplier(int id, string name, int typeid, string contact1, string tel1, string contact2, string tel2, int type, string user, int pay)
    {
        clsLst lst = new clsLst();
        lst.iSupplierId = id;
        lst.sname = name;
        lst.iSupplierType = typeid;
        lst.iSupplierPay = pay;
        lst.scontact1 = contact1;
        lst.stel1 = tel1;
        lst.scontact2 = contact2;
        lst.stel2 = tel2;
        lst.sUser = user;
        ClsData data = new ClsData();

        string result = lst.InsertUpdateDeleteSuppliers(type);

        return result;
    }
示例#16
0
    private void loadTC(int year, int month)
    {
        try
        {
            Tipo_Cambio_BCNSoapClient objServ = new Tipo_Cambio_BCNSoapClient();
            XmlElement objElement;
            XmlNodeList xmlNodLista;
            DataTable dt = new DataTable();

            //CONSUMIMOS EL SERVICIO
            objElement = objServ.RecuperaTC_Mes(year, month);
            xmlNodLista = objElement.GetElementsByTagName("Tc");

            //AGREGAMOS LAS COLUMNAS AL DATATABLE
            foreach (XmlNode node in xmlNodLista.Item(0).ChildNodes)
            {
                DataColumn col = new DataColumn(node.Name, System.Type.GetType("System.String"));
                dt.Columns.Add(col);
            }

            //AGREGAR LA INFORMACION AL DATATABLE
            for (int i = 0; i < xmlNodLista.Count; i++)
            {
                DataRow dr = dt.NewRow();
            }

            for (int IntVal = 0; IntVal <= xmlNodLista.Count - 1; IntVal++)
            {
                DataRow dr = dt.NewRow();
                for (int Col = 0; Col <= dt.Columns.Count - 1; Col++)
                {
                    if (xmlNodLista.Item(IntVal).ChildNodes[Col].InnerText != null)
                        dr[Col] = xmlNodLista.Item(IntVal).ChildNodes[Col].InnerText;
                    else
                        dr[Col] = null;
                }
                dt.Rows.Add(dr);
            }
            clsLst cls = new clsLst();
            cls.createTC(dt);

        }
        catch (Exception ex) { }
    }
示例#17
0
 public static String GetTables()
 {
     clsLst clsFront = new clsLst();
     ClsData DataJSon = new ClsData();
     return DataJSon.fGetJson(clsFront.GetTables());
 }
示例#18
0
 public static string getCountInvoicesByTableId(int tableid)
 {
     clsLst lst = new clsLst();
     ClsData data = new ClsData();
     return lst.getCountInvoicesByTableId(tableid).ToString();
 }
示例#19
0
 public static string makeCloseDay()
 {
     clsLst lst = new clsLst();
     return lst.closeDay();
 }
示例#20
0
 public static string getcomboSupplier()
 {
     clsLst lst = new clsLst();
     ClsData data = new ClsData();
     return data.fGetJson(lst.comboSupplier());
 }
示例#21
0
 public static string GetTableAviables(int tableid)
 {
     clsLst clsFront = new clsLst();
     ClsData DataJSon = new ClsData();
     return DataJSon.fGetJson(clsFront.getTablesAviables(tableid));
 }
示例#22
0
 public static string getTableNo(int invoiceId)
 {
     clsLst lst = new clsLst();
     return lst.GetNumberTableByInvoiceId(invoiceId).ToString();
 }
示例#23
0
 public static string getWaiterIdInvoicebyTableId(int tableid)
 {
     clsLst lst = new clsLst();
     ClsData data = new ClsData();
     return lst.GetFirstWaiterIdTableInvoices(tableid).ToString();
 }
示例#24
0
 public static string GetWaiters()
 {
     clsLst clsFront = new clsLst();
     ClsData DataJSon = new ClsData();
     return DataJSon.fGetJson(clsFront.fgetWaiters());
 }
示例#25
0
 public static string tableInvoiceQuantity(int tableid)
 {
     clsLst lst = new clsLst();
     return lst.TableInvoicesQuantity(tableid).ToString();
 }
示例#26
0
    public static string savePays(int invoiceid, string idpago, string desc, string value)
    {
        clsLst lst = new clsLst();
        ClsData data = new ClsData();

        lst.iInvoiceId = invoiceid;
        string result = lst.InsertInvoicePays(idpago, desc, value);
        return result;
    }
示例#27
0
 public static string getcomboCategory()
 {
     clsLst lst = new clsLst();
     ClsData data = new ClsData();
     return data.fGetJson(lst.comboProductCategory());
 }
示例#28
0
 public static string getConsecutiveString()
 {
     clsLst lst = new clsLst();
     return lst.GetLastConsecutiveInvoice().ToString();
 }
示例#29
0
 public static string GetProducts()
 {
     clsLst clsFront = new clsLst();
     ClsData DataJSon = new ClsData();
     return DataJSon.fGetJson(clsFront.dataProducts());
 }
示例#30
0
 public static string InsertProductToInvoice(int invoiceid,int productid, int quantity, int price, string user)
 {
     clsLst clsFront = new clsLst();
     ClsData DataJSon = new ClsData();
     return clsFront.InsertUpdateDeleteProductInvoiceDetail(clsFront.TYPE_INSERT);
 }