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);
}