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)); }