public bool SaveSalesReturnVoucherItems(eSunSpeedDomain.Item_VoucherModel objSalesItem) { string Query = string.Empty; bool isSaved = true; objSalesItem.ParentId = GetSalesVoucherId(); try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@SalesReturnVoucher_ID", objSalesItem.ParentId)); paramCollection.Add(new DBParameter("@SalesReturn_Item", objSalesItem.Item)); paramCollection.Add(new DBParameter("@SalesReturn_Qty", objSalesItem.Qty)); paramCollection.Add(new DBParameter("@SalesReturn_Unit", objSalesItem.Qty)); paramCollection.Add(new DBParameter("@SalesReturn_Price", objSalesItem.Price)); paramCollection.Add(new DBParameter("@SalesReturn_Amount", objSalesItem.Amount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO SalesReturnItem_Voucher([SalesReturnVoucher_ID],[SalesReturn_Item],[SalesReturn_Qty],[SalesReturn_Unit]," + "[SalesReturn_Price],[SalesReturn_Amount],[CreatedBy]) VALUES " + "(@SalesReturnVoucher_ID,@SalesReturn_Item,@SalesReturn_Qty,@SalesReturn_Unit,@SalesReturn_Price,@SalesReturn_Amount,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
public bool UpdateSalesVoucherItems(eSunSpeedDomain.Item_VoucherModel objSalesItem) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Sales_Item", objSalesItem.Item)); paramCollection.Add(new DBParameter("@Sales_Qty", objSalesItem.Qty)); paramCollection.Add(new DBParameter("@Sales_Unit", objSalesItem.Qty)); paramCollection.Add(new DBParameter("@Sales_Price", objSalesItem.Price)); paramCollection.Add(new DBParameter("@Sales_Amount", objSalesItem.Amount)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@SalesVoucher_ID", objSalesItem.ParentId)); paramCollection.Add(new DBParameter("@SalesItem_ID", objSalesItem.Item_ID)); Query = "UPDATE SalesItem_Voucher SET [Sales_Item]=@Sales_Item,[Sales_Qty]=@Sales_Qty,[Sales_Unit]=@Sales_Unit," + "[Sales_Price]=@Sales_Price,[Sales_Amount]=@Sales_Amount,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + "WHERE SalesVoucher_ID=@SalesVoucher_ID AND [SalesItem_ID]=@SalesItem_ID"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }