public List <Entities.PurchaseBillReturn> SearchPurchaseBillsReturnAll(Entities.PurchaseBillReturn purchaseBillReturn) { var purchaseBillReturns = new List <Entities.PurchaseBillReturn>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchPurchaseBillsReturn)) { database.AddInParameter(dbCommand, "@purchase_bill_no", DbType.String, purchaseBillReturn.PurchaseBillNo); database.AddInParameter(dbCommand, "@working_period_id", DbType.Int32, purchaseBillReturn.WorkingPeriodId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var purchaseBillReturnItem = new PurchaseBillReturnItem(); var purchaseBillReturnInfo = new Entities.PurchaseBillReturn() { PurchaseBillReturnId = DRE.GetNullableInt32(reader, "purchase_bill_return_id", null), PurchaseBillId = DRE.GetNullableInt32(reader, "purchase_bill_id", null), PurchaseBillNo = DRE.GetNullableString(reader, "purchase_bill_no", null), PurchaseBillDate = DRE.GetNullableString(reader, "purchase_bill_date", null), VendorName = DRE.GetNullableString(reader, "vendor_name", null), PurchaseBillReturnDate = DRE.GetNullableString(reader, "purchase_bill_return_date", null), WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", null), PurchaseBillReturnItems = purchaseBillReturnItem.GetPurchaseBillItemReturnDetailsByPurchaseBillReturnId(DRE.GetInt32(reader, "purchase_bill_return_id")) }; purchaseBillReturns.Add(purchaseBillReturn); } } } } catch (Exception ex) { throw ex; } return(purchaseBillReturns); }
public Int32 SavePurchaseBillReturn(Entities.PurchaseBillReturn purchaseBillReturn) { var purchaseBillReturnId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction transaction = conn.BeginTransaction()) { try { var purchaseBillItemReturnId = 0; if (purchaseBillReturn != null) { if (purchaseBillReturn.PurchaseBillReturnId == null || purchaseBillReturn.PurchaseBillReturnId == 0) { purchaseBillReturnId = AddPurchaseBillReturn(purchaseBillReturn, transaction); } else { if (purchaseBillReturn.IsDeleted == true) { var result = DeletePurchaseBillReturn(purchaseBillReturn, transaction); purchaseBillReturnId = Convert.ToInt32(purchaseBillReturn.PurchaseBillReturnId); } else { if (purchaseBillReturn.ModifiedBy > 0 || purchaseBillReturn.ModifiedBy != null) { purchaseBillReturnId = UpdatePurchaseBillReturn(purchaseBillReturn, transaction); // If records failed to save if (purchaseBillReturnId < 0) { purchaseBillReturnId = -1; } } } } if (purchaseBillReturnId > 0) { if (purchaseBillReturn.IsDeleted == true) { PurchaseBillReturnItem dal = new PurchaseBillReturnItem(); var result = dal.DeletePurchaseBillItemReturnByPurchaseBillReturnId(purchaseBillReturnId, (int)purchaseBillReturn.DeletedBy, purchaseBillReturn.DeletedByIP, transaction); if (result) { purchaseBillReturnId = 1; } } // Save Purchase Bill Items Return if (purchaseBillReturn.PurchaseBillReturnItems != null) { if (purchaseBillReturn.PurchaseBillReturnItems.Count > 0) { foreach (Entities.PurchaseBillReturnItem purchaseBillItemReturn in purchaseBillReturn.PurchaseBillReturnItems) { purchaseBillItemReturn.PurchaseBillReturnId = purchaseBillReturnId; PurchaseBillReturnItem dal = new PurchaseBillReturnItem(); purchaseBillItemReturnId = dal.SavePurchaseBillItemReturn(purchaseBillItemReturn, transaction); // If records failed to save if (purchaseBillItemReturnId < 0) { purchaseBillReturnId = -1; } } } } } } if (purchaseBillReturnId > 0) { transaction.Commit(); } else { transaction.Rollback(); } } catch (Exception ex) { purchaseBillReturnId = -1; transaction.Rollback(); throw ex; } finally { db = null; } } } return(purchaseBillReturnId); }
public List <Entities.PurchaseBillReturnItem> GetPurchaseBillReturnItemDetailsByPurchaseBillId(Int32 purchaseBillId) { var purchaseBillItemReturn = new PurchaseBillReturnItem(); return(purchaseBillItemReturn.GetPurchaseBillReturnItemDetailsByPurchaseBillId(purchaseBillId)); }