public bool AddProductSoldDetails(ProductSoldDetails objPS)
{
bool result;
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
DbCommand command = database.GetStoredProcCommand("UDP_AddProductSoldDetails");
command.CommandType = CommandType.StoredProcedure;
database.AddInParameter(command, "@CustomerId", DbType.Int32, objPS.CustomerId);
database.AddInParameter(command, "@EstimateId", DbType.Int32, objPS.EstimateId);
database.AddInParameter(command, "@ProductTypeId", DbType.Int32, objPS.ProductTypeId);
database.AddInParameter(command, "@PaymentMode", DbType.String, objPS.PaymentMode);
database.AddInParameter(command, "@Amount", DbType.Decimal, objPS.Amount);
database.AddInParameter(command, "@Check_no", DbType.String, objPS.Check_no);
database.AddInParameter(command, "@CreditCard_no", DbType.String, objPS.CreditCard_no);
database.AddInParameter(command, "@ExpirationDate", DbType.Date, objPS.ExpirationDate);
database.AddInParameter(command, "@SecurityCode", DbType.String, objPS.SecurityCode);
database.AddOutParameter(command, "@result", DbType.Boolean, 1);
database.ExecuteNonQuery(command);
result = (bool)database.GetParameterValue(command, "@result");
}
}
catch (Exception ex)
{
result = false;
//LogManager.Instance.WriteToFlatFile(ex);
}
return(result);
}
public bool AddProductSoldDetails(ProductSoldDetails objPS)
{
return(shuttersDAL.Instance.AddProductSoldDetails(objPS));
}
