// // GET: /Transfer/ public ActionResult Index() { Transfer srchTransfer = new Transfer { TransferCode = "", TransferDate = (DateTime) SqlDateTime.MinValue, FromBranch = 0, ToBranch = 0 }; List<Transfer> transferList = TransferManager.SearchTransfer(srchTransfer, "dini"); List<TransferModel> transferModelList = Utility.ConvetrToList<TransferModel, Transfer>(transferList); return View(); }
public static bool UpdateTransfer(Transfer transfer, string executedBy) { return TransferDAO.Update(transfer, executedBy); }
public static List<Transfer> SearchTransfer(Transfer transfer, string executedBy) { return TransferDAO.Search(transfer, executedBy); }
public static bool AddTransfer(Transfer transfer, string executedBy) { return TransferDAO.Insert(transfer, executedBy); }
public static bool Update(Transfer transfer, string executedBy) { bool rslt = false; try { Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection); DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Transfer_Update); connection = db.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); db.AddInParameter(cmd, "TransferID", DbType.Int32, transfer.TransferID); db.AddInParameter(cmd, "TransferDate", DbType.DateTime, transfer.TransferDate); db.AddInParameter(cmd, "FromBranch", DbType.Int32, transfer.FromBranch); db.AddInParameter(cmd, "ToBranch", DbType.Int32, transfer.ToBranch); db.AddInParameter(cmd, "IsReceived", DbType.Boolean, transfer.IsReceived); db.AddInParameter(cmd, "RecievedBy", DbType.Int32, transfer.RecievedBy); db.AddInParameter(cmd, "IsApproved", DbType.Boolean, transfer.IsApproved); db.AddInParameter(cmd, "ApprovedBy", DbType.Int32, transfer.ApprovedBy); db.AddInParameter(cmd, "UpdatedBY", DbType.Int32, transfer.UpdatedBY); db.AddInParameter(cmd, "LastUpdatedDate", DbType.Int32, transfer.UpdatedDate); db.ExecuteNonQuery(cmd, transaction); bool dtlUpdated; foreach (TransferDetail trDtl in transfer.TransferItems) { dtlUpdated = UpdateDetail(trDtl, transaction, executedBy); if (dtlUpdated == false) { throw new Exception("Failed to update transfer detail/s"); } } transaction.Commit(); rslt = true; } catch (Exception ex) { transaction.Rollback(); rslt = false; throw ex; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return rslt; }
public static List<Transfer> Search(Transfer srchTransfer, string executedBy) { List<Transfer> transferList = null; try { Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection); DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Transfer_Search); db.AddInParameter(cmd, "TransferCode", DbType.String, srchTransfer.TransferCode); db.AddInParameter(cmd, "TransferDate", DbType.DateTime, srchTransfer.TransferDate); db.AddInParameter(cmd, "FromBranch", DbType.Int32, srchTransfer.FromBranch); db.AddInParameter(cmd, "ToBranch", DbType.Int32, srchTransfer.ToBranch); DataSet ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { transferList = Utility.DataTableToCollection<Transfer>(ds.Tables[0]); } } catch (Exception ex) { transferList = null; } return transferList; }
public static bool Insert(Transfer transfer, string executedBy) { bool rslt = false; try { Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection); DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Transfer_Insert); connection = db.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); db.AddInParameter(cmd, "TransferDate", DbType.DateTime, transfer.TransferDate); db.AddInParameter(cmd, "FromBranch", DbType.Int32, transfer.FromBranch); db.AddInParameter(cmd, "ToBranch", DbType.Int32, transfer.ToBranch); //db.AddInParameter(cmd, "TransferDate", DbType.DateTime, transfer.IsReceived); db.AddInParameter(cmd, "IsApproved", DbType.Boolean, transfer.IsApproved); db.AddInParameter(cmd, "ApprovedBy", DbType.DateTime, transfer.ApprovedBy); db.AddInParameter(cmd, "CreatedBy", DbType.Int32, transfer.CreatedBy); db.AddOutParameter(cmd, "NewID", DbType.Int32, 4); db.ExecuteNonQuery(cmd, transaction); int newID = 0; int.TryParse(db.GetParameterValue(cmd, "NewID").ToString(), out newID); if (newID > 0) { bool dtlInserted; foreach (TransferDetail trDtl in transfer.TransferItems) { dtlInserted = InsertDetail(trDtl, transaction, executedBy); if (dtlInserted == false) { throw new Exception("Failed to insert transfer detail/s"); } } transaction.Commit(); rslt = true; } } catch (Exception ex) { transaction.Rollback(); rslt = false; throw ex; } finally { if(connection.State == ConnectionState.Open) { connection.Close(); } } return rslt; }