public int Add(BO.SaleAddBO saleAdd)
{
int _ID;
try
{
DatabaseAccess.OpenConnection(true);
var _ourParams = DatabaseAccess.ExecuteProcedureDML("P_Sale_AddUpdate", new List <DAL.DatabaseParameter>()
{
new DAL.DatabaseParameter("@ClientID", DAL.ParameterDirection.In, DAL.DataType.Int, saleAdd.ClientID),
new DAL.DatabaseParameter("@SaleID", DAL.ParameterDirection.InOut, DAL.DataType.Int, saleAdd.SaleID),
new DAL.DatabaseParameter("@DueDays", DAL.ParameterDirection.In, DAL.DataType.Int, saleAdd.DueDays),
new DAL.DatabaseParameter("@SaleDate", DAL.ParameterDirection.In, DAL.DataType.Date, saleAdd.SaleDate),
new DAL.DatabaseParameter("@Saller", DAL.ParameterDirection.In, DAL.DataType.Int, saleAdd.SallerID),
new DAL.DatabaseParameter("@Buyer", DAL.ParameterDirection.In, DAL.DataType.Int, saleAdd.BuyerID),
new DAL.DatabaseParameter("@TotalWeight", DAL.ParameterDirection.In, DAL.DataType.Decimal, saleAdd.TotalWeight),
new DAL.DatabaseParameter("@RejectionWeight", DAL.ParameterDirection.In, DAL.DataType.Decimal, saleAdd.RejectionWeight),
new DAL.DatabaseParameter("@UnitPrice", DAL.ParameterDirection.In, DAL.DataType.Decimal, saleAdd.UnitPrice),
new DAL.DatabaseParameter("@LessPer", DAL.ParameterDirection.In, DAL.DataType.Decimal, saleAdd.LessPer)
});
DatabaseAccess.CommitTransaction();
_ID = Convert.ToInt32(_ourParams["@SaleID"]);
_ourParams = null;
}
catch
{
DatabaseAccess.RollbackTransaction();
throw;
}
finally
{
DatabaseAccess.CloseConnection();
}
return(_ID);
}
public BO.SaleAddBO GetSaleDetails(int clientID, int saleID)
{
BO.SaleAddBO _saleAdd = null;
try
{
DatabaseAccess.OpenConnection();
using (DataSet _ds = DatabaseAccess.ExecuteProcedure("P_Sale_GetDetails", new List <DAL.DatabaseParameter>()
{
new DAL.DatabaseParameter("@SaleID", DAL.ParameterDirection.In, DAL.DataType.Int, saleID),
new DAL.DatabaseParameter("@ClientID", DAL.ParameterDirection.In, DAL.DataType.Int, clientID)
}))
{
if (_ds != null && _ds.Tables.Count > 0)
{
var _row = _ds.Tables[0].Rows[0];
_saleAdd = new BO.SaleAddBO()
{
SaleDate = Convert.ToDateTime(_row["SaleDate"]).ToString(BaseService.DefaultDateFormat),
SallerID = Convert.ToInt32(_row["SallerID"]),
BuyerID = Convert.ToInt32(_row["BuyerID"]),
DueDays = Convert.ToInt32(_row["DueDays"]),
TotalWeight = float.Parse(_row["Weight"].ToString()),
RejectionWeight = float.Parse(_row["RejectionWt"].ToString()),
UnitPrice = float.Parse(_row["UnitPrice"].ToString()),
LessPer = float.Parse(_row["LessPer"].ToString()),
Status = Convert.ToInt32(_row["Status"])
};
}
}
}
catch
{
throw;
}
finally
{
DatabaseAccess.CloseConnection();
}
return(_saleAdd);
}