public string Dao_InsertPayment(BoPayment pPayment)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdOrder", pPayment.LOrder.LIdOrder.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValuePayment", pPayment.LValuePayment.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pPayment.LStatus.LIdStatus);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pPayment.LObject.LIdObject.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertPayment", "spr_CreatePayment"));
}
public string Dao_UpdateInvoice(BoInvoice pInvoice)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoice", pInvoice.LCustomer.LIdCustomer.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@CdInvoice", pInvoice.LCdInvoice);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdCustomer", pInvoice.LCustomer.LIdCustomer.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pInvoice.LStatus.LIdStatus);
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranUpdateInvoice", "spr_UpdateInvoice"));
}
public string Dao_UpdateCustomer(BoCustomer pCustomer)
{
this.LListParams = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdCustomer", pCustomer.LIdCustomer.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@NameCustomer", pCustomer.LNameCustomer);
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@LastNameCustomer", pCustomer.LLastNameCustomer);
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdTypeIdentification", pCustomer.LTypeIdentification.LIdTypeIdentification.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@NoIdentification", pCustomer.LNoIdentification);
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@IdStatus", pCustomer.LStatus.LIdStatus);
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParams, "LTranUpdateCustomer", "spr_UpdateCustomer"));
}
public string Dao_InsertProduct(BoProduct pProduct)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@NameProduct", pProduct.LNameProduct);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@CdProduct", pProduct.LCdProduct);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdUnit", pProduct.LUnit.LIdUnit.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@Price", pProduct.LValue.ToString(CultureInfo.CurrentCulture));
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdSupplier", pProduct.LSupplier.LIdSupplier.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@PriceSupplier", pProduct.LValueSupplier.ToString(CultureInfo.CurrentCulture));
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pProduct.LStatus.LIdStatus);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pProduct.LObject.LIdObject.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertProduct", "spr_CreateProduct"));
}
public string Dao_DeleteCustomer(BoCustomer pCustomer)
{
this.LListParams = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdCustomer", pCustomer.LIdCustomer.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParams, "LTranDeleteCustomer", "spr_DeleteCustomer"));
}
public string Dao_DeletePayment(BoPayment pPayment)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdPayment", pPayment.LIdPayment.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeletePayment", "spr_DeletePayment"));
}
public string Dao_DeleteInvoice(BoInvoice pInvoice)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoice", pInvoice.LIdInvoice.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeleteInvoice", "spr_DeleteInvoice"));
}