public int Insert(string sRol_name, int sStatus)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@id";
prmA.Direction = ParameterDirection.Output;
lstParametros.Add(prmA);
DbParameter prmsRol_name = new SqlParameter();
prmsRol_name.DbType = DbType.String;
prmsRol_name.ParameterName = "@sRol_name";
prmsRol_name.Value = sRol_name;
prmsRol_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsRol_name);
DbParameter prmsStatus = new SqlParameter();
prmsStatus.DbType = DbType.Int32;
prmsStatus.ParameterName = "@sStatus";
prmsStatus.Value = sStatus;
prmsStatus.Direction = ParameterDirection.Input;
lstParametros.Add(prmsStatus);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblRols_Insert"))
return Convert.ToInt32(prmA.Value);
return -1;
}
public int Insert(string sCostCenter_name, string sCostCenter_desc, int iCostCenter_gestion)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmCC = new SqlParameter();
prmCC.DbType = DbType.Int32;
prmCC.ParameterName = "@iCostCenter_id";
prmCC.Direction = ParameterDirection.Output;
lstParametros.Add(prmCC);
DbParameter prmsCostCenter_name = new SqlParameter();
prmsCostCenter_name.DbType = DbType.String;
prmsCostCenter_name.ParameterName = "@sCostCenter_name";
prmsCostCenter_name.Value = sCostCenter_name;
prmsCostCenter_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsCostCenter_name);
DbParameter prmsCostCenter_desc = new SqlParameter();
prmsCostCenter_desc.DbType = DbType.String;
prmsCostCenter_desc.ParameterName = "@sCostCenter_desc";
prmsCostCenter_desc.Value = sCostCenter_desc;
prmsCostCenter_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsCostCenter_desc);
DbParameter prmiCostCenter_gestion = new SqlParameter();
prmiCostCenter_gestion.DbType = DbType.Int16;
prmiCostCenter_gestion.ParameterName = "@iCostCenter_gestion";
prmiCostCenter_gestion.Value = iCostCenter_gestion;
prmiCostCenter_gestion.Direction = ParameterDirection.Input;
lstParametros.Add(prmiCostCenter_gestion);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.InsCostCenter"))
return Convert.ToInt32(prmCC.Value);
return -1;
}
public int Insert(string sFamily_name, string sFamily_desc, int iDepreciation_time)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiFamily_id = new SqlParameter();
prmiFamily_id.DbType = DbType.Int32;
prmiFamily_id.ParameterName = "@id";
prmiFamily_id.Direction = ParameterDirection.Output;
lstParametros.Add(prmiFamily_id);
DbParameter prmsFamily_name = new SqlParameter();
prmsFamily_name.DbType = DbType.String;
prmsFamily_name.ParameterName = "@sFamily_name";
prmsFamily_name.Value = sFamily_name;
prmsFamily_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsFamily_name);
DbParameter prmsFamily_desc = new SqlParameter();
prmsFamily_desc.DbType = DbType.String;
prmsFamily_desc.ParameterName = "@sFamily_desc";
prmsFamily_desc.Value = sFamily_desc;
prmsFamily_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsFamily_desc);
DbParameter prmiDepreciation = new SqlParameter();
prmiDepreciation.DbType = DbType.String;
prmiDepreciation.ParameterName = "@iDepreciation_time";
prmiDepreciation.Value = iDepreciation_time;
prmiDepreciation.Direction = ParameterDirection.Input;
lstParametros.Add(prmiDepreciation);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblFamilies_Insert"))
return Convert.ToInt32(prmiFamily_id.Value);
return -1;
}
public int Insertar(DateTime fecha, string nombreFactura, string nitFactura, SqlTransaction transaccion)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@codigo";
prmA.Direction = ParameterDirection.Output;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.DateTime;
prmB.ParameterName = "@fecha";
prmB.Value = fecha;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
DbParameter prmC = new SqlParameter();
prmC.DbType = DbType.String;
prmC.ParameterName = "@nombreFactura";
prmC.Value = nombreFactura;
prmC.Direction = ParameterDirection.Input;
lstParametros.Add(prmC);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.String;
prmD.ParameterName = "@nitFactura";
prmD.Value = nitFactura;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.InsertFactura", transaccion))
return Convert.ToInt32(prmA.Value);
return -1;
}
public int Insertar(int factura_id, int producto_id, int cantidad, SqlTransaction transaccion)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@codigo";
prmA.Direction = ParameterDirection.Output;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.Int32;
prmB.ParameterName = "@factura_id";
prmB.Value = factura_id;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
DbParameter prmC = new SqlParameter();
prmC.DbType = DbType.Int32;
prmC.ParameterName = "@producto_id";
prmC.Value = producto_id;
prmC.Direction = ParameterDirection.Input;
lstParametros.Add(prmC);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.Int32;
prmD.ParameterName = "@cantidad";
prmD.Value = cantidad;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.InsertDFactura", transaccion))
return Convert.ToInt32(prmA.Value);
return -1;
}
public bool Actualizar(int codigo, string nm, string rs, string phone, string email, string desc, string dir)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iProvider_id";
prmA.Value = codigo;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.String;
prmB.ParameterName = "@sProvider_name";
prmB.Value = nm;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.String;
prmD.ParameterName = "@sProvider_rs";
prmD.Value = rs;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
////
DbParameter prmE = new SqlParameter();
prmE.DbType = DbType.String;
prmE.ParameterName = "@sProvider_phone";
prmE.Value = phone;
prmE.Direction = ParameterDirection.Input;
lstParametros.Add(prmE);
DbParameter prmF = new SqlParameter();
prmF.DbType = DbType.String;
prmF.ParameterName = "@sProvider_email";
prmF.Value = email;
prmF.Direction = ParameterDirection.Input;
lstParametros.Add(prmF);
DbParameter prmG = new SqlParameter();
prmG.DbType = DbType.String;
prmG.ParameterName = "@sProvider_desc";
prmG.Value = desc;
prmG.Direction = ParameterDirection.Input;
lstParametros.Add(prmG);
DbParameter prmH = new SqlParameter();
prmH.DbType = DbType.String;
prmH.ParameterName = "@sProvider_address";
prmH.Value = dir;
prmH.Direction = ParameterDirection.Input;
lstParametros.Add(prmH);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblProviders_Update");
}
public bool Eliminar(int codigo)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iProvider_id";
prmA.Value = codigo;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblProviders_DeleteRow");
}
public bool Delete(int iFamily_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiFamily_id = new SqlParameter();
prmiFamily_id.DbType = DbType.Int32;
prmiFamily_id.ParameterName = "@iFamily_id";
prmiFamily_id.Value = iFamily_id;
prmiFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiFamily_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblFamilies_DeleteRow");
}
public bool Delete(int codigo)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmId = new SqlParameter();
prmId.DbType = DbType.Int32;
prmId.ParameterName = "@iPerson_id";
prmId.Value = codigo;
prmId.Direction = ParameterDirection.Input;
lstParametros.Add(prmId);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblResponsibles_DeleteRow");
}
public bool Eliminar(int iCostCenter_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiCostCenter_id = new SqlParameter();
prmiCostCenter_id.DbType = DbType.Int32;
prmiCostCenter_id.ParameterName = "@iCostCenter_id";
prmiCostCenter_id.Value = iCostCenter_id;
prmiCostCenter_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiCostCenter_id);
/* DbParameter prmDe = new SqlParameter();
prmDe.DbType = DbType.Int32;
prmDe.ParameterName = "@iEvento";
prmDe.Value = 3;
prmDe.Direction = ParameterDirection.Input;
lstParametros.Add(prmDe);*/
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.DeleteCostCenter");
}
public bool Actualizar(int codigo, string nombre)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@codigo";
prmA.Value = codigo;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.String;
prmB.ParameterName = "@nombre";
prmB.Value = nombre;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.UpdateEmpleado");
}
public bool Delete(int iPerson_id, int iActive_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiPerson_id = new SqlParameter();
prmiPerson_id.DbType = DbType.Int32;
prmiPerson_id.ParameterName = "@iPerson_id";
prmiPerson_id.Value = iPerson_id;
prmiPerson_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiPerson_id);
DbParameter prmiActive_id = new SqlParameter();
prmiActive_id.DbType = DbType.Int32;
prmiActive_id.ParameterName = "@iActive_id";
prmiActive_id.Value = iActive_id;
prmiActive_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiActive_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblAsigResponsibleActive_DeleteRow");
}
/// <summary>
/// Inserta un registro al origen de datos
/// </summary>
/// <param name="nombre">Nombre empleado</param>
/// <returns>Id del empleado insertado</returns>
public int Insertar(string nombre)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@codigo";
prmA.Direction = ParameterDirection.Output;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.String;
prmB.ParameterName = "@nombre";
prmB.Value = nombre;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.InsertEmpleado"))
return Convert.ToInt32(prmA.Value);
return -1;
}
public int Insert(
int iResponsible_id,
int iCostCenter_id,
int iPercent,
DateTime dtAsignation_time)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiResponsible_id = new SqlParameter();
prmiResponsible_id.DbType = DbType.Int32;
prmiResponsible_id.ParameterName = "@iResponsible_id";
prmiResponsible_id.Value = Convert.ToInt32(iResponsible_id);
prmiResponsible_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiResponsible_id);
DbParameter prmiCostCenter_id = new SqlParameter();
prmiCostCenter_id.DbType = DbType.Int32;
prmiCostCenter_id.ParameterName = "@iCostCenter_id";
prmiCostCenter_id.Value = Convert.ToInt32(iCostCenter_id);
prmiCostCenter_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiCostCenter_id);
DbParameter prmiPercent = new SqlParameter();
prmiPercent.DbType = DbType.Int32;
prmiPercent.ParameterName = "@iPercent";
prmiPercent.Value = Convert.ToInt32(iPercent);
prmiPercent.Direction = ParameterDirection.Input;
lstParametros.Add(prmiPercent);
DbParameter prmdtAsignation_time = new SqlParameter();
prmdtAsignation_time.DbType = DbType.DateTime;
prmdtAsignation_time.ParameterName = "@dtAsignation_time";
prmdtAsignation_time.Value = dtAsignation_time;
prmdtAsignation_time.Direction = ParameterDirection.Input;
lstParametros.Add(prmdtAsignation_time);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblPeopleCostCenters_Insert"))
return 1;
return -1;
}
public bool Delete(
int iResponsible_id,
int iCostCenter_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiResponsible_id = new SqlParameter();
prmiResponsible_id.DbType = DbType.Int32;
prmiResponsible_id.ParameterName = "@iResponsible_id";
prmiResponsible_id.Value = Convert.ToInt32(iResponsible_id);
prmiResponsible_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiResponsible_id);
DbParameter prmiCostCenter_id = new SqlParameter();
prmiCostCenter_id.DbType = DbType.Int32;
prmiCostCenter_id.ParameterName = "@iCostCenter_id";
prmiCostCenter_id.Value = Convert.ToInt32(iCostCenter_id);
prmiCostCenter_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiCostCenter_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblPeopleCostCenters_DeleteRow");
}
public int Insertar(string sActive_name,
string sStatus, int iSubFamily_id,
int iProvider_id,
string sBarcode,
DateTime dRegister_time,
int iUtilTime,
string sBrand,
string sModel,
string sForm,
string sSerialNumber,
string sColor,
string sCapacity,
string sMaterial,
double iHeihgt,
double iWidth,
double iWide,
double iDiameter,
string sUnit,
int iDivNumber,
string sAsign_type,
string sAcquisition_type,
DateTime dtBuy_time,
double iBuy_price,
bool bInActive)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmCod = new SqlParameter();
prmCod.DbType = DbType.Int32;
prmCod.ParameterName = "@codigo";
prmCod.Direction = ParameterDirection.Output;
lstParametros.Add(prmCod);
DbParameter prmsActive_name = new SqlParameter();
prmsActive_name.DbType = DbType.String;
prmsActive_name.ParameterName = "@sActive_name";
prmsActive_name.Value = sActive_name;
prmsActive_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsActive_name);
DbParameter prmsStatus = new SqlParameter();
prmsStatus.DbType = DbType.String;
prmsStatus.ParameterName = "@sStatus";
prmsStatus.Value = sStatus;
prmsStatus.Direction = ParameterDirection.Input;
lstParametros.Add(prmsStatus);
DbParameter prmiSubFamily_id = new SqlParameter();
prmiSubFamily_id.DbType = DbType.Int16;
prmiSubFamily_id.ParameterName = "@iSubFamily_id";
prmiSubFamily_id.Value = iSubFamily_id;
prmiSubFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiSubFamily_id);
DbParameter prmiProvider_id = new SqlParameter();
prmiProvider_id.DbType = DbType.Int16;
prmiProvider_id.ParameterName = "@iProvider_id";
prmiProvider_id.Value = iProvider_id;
prmiProvider_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiProvider_id);
DbParameter prmsBarcode = new SqlParameter();
prmsBarcode.DbType = DbType.String;
prmsBarcode.ParameterName = "@sBarcode";
prmsBarcode.Value = sBarcode;
prmsBarcode.Direction = ParameterDirection.Input;
lstParametros.Add(prmsBarcode);
DbParameter prmdRegister_time = new SqlParameter();
prmdRegister_time.DbType = DbType.DateTime;
prmdRegister_time.ParameterName = "@dRegister_time";
prmdRegister_time.Value = dRegister_time;
prmdRegister_time.Direction = ParameterDirection.Input;
lstParametros.Add(prmdRegister_time);
DbParameter prmiUtilTime = new SqlParameter();
prmiUtilTime.DbType = DbType.Int32;
prmiUtilTime.ParameterName = "@iUtilTime";
prmiUtilTime.Value = iUtilTime;
prmiUtilTime.Direction = ParameterDirection.Input;
lstParametros.Add(prmiUtilTime);
DbParameter prmsBrand = new SqlParameter();
prmsBrand.DbType = DbType.String;
prmsBrand.ParameterName = "@sBrand";
prmsBrand.Value = sBrand;
prmsBrand.Direction = ParameterDirection.Input;
lstParametros.Add(prmsBrand);
DbParameter prmsModel = new SqlParameter();
prmsModel.DbType = DbType.String;
prmsModel.ParameterName = "@sModel";
prmsModel.Value = sModel;
prmsModel.Direction = ParameterDirection.Input;
lstParametros.Add(prmsModel);
DbParameter prmsForm = new SqlParameter();
prmsForm.DbType = DbType.String;
prmsForm.ParameterName = "@sForm";
prmsForm.Value = sForm;
prmsForm.Direction = ParameterDirection.Input;
lstParametros.Add(prmsForm);
DbParameter prmsSerialNumber = new SqlParameter();
prmsSerialNumber.DbType = DbType.String;
prmsSerialNumber.ParameterName = "@sSerialNumber";
prmsSerialNumber.Value = sSerialNumber;
prmsSerialNumber.Direction = ParameterDirection.Input;
lstParametros.Add(prmsSerialNumber);
DbParameter prmsColor = new SqlParameter();
prmsColor.DbType = DbType.String;
prmsColor.ParameterName = "@sColor";
prmsColor.Value = sColor;
prmsColor.Direction = ParameterDirection.Input;
lstParametros.Add(prmsColor);
DbParameter prmsCapacity = new SqlParameter();
prmsCapacity.DbType = DbType.String;
prmsCapacity.ParameterName = "@sCapacity";
prmsCapacity.Value = sCapacity;
prmsCapacity.Direction = ParameterDirection.Input;
lstParametros.Add(prmsCapacity);
DbParameter prmsMaterial = new SqlParameter();
prmsMaterial.DbType = DbType.String;
prmsMaterial.ParameterName = "@sMaterial";
prmsMaterial.Value = sMaterial;
prmsMaterial.Direction = ParameterDirection.Input;
lstParametros.Add(prmsMaterial);
DbParameter prmiHeihgt = new SqlParameter();
prmiHeihgt.DbType = DbType.Int16;
prmiHeihgt.ParameterName = "@iHeihgt";
prmiHeihgt.Value = iHeihgt;
prmiHeihgt.Direction = ParameterDirection.Input;
lstParametros.Add(prmiHeihgt);
DbParameter prmiWidth = new SqlParameter();
prmiWidth.DbType = DbType.Int16;
prmiWidth.ParameterName = "@iWidth";
prmiWidth.Value = iWidth;
prmiWidth.Direction = ParameterDirection.Input;
lstParametros.Add(prmiWidth);
DbParameter prmsColor = new SqlParameter();
prmsColor.DbType = DbType.String;
prmsColor.ParameterName = "@sColor";
prmsColor.Value = sColor;
prmsColor.Direction = ParameterDirection.Input;
lstParametros.Add(prmsColor);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.InsertFactura", transaccion))
return Convert.ToInt32(prmA.Value);
return -1;
}
public int Insertar(string nm, string rs, string phone, string email, string desc, string dir, SqlTransaction transaccion)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iProvider_id";
prmA.Direction = ParameterDirection.Output;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.String;
prmB.ParameterName = "@sProvider_name";
prmB.Value = nm;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.String;
prmD.ParameterName = "@sProvider_rs";
prmD.Value = rs;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
////
DbParameter prmE = new SqlParameter();
prmE.DbType = DbType.String;
prmE.ParameterName = "@sProvider_phone";
prmE.Value = phone;
prmE.Direction = ParameterDirection.Input;
lstParametros.Add(prmE);
DbParameter prmF = new SqlParameter();
prmF.DbType = DbType.String;
prmF.ParameterName = "@sProvider_email";
prmF.Value = email;
prmF.Direction = ParameterDirection.Input;
lstParametros.Add(prmF);
DbParameter prmG = new SqlParameter();
prmG.DbType = DbType.String;
prmG.ParameterName = "@sProvider_desc";
prmG.Value = desc;
prmG.Direction = ParameterDirection.Input;
lstParametros.Add(prmG);
DbParameter prmH = new SqlParameter();
prmH.DbType = DbType.String;
prmH.ParameterName = "@sProvider_address";
prmH.Value = dir;
prmH.Direction = ParameterDirection.Input;
lstParametros.Add(prmH);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblProviders_Insert", transaccion))
return Convert.ToInt32(prmA.Value);
return -1;
}
public bool Update(int iFamily_id, string sFamily_name, string sFamily_desc, int iDepreciation_time)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiFamily_id = new SqlParameter();
prmiFamily_id.DbType = DbType.Int32;
prmiFamily_id.ParameterName = "@iFamily_id";
prmiFamily_id.Value = iFamily_id;
prmiFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiFamily_id);
DbParameter prmsFamily_name = new SqlParameter();
prmsFamily_name.DbType = DbType.String;
prmsFamily_name.ParameterName = "@sFamily_name";
prmsFamily_name.Value = sFamily_name;
prmsFamily_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsFamily_name);
DbParameter prmsFamily_desc = new SqlParameter();
prmsFamily_desc.DbType = DbType.String;
prmsFamily_desc.ParameterName = "@sFamily_desc";
prmsFamily_desc.Value = sFamily_desc;
prmsFamily_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsFamily_desc);
DbParameter prmiDepreciation = new SqlParameter();
prmiDepreciation.DbType = DbType.String;
prmiDepreciation.ParameterName = "@iDepreciation_time";
prmiDepreciation.Value = iDepreciation_time;
prmiDepreciation.Direction = ParameterDirection.Input;
lstParametros.Add(prmiDepreciation);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblFamilies_Update");
}
public bool Update(int iSubFamily_id,
int iFamily_id,
string sSubFamily_name,
string sSubFamily_desc)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiSubFamily_id = new SqlParameter();
prmiSubFamily_id.DbType = DbType.Int32;
prmiSubFamily_id.ParameterName = "@iSubFamily_id";
prmiSubFamily_id.Value = Convert.ToInt32(iSubFamily_id);
prmiSubFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiSubFamily_id);
DbParameter prmsSubFamily_name = new SqlParameter();
prmsSubFamily_name.DbType = DbType.String;
prmsSubFamily_name.ParameterName = "@sSubFamily_name";
prmsSubFamily_name.Value = sSubFamily_name;
prmsSubFamily_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsSubFamily_name);
DbParameter prmsSubFamily_desc = new SqlParameter();
prmsSubFamily_desc.DbType = DbType.String;
prmsSubFamily_desc.ParameterName = "@sSubFamily_desc";
prmsSubFamily_desc.Value = sSubFamily_desc;
prmsSubFamily_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsSubFamily_desc);
DbParameter prmiFamily_id = new SqlParameter();
prmiFamily_id.DbType = DbType.Int32;
prmiFamily_id.ParameterName = "@iFamily_id";
prmiFamily_id.Value = Convert.ToInt32(iFamily_id);
prmiFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiFamily_id);
SQLConexion conProxy=new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblSubFamilies_Update");
}
public bool Update(int iCostCenter_id, string sCostCenter_name, string sCostCenter_desc, int iCostCenter_gestion)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmCC = new SqlParameter();
prmCC.DbType = DbType.Int32;
prmCC.ParameterName = "@iCostCenter_id";
prmCC.Value = iCostCenter_id;
prmCC.Direction = ParameterDirection.Input;
lstParametros.Add(prmCC);
DbParameter prmsCostCenter_name = new SqlParameter();
prmsCostCenter_name.DbType = DbType.String;
prmsCostCenter_name.ParameterName = "@sCostCenter_name";
prmsCostCenter_name.Value = sCostCenter_name;
prmsCostCenter_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsCostCenter_name);
DbParameter prmsCostCenter_desc = new SqlParameter();
prmsCostCenter_desc.DbType = DbType.String;
prmsCostCenter_desc.ParameterName = "@sCostCenter_desc";
prmsCostCenter_desc.Value = sCostCenter_desc;
prmsCostCenter_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsCostCenter_desc);
DbParameter prmiCostCenter_gestion = new SqlParameter();
prmiCostCenter_gestion.DbType = DbType.Int16;
prmiCostCenter_gestion.ParameterName = "@iCostCenter_gestion";
prmiCostCenter_gestion.Value = iCostCenter_gestion;
prmiCostCenter_gestion.Direction = ParameterDirection.Input;
lstParametros.Add(prmiCostCenter_gestion);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.ActCostCenter");
}
public bool Update(int iRol_id, string sRol_name, int sStatus)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iRol_id";
prmA.Value = iRol_id;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
DbParameter prmsRol_name = new SqlParameter();
prmsRol_name.DbType = DbType.String;
prmsRol_name.ParameterName = "@sRol_name";
prmsRol_name.Value = sRol_name;
prmsRol_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsRol_name);
DbParameter prmbStatus = new SqlParameter();
prmbStatus.DbType = DbType.Int32;
prmbStatus.ParameterName = "@sStatus";
prmbStatus.Value = sStatus;
prmbStatus.Direction = ParameterDirection.Input;
lstParametros.Add(prmbStatus);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblRols_Update");
}
public bool Update(
int iActive_id,
string sActive_name,
int iSubFamily_id,
int iProvider_id,
string sActive_desc,
string sBarcode,
DateTime dRegister_time,
DateTime iUtilTime,
string sBrand,
string sModel,
string sForm,
string sSerialNumber,
string sColor,
string sCapacity,
string sMaterial,
decimal iHeihgt,
decimal iWidth,
decimal iWide,
decimal iDiameter,
string sUnit,
int iDivNumber,
string sAsign_type,
string sAquisition_type,
DateTime dtBuy_time,
decimal iBuy_price,
bool sStatus)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiActive_id = new SqlParameter();
prmiActive_id.DbType = DbType.Int32;
prmiActive_id.ParameterName = "@iActive_id";
prmiActive_id.Value = iActive_id;
prmiActive_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiActive_id);
DbParameter prmsActive_name = new SqlParameter();
prmsActive_name.DbType = DbType.String;
prmsActive_name.ParameterName = "@sActive_name";
prmsActive_name.Value = sActive_name;
prmsActive_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsActive_name);
DbParameter prmiSubFamily_id = new SqlParameter();
prmiSubFamily_id.DbType = DbType.Int16;
prmiSubFamily_id.ParameterName = "@iSubFamily_id";
prmiSubFamily_id.Value = iSubFamily_id;
prmiSubFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiSubFamily_id);
DbParameter prmiProvider_id = new SqlParameter();
prmiProvider_id.DbType = DbType.Int16;
prmiProvider_id.ParameterName = "@iProvider_id";
prmiProvider_id.Value = iProvider_id;
prmiProvider_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiProvider_id);
DbParameter prmsBarcode = new SqlParameter();
prmsBarcode.DbType = DbType.String;
prmsBarcode.ParameterName = "@sBarcode";
prmsBarcode.Value = sBarcode;
prmsBarcode.Direction = ParameterDirection.Input;
lstParametros.Add(prmsBarcode);
DbParameter prmsBrand = new SqlParameter();
prmsBrand.DbType = DbType.String;
prmsBrand.ParameterName = "@sBrand";
prmsBrand.Value = sBrand;
prmsBrand.Direction = ParameterDirection.Input;
lstParametros.Add(prmsBrand);
DbParameter prmsModel = new SqlParameter();
prmsModel.DbType = DbType.String;
prmsModel.ParameterName = "@sModel";
prmsModel.Value = sModel;
prmsModel.Direction = ParameterDirection.Input;
lstParametros.Add(prmsModel);
DbParameter prmsForm = new SqlParameter();
prmsForm.DbType = DbType.String;
prmsForm.ParameterName = "@sForm";
prmsForm.Value = sForm;
prmsForm.Direction = ParameterDirection.Input;
lstParametros.Add(prmsForm);
DbParameter prmsSerialNumber = new SqlParameter();
prmsSerialNumber.DbType = DbType.String;
prmsSerialNumber.ParameterName = "@sSerialNumber";
prmsSerialNumber.Value = sSerialNumber;
prmsSerialNumber.Direction = ParameterDirection.Input;
lstParametros.Add(prmsSerialNumber);
DbParameter prmsColor = new SqlParameter();
prmsColor.DbType = DbType.String;
prmsColor.ParameterName = "@sColor";
prmsColor.Value = sColor;
prmsColor.Direction = ParameterDirection.Input;
lstParametros.Add(prmsColor);
DbParameter prmsCapacity = new SqlParameter();
prmsCapacity.DbType = DbType.String;
prmsCapacity.ParameterName = "@sCapacity";
prmsCapacity.Value = sCapacity;
prmsCapacity.Direction = ParameterDirection.Input;
lstParametros.Add(prmsCapacity);
DbParameter prmsMaterial = new SqlParameter();
prmsMaterial.DbType = DbType.String;
prmsMaterial.ParameterName = "@sMaterial";
prmsMaterial.Value = sMaterial;
prmsMaterial.Direction = ParameterDirection.Input;
lstParametros.Add(prmsMaterial);
DbParameter prmsUnit = new SqlParameter();
prmsUnit.DbType = DbType.String;
prmsUnit.ParameterName = "@sUnit";
prmsUnit.Value = sUnit;
prmsUnit.Direction = ParameterDirection.Input;
lstParametros.Add(prmsUnit);
DbParameter prmsAsign_type = new SqlParameter();
prmsAsign_type.DbType = DbType.String;
prmsAsign_type.ParameterName = "@sAsign_type";
prmsAsign_type.Value = sAsign_type;
prmsAsign_type.Direction = ParameterDirection.Input;
lstParametros.Add(prmsAsign_type);
DbParameter prmsAquisition_type = new SqlParameter();
prmsAquisition_type.DbType = DbType.String;
prmsAquisition_type.ParameterName = "@sAcquisition_type";
prmsAquisition_type.Value = sAquisition_type;
prmsAquisition_type.Direction = ParameterDirection.Input;
lstParametros.Add(prmsAquisition_type);
DbParameter prmsStatus = new SqlParameter();
prmsStatus.DbType = DbType.Boolean;
prmsStatus.ParameterName = "@sStatus";
prmsStatus.Value = sStatus;
prmsStatus.Direction = ParameterDirection.Input;
lstParametros.Add(prmsStatus);
DbParameter prmsActive_desc = new SqlParameter();
prmsActive_desc.DbType = DbType.String;
prmsActive_desc.ParameterName = "@sActive_desc";
prmsActive_desc.Value = sActive_desc;
prmsActive_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsActive_desc);
DbParameter prmdRegister_time = new SqlParameter();
prmdRegister_time.DbType = DbType.DateTime;
prmdRegister_time.ParameterName = "@dRegister_time";
prmdRegister_time.Value = dRegister_time;
prmdRegister_time.Direction = ParameterDirection.Input;
lstParametros.Add(prmdRegister_time);
DbParameter prmiUtilTime = new SqlParameter();
prmiUtilTime.DbType = DbType.DateTime;
prmiUtilTime.ParameterName = "@iUtilTime";
prmiUtilTime.Value = iUtilTime;
prmiUtilTime.Direction = ParameterDirection.Input;
lstParametros.Add(prmiUtilTime);
DbParameter prmdtBuy_time = new SqlParameter();
prmdtBuy_time.DbType = DbType.DateTime;
prmdtBuy_time.ParameterName = "@dtBuy_time";
prmdtBuy_time.Value = dtBuy_time;
prmdtBuy_time.Direction = ParameterDirection.Input;
lstParametros.Add(prmdtBuy_time);
DbParameter prmiHeihgt = new SqlParameter();
prmiHeihgt.DbType = DbType.Decimal;
prmiHeihgt.ParameterName = "@iHeihgt";
prmiHeihgt.Value = iHeihgt;
prmiHeihgt.Direction = ParameterDirection.Input;
lstParametros.Add(prmiHeihgt);
DbParameter prmiWidth = new SqlParameter();
prmiWidth.DbType = DbType.Decimal;
prmiWidth.ParameterName = "@iWidth";
prmiWidth.Value = iWidth;
prmiWidth.Direction = ParameterDirection.Input;
lstParametros.Add(prmiWidth);
DbParameter prmiWide = new SqlParameter();
prmiWide.DbType = DbType.Decimal;
prmiWide.ParameterName = "@iWide";
prmiWide.Value = iWide;
prmiWide.Direction = ParameterDirection.Input;
lstParametros.Add(prmiWide);
DbParameter prmiDiameter = new SqlParameter();
prmiDiameter.DbType = DbType.Decimal;
prmiDiameter.ParameterName = "@iDiameter";
prmiDiameter.Value = iDiameter;
prmiDiameter.Direction = ParameterDirection.Input;
lstParametros.Add(prmiDiameter);
DbParameter prmiBuy_price = new SqlParameter();
prmiBuy_price.DbType = DbType.Decimal;
prmiBuy_price.ParameterName = "@iBuy_price";
prmiBuy_price.Value = iBuy_price;
prmiBuy_price.Direction = ParameterDirection.Input;
lstParametros.Add(prmiBuy_price);
DbParameter prmiDivNumber = new SqlParameter();
prmiDivNumber.DbType = DbType.Int32;
prmiDivNumber.ParameterName = "@iDivNumber";
prmiDivNumber.Value = iDivNumber;
prmiDivNumber.Direction = ParameterDirection.Input;
lstParametros.Add(prmiDivNumber);
SQLConexion conProxy=new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "dbo.sp_tblActives_Update");
}
public int Insert(
string sConfirmed_desc,
string sAsign_desc,
bool bStatus,
DateTime dtAsign_date,
DateTime dtDevolution_date,
bool bConfirmed,
int iPerson_id,
int iActive_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmCod = new SqlParameter();
prmCod.DbType = DbType.Int32;
prmCod.ParameterName = "@id";
prmCod.Direction = ParameterDirection.Output;
lstParametros.Add(prmCod);
DbParameter prmsConfirmed_desc = new SqlParameter();
prmsConfirmed_desc.DbType = DbType.String;
prmsConfirmed_desc.ParameterName = "@sConfirmed_desc";
prmsConfirmed_desc.Value = sConfirmed_desc;
prmsConfirmed_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsConfirmed_desc);
DbParameter prmsAsign_desc = new SqlParameter();
prmsAsign_desc.DbType = DbType.String;
prmsAsign_desc.ParameterName = "@sAsign_desc";
prmsAsign_desc.Value = sAsign_desc;
prmsAsign_desc.Direction = ParameterDirection.Input;
lstParametros.Add(prmsAsign_desc);
DbParameter prmbStatus = new SqlParameter();
prmbStatus.DbType = DbType.Boolean;
prmbStatus.ParameterName = "@bStatus";
prmbStatus.Value = bStatus;
prmbStatus.Direction = ParameterDirection.Input;
lstParametros.Add(prmbStatus);
DbParameter prmdtAsign_date = new SqlParameter();
prmdtAsign_date.DbType = DbType.DateTime;
prmdtAsign_date.ParameterName = "@dtAsign_date";
prmdtAsign_date.Value = dtAsign_date;
prmdtAsign_date.Direction = ParameterDirection.Input;
lstParametros.Add(prmdtAsign_date);
DbParameter prmdtDevolution_date = new SqlParameter();
prmdtDevolution_date.DbType = DbType.DateTime;
prmdtDevolution_date.ParameterName = "@dtDevolution_date";
prmdtDevolution_date.Value = dtDevolution_date;
prmdtDevolution_date.Direction = ParameterDirection.Input;
lstParametros.Add(prmdtDevolution_date);
DbParameter prmbConfirmed = new SqlParameter();
prmbConfirmed.DbType = DbType.Boolean;
prmbConfirmed.ParameterName = "@bConfirmed";
prmbConfirmed.Value = bConfirmed;
prmbConfirmed.Direction = ParameterDirection.Input;
lstParametros.Add(prmbConfirmed);
DbParameter prmiPerson_id = new SqlParameter();
prmiPerson_id.DbType = DbType.Int16;
prmiPerson_id.ParameterName = "@iPerson_id";
prmiPerson_id.Value = iPerson_id;
prmiPerson_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiPerson_id);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_AsigResponsibleActive_Insert"))
return Convert.ToInt32(prmCod.Value);
return -1;
}
public int Insert(
string sPerson_name,
string sPerson_lname,
string sPerson_dni,
string sPerson_phone,
string sPerson_email,
string sUsername,
string sPassword,
int iRol_id,
DateTime dtStart_time,
DateTime dtEnd_time,
int sStatus)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmId = new SqlParameter();
prmId.DbType = DbType.Int32;
prmId.ParameterName = "@id";
prmId.Direction = ParameterDirection.Output;
lstParametros.Add(prmId);
DbParameter prmsPerson_lname = new SqlParameter();
prmsPerson_lname.DbType = DbType.String;
prmsPerson_lname.ParameterName = "@sPerson_lname";
prmsPerson_lname.Value = sPerson_lname;
prmsPerson_lname.Direction = ParameterDirection.Input;
lstParametros.Add(prmsPerson_lname);
DbParameter prmsPerson_name = new SqlParameter();
prmsPerson_name.DbType = DbType.String;
prmsPerson_name.ParameterName = "@sPerson_name";
prmsPerson_name.Value = sPerson_name;
prmsPerson_name.Direction = ParameterDirection.Input;
lstParametros.Add(prmsPerson_name);
DbParameter prmsStatus = new SqlParameter();
prmsStatus.DbType = DbType.Int32;
prmsStatus.ParameterName = "@sStatus";
prmsStatus.Value = Convert.ToInt32(sStatus);
prmsStatus.Direction = ParameterDirection.Input;
lstParametros.Add(prmsStatus);
DbParameter prmsPerson_dni = new SqlParameter();
prmsPerson_dni.DbType = DbType.String;
prmsPerson_dni.ParameterName = "@sPerson_dni";
prmsPerson_dni.Value = sPerson_dni;
prmsPerson_dni.Direction = ParameterDirection.Input;
lstParametros.Add(prmsPerson_dni);
DbParameter prmsPerson_phone = new SqlParameter();
prmsPerson_phone.DbType = DbType.String;
prmsPerson_phone.ParameterName = "@sPerson_phone";
prmsPerson_phone.Value = sPerson_phone;
prmsPerson_phone.Direction = ParameterDirection.Input;
lstParametros.Add(prmsPerson_phone);
DbParameter prmsPerson_email = new SqlParameter();
prmsPerson_email.DbType = DbType.String;
prmsPerson_email.ParameterName = "@sPerson_email";
prmsPerson_email.Value = sPerson_email;
prmsPerson_email.Direction = ParameterDirection.Input;
lstParametros.Add(prmsPerson_email);
DbParameter prmsUsername = new SqlParameter();
prmsUsername.DbType = DbType.String;
prmsUsername.ParameterName = "@sUsername";
prmsUsername.Value = sUsername;
prmsUsername.Direction = ParameterDirection.Input;
lstParametros.Add(prmsUsername);
DbParameter prmsPassword = new SqlParameter();
prmsPassword.DbType = DbType.String;
prmsPassword.ParameterName = "@sPassword";
prmsPassword.Value = sPassword;
prmsPassword.Direction = ParameterDirection.Input;
lstParametros.Add(prmsPassword);
DbParameter prmiRol_id = new SqlParameter();
prmiRol_id.DbType = DbType.Int32;
prmiRol_id.ParameterName = "@iRol_id";
prmiRol_id.Value = iRol_id;
prmiRol_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiRol_id);
DbParameter prmdtStart_time = new SqlParameter();
prmdtStart_time.DbType = DbType.DateTime;
prmdtStart_time.ParameterName = "@dtStart_time";
prmdtStart_time.Value = dtStart_time;
prmdtStart_time.Direction = ParameterDirection.Input;
lstParametros.Add(prmdtStart_time);
DbParameter prmdtEnd_time = new SqlParameter();
prmdtEnd_time.DbType = DbType.DateTime;
prmdtEnd_time.ParameterName = "@dtEnd_time";
prmdtEnd_time.Value = dtEnd_time;
prmdtEnd_time.Direction = ParameterDirection.Input;
lstParametros.Add(prmdtEnd_time);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblResponsibles_Insert"))
return Convert.ToInt32(prmId.Value);
return -1;
}
public int Insert(string name, string desc, bool estado, int subarea)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iLocation_id";
prmA.Direction = ParameterDirection.Output;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.String;
prmB.ParameterName = "@sLocation_name";
prmB.Value = name;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
DbParameter prmC = new SqlParameter();
prmC.DbType = DbType.String;
prmC.ParameterName = "@sLocation_desc";
prmC.Value = desc;
prmC.Direction = ParameterDirection.Input;
lstParametros.Add(prmC);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.Boolean;
prmD.ParameterName = "@sStatus";
prmD.Value = estado;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
DbParameter prmE = new SqlParameter();
prmE.DbType = DbType.Int32;
prmE.ParameterName = "@iSubArea_id";
prmE.Value = subarea;
prmE.Direction = ParameterDirection.Input;
lstParametros.Add(prmE);
SQLConexion conProxy = new SQLConexion();
if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblLocations_Insert"))
return Convert.ToInt32(prmA.Value);
return -1;
}
//public int Insert(string name, string desc, bool stado, int subarea, SqlTransaction transaccion)
// {
// List<DbParameter> lstParametros = new List<DbParameter>();
// DbParameter prmA = new SqlParameter();
// prmA.DbType = DbType.Int32;
// prmA.ParameterName = "@iLocation_id";
// prmA.Direction = ParameterDirection.Output;
// lstParametros.Add(prmA);
// DbParameter prmB = new SqlParameter();
// prmB.DbType = DbType.String;
// prmB.ParameterName = "@sLocation_name";
// prmB.Value = name;
// prmB.Direction = ParameterDirection.Input;
// lstParametros.Add(prmB);
// DbParameter prmC = new SqlParameter();
// prmC.DbType = DbType.String;
// prmC.ParameterName = "@sLocation_desc";
// prmC.Value = desc;
// prmC.Direction = ParameterDirection.Input;
// lstParametros.Add(prmC);
// DbParameter prmD = new SqlParameter();
// prmD.DbType = DbType.Int32;
// prmD.ParameterName = "@sStatus";
// prmD.Value = stado;
// prmD.Direction = ParameterDirection.Input;
// lstParametros.Add(prmD);
// DbParameter prmE = new SqlParameter();
// prmE.DbType = DbType.String;
// prmE.ParameterName = "@iSubArea_id";
// prmE.Value = subarea;
// prmE.Direction = ParameterDirection.Input;
// lstParametros.Add(prmE);
// SQLConexion conProxy = new SQLConexion();
// if (conProxy.EjecutarDML(lstParametros, "dbo.sp_tblLocations_Insert", transaccion))
// return Convert.ToInt32(prmA.Value);
// return -1;
// }
public bool Actualizar(int codigo, string name, string desc, bool stado, int subarea)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iLocation_id";
prmA.Value = codigo;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
DbParameter prmB = new SqlParameter();
prmB.DbType = DbType.String;
prmB.ParameterName = "@sLocation_name";
prmB.Value = name;
prmB.Direction = ParameterDirection.Input;
lstParametros.Add(prmB);
DbParameter prmC = new SqlParameter();
prmC.DbType = DbType.String;
prmC.ParameterName = "@sLocation_desc";
prmC.Value = desc;
prmC.Direction = ParameterDirection.Input;
lstParametros.Add(prmC);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.Boolean;
prmD.ParameterName = "@sStatus";
prmD.Value = stado;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
DbParameter prmE = new SqlParameter();
prmE.DbType = DbType.Int32;
prmE.ParameterName = "@iSubArea_id";
prmE.Value = subarea;
prmE.Direction = ParameterDirection.Input;
lstParametros.Add(prmE);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarDML(lstParametros, "sp_tblLocations_Update");
}