public ActionResult Edit(CVECAROLEntity objCVECAROL)
{
if (ModelState.IsValid)
{
objCVECAROL.BaseRemoteIp = RemoteIp;
objCVECAROL.BaseIdUser = LoggedUserName;
int result = proxy.UpdateCVECAROL(objCVECAROL);
if (result == -1)
{
CVECAROLEntity objCVECAROLOld = proxy.GetCVECAROL(objCVECAROL.Clv_Colonia);
AssingMessageScript("El CVECAROL ya existe en el sistema, .", "error", "Error", true);
CheckNotify();
return(View(objCVECAROL));
}
if (result > 0)
{
AssingMessageScript("El CVECAROL se modifico en el sistema.", "success", "Éxito", true);
CheckNotify();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
return(View(objCVECAROL));
}
public ActionResult Details(int id = 0)
{
CVECAROLEntity objCVECAROL = proxy.GetCVECAROL(id);
if (objCVECAROL == null)
{
return(HttpNotFound());
}
return(PartialView(objCVECAROL));
}
public ActionResult Edit(int id = 0)
{
PermisosAccesoDeniedEdit("CVECAROL");
ViewBag.CustomScriptsPageValid = BuildScriptPageValid();
CVECAROLEntity objCVECAROL = proxy.GetCVECAROL(id);
if (objCVECAROL == null)
{
return(HttpNotFound());
}
return(View(objCVECAROL));
}
public static CVECAROLEntity GetOneDeep(int?Clv_Calle, int?Clv_Colonia)
{
CVECAROLEntity result = ProviderSoftv.CVECAROL.GetCVECAROLById(Clv_Colonia);
if (result.Clv_Calle != null)
{
result.CALLES = ProviderSoftv.CALLE.GetCALLEById(result.Clv_Calle);
}
if (result.Clv_Colonia != null)
{
result.COLONIA = ProviderSoftv.COLONIA.GetCOLONIAById(result.Clv_Colonia);
}
return(result);
}
/// <summary>
/// Edits a CVECAROL
///</summary>
/// <param name="CVECAROL"> Objeto CVECAROL a editar </param>
public override int EditCVECAROL(CVECAROLEntity entity_CVECAROL)
{
int result = 0;
using (SqlConnection connection = new SqlConnection(SoftvSettings.Settings.CVECAROL.ConnectionString))
{
SqlCommand comandoSql = CreateCommand("Softv_CVECAROLEdit", connection);
AssingParameter(comandoSql, "@Clv_Calle", entity_CVECAROL.Clv_Calle);
AssingParameter(comandoSql, "@Clv_Colonia", entity_CVECAROL.Clv_Colonia);
AssingParameter(comandoSql, "@NumCasas", entity_CVECAROL.NumCasas);
AssingParameter(comandoSql, "@NumNegocios", entity_CVECAROL.NumNegocios);
AssingParameter(comandoSql, "@NumBaldios", entity_CVECAROL.NumBaldios);
AssingParameter(comandoSql, "@Sector", entity_CVECAROL.Sector);
AssingParameter(comandoSql, "@Troncal", entity_CVECAROL.Troncal);
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
result = int.Parse(ExecuteNonQuery(comandoSql).ToString());
}
catch (Exception ex)
{
throw new Exception("Error updating CVECAROL " + ex.Message, ex);
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
return(result);
}
public override CVECAROLEntity GetCVECAROLByCalle(int?Clv_Calle)
{
using (SqlConnection connection = new SqlConnection(SoftvSettings.Settings.CVECAROL.ConnectionString))
{
SqlCommand comandoSql = CreateCommand("Softv_", connection);
CVECAROLEntity entity_CVECAROL = null;
AssingParameter(comandoSql, "@Clv_Calle", Clv_Calle);
IDataReader rd = null;
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
rd = ExecuteReader(comandoSql, CommandBehavior.SingleRow);
if (rd.Read())
{
entity_CVECAROL = GetCVECAROLFromReader(rd);
}
}
catch (Exception ex)
{
throw new Exception("Error getting data CVECAROL " + ex.Message, ex);
}
finally
{
if (connection != null)
{
connection.Close();
}
if (rd != null)
{
rd.Close();
}
}
return(entity_CVECAROL);
}
}
/// <summary>
///</summary>
/// <param name="CVECAROL"> Object CVECAROL added to List</param>
public override int AddCVECAROL(CVECAROLEntity entity_CVECAROL)
{
int result = 0;
using (SqlConnection connection = new SqlConnection(SoftvSettings.Settings.CVECAROL.ConnectionString))
{
SqlCommand comandoSql = CreateCommand("Softv_CVECAROLAdd", connection);
AssingParameter(comandoSql, "@Clv_Colonia", null, pd: ParameterDirection.Output, IsKey: true);
AssingParameter(comandoSql, "@Clv_Calle", entity_CVECAROL.Clv_Calle);
AssingParameter(comandoSql, "@NumCasas", entity_CVECAROL.NumCasas);
AssingParameter(comandoSql, "@NumNegocios", entity_CVECAROL.NumNegocios);
AssingParameter(comandoSql, "@NumBaldios", entity_CVECAROL.NumBaldios);
AssingParameter(comandoSql, "@Sector", entity_CVECAROL.Sector);
AssingParameter(comandoSql, "@Troncal", entity_CVECAROL.Troncal);
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
result = ExecuteNonQuery(comandoSql);
}
catch (Exception ex)
{
throw new Exception("Error adding CVECAROL " + ex.Message, ex);
}
finally
{
connection.Close();
}
result = (int)comandoSql.Parameters["@Clv_Colonia"].Value;
}
return(result);
}
/// <summary>
/// Converts data from reader to entity
/// </summary>
protected virtual CVECAROLEntity GetCVECAROLFromReader(IDataReader reader)
{
CVECAROLEntity entity_CVECAROL = null;
try
{
entity_CVECAROL = new CVECAROLEntity();
entity_CVECAROL.Clv_Calle = (int?)(GetFromReader(reader, "Clv_Calle"));
entity_CVECAROL.Clv_Colonia = (int?)(GetFromReader(reader, "Clv_Colonia"));
entity_CVECAROL.NumCasas = (int?)(GetFromReader(reader, "NumCasas"));
entity_CVECAROL.NumNegocios = (int?)(GetFromReader(reader, "NumNegocios"));
entity_CVECAROL.NumBaldios = (int?)(GetFromReader(reader, "NumBaldios"));
entity_CVECAROL.Sector = (char)(GetFromReader(reader, "Sector"));
entity_CVECAROL.Troncal = (char)(GetFromReader(reader, "Troncal"));
}
catch (Exception ex)
{
throw new Exception("Error converting CVECAROL data to entity", ex);
}
return(entity_CVECAROL);
}
public ActionResult Create(CVECAROLEntity objCVECAROL)
{
if (ModelState.IsValid)
{
objCVECAROL.BaseRemoteIp = RemoteIp;
objCVECAROL.BaseIdUser = LoggedUserName;
int result = proxy.AddCVECAROL(objCVECAROL);
if (result == -1)
{
AssingMessageScript("El CVECAROL ya existe en el sistema.", "error", "Error", true);
CheckNotify();
return(View(objCVECAROL));
}
if (result > 0)
{
AssingMessageScript("Se dio de alta el CVECAROL en el sistema.", "success", "Éxito", true);
return(RedirectToAction("Index"));
}
}
return(View(objCVECAROL));
}
public ActionResult QuickIndex(int?page, int?pageSize, int?Clv_Colonia)
{
int pageNumber = (page ?? 1);
int pSize = pageSize ?? SoftvMVC.Properties.Settings.Default.pagnum;
SoftvList <CVECAROLEntity> listResult = null;
List <CVECAROLEntity> listCVECAROL = new List <CVECAROLEntity>();
CVECAROLEntity objCVECAROL = new CVECAROLEntity();
CVECAROLEntity objGetCVECAROL = new CVECAROLEntity();
if ((Clv_Colonia != null))
{
objCVECAROL.Clv_Colonia = Clv_Colonia;
}
pageNumber = pageNumber == 0 ? 1 : pageNumber;
listResult = proxy.GetCVECAROLPagedListXml(pageNumber, pSize, Globals.SerializeTool.Serialize(objCVECAROL));
if (listResult.Count == 0)
{
int tempPageNumber = (int)(listResult.totalCount / pSize);
pageNumber = (int)(listResult.totalCount / pSize) == 0 ? 1 : tempPageNumber;
listResult = proxy.GetCVECAROLPagedListXml(pageNumber, pSize, Globals.SerializeTool.Serialize(objCVECAROL));
}
listResult.ToList().ForEach(x => listCVECAROL.Add(x));
var CVECAROLAsIPagedList = new StaticPagedList <CVECAROLEntity>(listCVECAROL, pageNumber, pSize, listResult.totalCount);
if (CVECAROLAsIPagedList.Count > 0)
{
return(PartialView(CVECAROLAsIPagedList));
}
else
{
var result = new { tipomsj = "warning", titulomsj = "Aviso", Success = "False", Message = "No se encontraron registros con los criterios de búsqueda ingresados." };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public static int Edit(CVECAROLEntity objCVECAROL)
{
int result = ProviderSoftv.CVECAROL.EditCVECAROL(objCVECAROL);
return(result);
}
public static int Add(CVECAROLEntity objCVECAROL)
{
int result = ProviderSoftv.CVECAROL.AddCVECAROL(objCVECAROL);
return(result);
}
/// <summary> /// Abstract method to update CVECAROL /// </summary> public abstract int EditCVECAROL(CVECAROLEntity entity_CVECAROL);
/// <summary> /// Abstract method to add CVECAROL /// /summary> /// <param name="CVECAROL"></param> /// <returns></returns> public abstract int AddCVECAROL(CVECAROLEntity entity_CVECAROL);
public int UpdateCVECAROL(CVECAROLEntity objCVECAROL)
{
return(CVECAROL.Edit(objCVECAROL));
}
public int AddCVECAROL(CVECAROLEntity objCVECAROL)
{
return(CVECAROL.Add(objCVECAROL));
}
