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