private bool DeletePurchaseBillItemReturn(Entities.PurchaseBillReturnItem purchaseBillReturnItem, DbTransaction dbTransaction)
{
var isDeleted = true;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeletePurchaseBillItemReturn))
{
database.AddInParameter(dbCommand, "@purchase_bill_item_return_id", DbType.Int32, purchaseBillReturnItem.PurchaseBillItemReturnId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, purchaseBillReturnItem.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, purchaseBillReturnItem.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand, dbTransaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(isDeleted);
}
private Int32 AddPurchaseBillItemReturn(Entities.PurchaseBillReturnItem purchaseBillReturnItem, DbTransaction dbTransaction)
{
var purchaseBillItemReturnId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertPurchaseBillItemReturn))
{
database.AddInParameter(dbCommand, "@purchase_bill_item_return_id", DbType.Int32, purchaseBillReturnItem.PurchaseBillItemReturnId);
database.AddInParameter(dbCommand, "@purchase_bill_return_id", DbType.Int32, purchaseBillReturnItem.PurchaseBillReturnId);
database.AddInParameter(dbCommand, "@purchase_bill_item_id", DbType.Int32, purchaseBillReturnItem.PurchaseBillItemId);
database.AddInParameter(dbCommand, "@drug_id", DbType.Int32, purchaseBillReturnItem.DrugId);
database.AddInParameter(dbCommand, "@return_qty", DbType.Decimal, purchaseBillReturnItem.ReturnQty);
database.AddInParameter(dbCommand, "@created_by", DbType.Int32, purchaseBillReturnItem.CreatedBy);
database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, purchaseBillReturnItem.CreatedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
purchaseBillItemReturnId = database.ExecuteNonQuery(dbCommand, dbTransaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
purchaseBillItemReturnId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(purchaseBillItemReturnId);
}
public List <Entities.PurchaseBillReturnItem> GetPurchaseBillItemReturnDetailsByPurchaseBillReturnId(Int32 purchaseBillReturnId)
{
var purchaseBillItemsReturn = new List <Entities.PurchaseBillReturnItem>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPurchaseBillItemReturnDetailsByReturnId))
{
database.AddInParameter(dbCommand, "@purchase_bill_return_id", DbType.Int32, purchaseBillReturnId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var purchaseBillItemReturn = new Entities.PurchaseBillReturnItem
{
PurchaseBillItemReturnId = DRE.GetNullableInt32(reader, "purchase_bill_item_return_id", null),
PurchaseBillItemId = DRE.GetNullableInt32(reader, "purchase_bill_item_id", null),
PurchaseBillId = DRE.GetNullableInt32(reader, "purchase_bill_id", 0),
DrugId = DRE.GetNullableInt32(reader, "drug_id", null),
DrugCode = DRE.GetNullableInt32(reader, "drug_code", null),
DrugName = DRE.GetNullableString(reader, "drug_name", null),
PurchaseQty = DRE.GetNullableDecimal(reader, "free_qty", null),
ReturnQty = DRE.GetNullableDecimal(reader, "rate_per_pack_1", null)
};
purchaseBillItemsReturn.Add(purchaseBillItemReturn);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(purchaseBillItemsReturn);
}
public Int32 SavePurchaseBillItemReturn(Entities.PurchaseBillReturnItem purchaseBillReturnItem, DbTransaction dbTransaction)
{
var purchaseBillItemReturnId = 0;
if (purchaseBillReturnItem.PurchaseBillItemReturnId == null || purchaseBillReturnItem.PurchaseBillItemReturnId == 0)
{
purchaseBillItemReturnId = AddPurchaseBillItemReturn(purchaseBillReturnItem, dbTransaction);
}
else if (purchaseBillReturnItem.IsDeleted == true)
{
var result = DeletePurchaseBillItemReturn(purchaseBillReturnItem, dbTransaction);
if (result == true)
{
purchaseBillItemReturnId = (int)purchaseBillReturnItem.PurchaseBillItemReturnId;
}
}
else if (purchaseBillReturnItem.ModifiedBy > 0)
{
purchaseBillItemReturnId = UpdatePurchaseBillItemReturn(purchaseBillReturnItem, dbTransaction);
}
return(purchaseBillItemReturnId);
}
