public string bll_DeleteInvoice(int pIdInvoice)
{
var lInvoice = new BoInvoice {
LIdInvoice = pIdInvoice
};
return(this.LiDaoInvoice.Dao_DeleteInvoice(lInvoice));
}
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_InsertInvoice(BoInvoice pInvoice)
{
this.LListParam = new List <SqlParameter>();
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.Int, "@IdOrder", pInvoice.LOrder.LIdOrder.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pInvoice.LStatus.LIdStatus);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pInvoice.LObject.LIdObject.ToString());
return(DaoUtilsLib.Dao_executeSqlScalarWithProcedement(this.LListParam, "LTranInsertInvoice", "spr_CreateInvoice"));
}
public BoInvoice Dao_getInvoiceById(int pIdInvoice)
{
SqlConnection lConex = new SqlConnection();
using (lConex = DaoUtilsLib.Dao_SqlConnection(lConex))
{
var lInvoice = new BoInvoice();
try
{
var lCommand = new SqlCommand
{
CommandText = "spr_GetInvoice",
CommandTimeout = 30,
CommandType = CommandType.StoredProcedure,
Connection = lConex
};
lCommand.Parameters.Add(new SqlParameter("IdInvoice", pIdInvoice));
var lReader = lCommand.ExecuteReader();
if (lReader.HasRows)
{
while (lReader.Read())
{
lInvoice.LStatus = new BoStatus();
lInvoice.LObject = new BoObject();
lInvoice.LCustomer = new BoCustomer();
lInvoice.LListInvoiceItem = new List <BoInvoiceItem>();
lInvoice.LIdInvoice = Convert.ToInt32(lReader["IdInvoice"].ToString());
lInvoice.LCdInvoice = lReader["CdInvoice"].ToString();
lInvoice.LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString());
lInvoice.LCustomer.LIdCustomer = Convert.ToInt32(lReader["IdCustomer"].ToString());
lInvoice.LCustomer.LNameCustomer = lReader["NameCustomer"].ToString();
lInvoice.LCustomer.LLastNameCustomer = lReader["LastNameCustomer"].ToString();
lInvoice.LStatus.LIdStatus = lReader["IdStatus"].ToString();
lInvoice.LObject.LIdObject = Convert.ToInt32(lReader["IdObject"].ToString());
}
}
DaoUtilsLib.Dao_CloseSqlconnection(lConex);
return(lInvoice);
}
catch (Exception e)
{
lInvoice = new BoInvoice {
LException = e.Message
};
if (e.InnerException != null)
{
lInvoice.LInnerException = e.InnerException.ToString();
}
lInvoice.LMessageDao = BoErrors.MsgErrorGetSql;
DaoUtilsLib.Dao_CloseSqlconnection(lConex);
return(lInvoice);
}
}
}
public static MInvoice TrasferToMInvoice(this BoInvoice lBoInvoice)
{
var oMInvoice = new MInvoice
{
LIdInvoice = lBoInvoice.LIdInvoice,
LCdInvoice = lBoInvoice.LCdInvoice,
LCreationDate = lBoInvoice.LCreationDate,
LCustomer = new MCustomer
{
LIdCustomer = lBoInvoice.LCustomer.LIdCustomer,
LNameCustomer = lBoInvoice.LCustomer.LNameCustomer,
LLastNameCustomer = lBoInvoice.LCustomer.LLastNameCustomer
},
LListMInvoiceItem = lBoInvoice.LListInvoiceItem.MListInvoiceItem()
};
return(oMInvoice);
}
public string bll_UpdateInvoice(string pCdInvoice, int pIdCustomer, int pIdObject, string pIdStatus)
{
var lInvoice = new BoInvoice
{
LObject = new BoObject {
LIdObject = pIdObject
},
LStatus = new BoStatus {
LIdStatus = pIdStatus
},
LCustomer = new BoCustomer {
LIdCustomer = pIdCustomer
},
LCdInvoice = pCdInvoice
};
return(this.LiDaoInvoice.Dao_UpdateInvoice(lInvoice));
}
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"));
}
