public static string DeleteInvoice(int invoiceId) { clsLst cls = new clsLst(); cls.iInvoiceId = invoiceId; return cls.InsertUpdateDeleteInvoice(cls.TYPE_DELETE); }
public static string GenerateInvoice(int invoiceId) { clsLst cls = new clsLst(); cls.iInvoiceId = invoiceId; return cls.InsertUpdateDeleteInvoice(cls.TYPE_APPROVE); }
public static string deleteInvoiceProduct(int id) { clsLst lst = new clsLst(); lst.iDetail_Id = id; return lst.InsertUpdateDeleteProductInvoiceDetail(lst.TYPE_DELETE); }
public static string ChangeTableInvoice(int tableAdmin, int tableId) { clsLst cls = new clsLst(); cls.iTableId = tableId; cls.iTableAdmin = tableAdmin; return cls.UpdateTableIdToInvoice(); }
public static string DeleteSupplier(int id) { clsLst lst = new clsLst(); lst.iSupplierId = id; string result = lst.InsertUpdateDeleteSuppliers(lst.TYPE_DELETE); return result; }
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; }
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); }
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); }
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); }
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)); } }
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; }
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; }
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) { } }
public static String GetTables() { clsLst clsFront = new clsLst(); ClsData DataJSon = new ClsData(); return DataJSon.fGetJson(clsFront.GetTables()); }
public static string getCountInvoicesByTableId(int tableid) { clsLst lst = new clsLst(); ClsData data = new ClsData(); return lst.getCountInvoicesByTableId(tableid).ToString(); }
public static string makeCloseDay() { clsLst lst = new clsLst(); return lst.closeDay(); }
public static string getcomboSupplier() { clsLst lst = new clsLst(); ClsData data = new ClsData(); return data.fGetJson(lst.comboSupplier()); }
public static string GetTableAviables(int tableid) { clsLst clsFront = new clsLst(); ClsData DataJSon = new ClsData(); return DataJSon.fGetJson(clsFront.getTablesAviables(tableid)); }
public static string getTableNo(int invoiceId) { clsLst lst = new clsLst(); return lst.GetNumberTableByInvoiceId(invoiceId).ToString(); }
public static string getWaiterIdInvoicebyTableId(int tableid) { clsLst lst = new clsLst(); ClsData data = new ClsData(); return lst.GetFirstWaiterIdTableInvoices(tableid).ToString(); }
public static string GetWaiters() { clsLst clsFront = new clsLst(); ClsData DataJSon = new ClsData(); return DataJSon.fGetJson(clsFront.fgetWaiters()); }
public static string tableInvoiceQuantity(int tableid) { clsLst lst = new clsLst(); return lst.TableInvoicesQuantity(tableid).ToString(); }
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; }
public static string getcomboCategory() { clsLst lst = new clsLst(); ClsData data = new ClsData(); return data.fGetJson(lst.comboProductCategory()); }
public static string getConsecutiveString() { clsLst lst = new clsLst(); return lst.GetLastConsecutiveInvoice().ToString(); }
public static string GetProducts() { clsLst clsFront = new clsLst(); ClsData DataJSon = new ClsData(); return DataJSon.fGetJson(clsFront.dataProducts()); }
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); }