public string Post(FacturaFlete facturaflete)
{
try
{
DataTable table = new DataTable();
string query = @"
exec itInsertarNuevaFacturaFlete " + facturaflete.Fletera + " , '" + facturaflete.Factura + "', " + facturaflete.IDPedido + " , " + facturaflete.IDOrdenCarga + " , '" +
facturaflete.Subtotal + "' , '" + facturaflete.IVA + "' , '" + facturaflete.Total + "' , '" + facturaflete.Estatus + @"'";
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["Prolapp"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}
return("Se Actualizo Correctamente");
}
catch (Exception exe)
{
return("Se produjo un error" + exe);
}
}
public string PostActualizar(FacturaFlete facturaflete)
{
try
{
DataTable table = new DataTable();
string query = @"update FacturaFlete set Fletera='" + facturaflete.Fletera + "' , Factura='" + facturaflete.Factura + "', IDPedido=" + facturaflete.IDPedido + " , IDOrdenCarga=" + facturaflete.IDOrdenCarga + " , Subtotal= '" +
facturaflete.Subtotal + "' , IVA= '" + facturaflete.IVA + "' , Total='" + facturaflete.Total + "' , Estatus='" + facturaflete.Estatus + "' where IDFacturaFlete=" + facturaflete.IDFacturaFlete + ";";
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["Prolapp"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}
return("Se Actualizo Correctamente");
}
catch (Exception exe)
{
return("Se produjo un error" + exe);
}
}
