public ActionResult newSucursal(Sucursal newSucursal)
{
Respuesta resp = new Respuesta();
SqlConnection myConnection = new SqlConnection();
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
SqlCommand command = new SqlCommand("INSERT INTO SUCURSAL (SUCC_ID, SUCC_DES) VALUES (@ID, @DES) ", myConnection);
command.Parameters.AddWithValue("@ID", newSucursal.succ_id);
command.Parameters.AddWithValue("@DES", newSucursal.succ_des);
command.ExecuteNonQuery();
command.Parameters.Clear();
}
catch (SqlException ex)
{
resp.success = false;
resp.message = "ERROR " + ex.Message;
return Json(resp);
}
finally
{
myConnection.Close();
}
resp.success = true;
resp.message = "OK";
return Json(resp);
}
public ActionResult updateSucursal(Sucursal sucursal)
{
Respuesta resp = new Respuesta();
SqlConnection myConnection = new SqlConnection();
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
SqlCommand command = new SqlCommand("UPDATE SUCURSAL SET SUCC_DES = @DES WHERE SUCC_ID = @ID ", myConnection);
command.Parameters.AddWithValue("@ID", sucursal.succ_id);
command.Parameters.AddWithValue("@DES", sucursal.succ_des);
if (0 < command.ExecuteNonQuery())
{
resp.success = true;
resp.message = "OK";
}
else
{
resp.success = false;
resp.message = "NO HUBO ACTUALIZACION";
}
command.Parameters.Clear();
}
catch (SqlException ex)
{
resp.success = false;
resp.message = "ERROR " + ex.Message;
return Json(resp);
}
finally
{
myConnection.Close();
}
return Json(resp);
}
public ActionResult getSucursales()
{
RespSucursal respSucursales = new RespSucursal();
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
SqlCommand command = new SqlCommand("select * from SUCURSAL;", myConnection);
reader = command.ExecuteReader();
List<Sucursal> listaSucursales = new List<Sucursal>();
while (reader.Read())
{
Sucursal suc = new Sucursal();
suc.succ_des = reader["succ_des"].ToString();
suc.succ_id = Convert.ToInt32(reader["succ_id"].ToString());
listaSucursales.Add(suc);
}
respSucursales.sucursales = listaSucursales;
}
catch (Exception ex)
{
respSucursales.success = false;
respSucursales.message = "ERROR " + ex.Message;
return Json(respSucursales);
}
finally
{
myConnection.Close();
}
respSucursales.success = true;
respSucursales.message = "OK";
return Json(respSucursales);
}