public ActionResult WCO01Menu(string valor2, WCO01_ListaContratos Contratos )
{
if (ModelState.IsValid)
{
}
return View();
}
public ActionResult WCO01Menu(string IDContrato, string NContrato, string NombreAsesor,
string CodAsesor, string NombreCliente, string ODP)
{
WCO01_ListaContratos man = new WCO01_ListaContratos();
man.IDLinea = Convert.ToInt32(IDContrato);
man.NContrato = NContrato;
man.NombreVendedor = NombreAsesor;
man.CodAsesor = CodAsesor;
man.NombreCliente = NombreCliente;
man.ODP = ODP;
return View(man);
}
public ActionResult WCO01MenuAdd(FormCollection formCollection, WCO01_ListaContratos contrats)
{
//foreach (string key in formCollection.AllKeys)
//{
// Response.Write("Key= " + key + " ");
// Response.Write(formCollection[key]);
// Response.Write("<br/>");
//}
//Response.Write("nada");
try
{
if (ModelState.IsValid)
{
WCO01_ListaContratos man = new WCO01_ListaContratos();
man.IDLinea = 0;
man.NContrato = formCollection["NContrato"];
man.CodCliente = formCollection["CodCliente"];
man.NombreCliente = formCollection["NombreCliente"];
man.ODP = formCollection["ODP"];
man.Empresa = formCollection["Empresa"];
man.FechaContrato = Convert.ToDateTime(formCollection["FechaContrato"]);
man.CodAsesor = formCollection["CodAsesor"];
man.Estado = 0;
man.QuienIngreso = "dvargas";
int resultado = GestorWCO01.WCO01_INSERT(man);
//Luego ver si pasa un error que dato dar.
return RedirectToAction("WCO01MenuBuscar");
//return View();
}
}
catch (ExecutionEngineException ex /* edx */)
{
return View();
}
return View();
}
public ActionResult WCO01MenuAdd(string cod, string nombre, string Telefono, string CodAsesor, string vendedor)
{
WCO01_ListaContratos man = new WCO01_ListaContratos();
if (Telefono != null)
{
ViewBag.cod = cod;
ViewBag.nombre = nombre;
ViewBag.telefono = Telefono;
man.CodCliente = ViewBag.cod;
man.NombreCliente = ViewBag.nombre;
man.Telefono = ViewBag.Telefono;
}
else
{
//ViewBag.CodAsesor = CodAsesor;
//ViewBag.vendedor = vendedor;
ViewBag.CodAsesor = cod;
ViewBag.vendedor = nombre;
man.CodAsesor = ViewBag.CodAsesor;
man.NombreVendedor = ViewBag.vendedor;
}
return View(man);
}
public WCO01_ListaContratos CargarListaContratos2()
{
WCO01_ListaContratos man = new WCO01_ListaContratos();
var con = new SqlConnection (db.Database.Connection.ConnectionString);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand();
adapter.SelectCommand.CommandText = "WCO01_ListaContratos";
adapter.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adapter.SelectCommand.Connection = con;
DataTable dt = new DataTable();
adapter.Fill(dt);
adapter.SelectCommand.Connection.Close();
return man;
}
public static int WCO01_INSERT(WCO01_ListaContratos Contrato)
{
db = new siawinContext();
List<CC01> man = new List<CC01>();
SqlConnection conexion = new SqlConnection(db.Database.Connection.ConnectionString);
conexion.Close();
try
{
SqlCommand cmd = new SqlCommand("WCO01_INSERT", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("IDLinea", Contrato.IDLinea);
cmd.Parameters.AddWithValue("NContrato", Contrato.NContrato);
cmd.Parameters.AddWithValue("CodCliente", Contrato.CodCliente);
cmd.Parameters.AddWithValue("NombreCliente", Contrato.NombreCliente);
cmd.Parameters.AddWithValue("ODP", Contrato.ODP);
cmd.Parameters.AddWithValue("FechaContrato", Contrato.FechaContrato);
cmd.Parameters.AddWithValue("CodAsesor", Contrato.CodAsesor);
cmd.Parameters.AddWithValue("Estado", Contrato.Estado);
cmd.Parameters.AddWithValue("QuienIngreso", Contrato.QuienIngreso);
conexion.Open();
cmd.ExecuteNonQuery();
conexion.Close();
return 1;
}
catch (Exception)
{
return -1;
}
}
