public void InsertStoreIssueVoucher()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "AddStoreIssueVoucher", SRID, GRNID, SIVNo, WorkUnitID, ItemID, RequestedQuantity, IssuedQuantity, UnitPrice, Remark, Status, IssuedBy, IssuedDate, IssuedTo, ApprovedBy, ApprovedDate, CreatedBy, CreatedDate);
//SQLHelper.ExecuteSP(ConnectionString, "AddStoreIssueVoucher", this);
}
public void InsertPurchaseRequest()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "AddPurchaseRequest", PRNo, SRID, WorkUnitID, ItemID, Quantity, Purpose, Remark, Status,
RequestedBy, RequestedDate, ApprovedBy, ApprovedDate, CreatedBy, CreatedDate, RequestTypeID);
//SQLHelper.ExecuteSP(ConnectionString, "AddPurchaseRequest", this);
}
public void InsertFARN()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "AddFARN", FARNNo, ItemID, PRID, SuppliedBy, SupplierPhone, SupplierEmail, InvoiceNo, Location, Quantity, UnitPrice, Remark, Status,
ReceivedBy, ReceivedDate, DeliveredBy, DeliveredDate, VerifiedBy, VerifiedDate, CreatedBy, CreatedDate, RefNo, RefDate, Model);
//SQLHelper.ExecuteSP(ConnectionString, "AddFARN", this);
}
public void InsertMaintenance()
{
SQLHelper.ExecuteSP(ConnectionString, "AddMaintenance", FixedAssetID, CustodianID, MaintainedBy, MaintainanceDate, Problem, ServiceCost, SpareCost, Status, Remark, CreatedBy, CreatedDate);
}
public void approvePRs()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdatePRApprove", ID, Status, ApprovedDate, ApprovedStatus);
}
public void ApproveTM()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateTransferedMaterialApprove", ID, ApprovedDate, Status, ApprovedStatus);
//SQLHelper.ExecuteSP(ConnectionString, "UpdateTransferedMaterialApprove", ID, Status, ApprovedDate, ApprovedStatus);
}
public void CancelStoreRequest(Guid ID, Guid LastModifiedBy, DateTime LastModifiedDate)
{
SQLHelper.ExecuteSP(ConnectionString, "CancelStoreRequest", ID, LastModifiedBy, LastModifiedDate);
}
public void CancelBorrowedFixedAsset(Guid ID, Guid LastModifiedBy, DateTime LastModifiedDate)
{
SQLHelper.ExecuteSP(ConnectionString, "CancelBorrowedFixedAsset", ID, LastModifiedBy, LastModifiedDate);
}
public void UpdateFixedAssetCard()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateFixedAssetCard", ID, ItemID, BeginingQuantity, CurrentQuantity, Location, Remark, Status, LastModifiedBy, LastModifiedDate);
}
public void UpdateBINCard()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateBINCard", ID, ItemID, BeginingQuantity, MinOrderQuantity, CurrentQuantity, Location, ShelfNo, RankNo, Remark, Status, LastModifiedBy, LastModifiedDate);
}
public void UpdateReturnedMaterial()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdateReturnedMaterial", ID, Quantity, ConditionID, UnitCost, PIN, Reason, Remark, ReturnedBy, RecievedBy, RecievedDate, ApprovedBy, ApprovedDate, LastModifiedBy, LastModifiedDate);
}
public void CancelReturnedMaterial(Guid ID, Guid LastModifiedBy, DateTime LastModifiedDate)
{
SQLHelper.ExecuteSP(ConnectionString, "CancelReturnedMaterial", ID, LastModifiedBy, LastModifiedDate);
}
public void InsertReturnedMaterial()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "AddReturnedMaterial", FAIVID, ItemID, RMTNID, Quantity, ConditionID, UnitCost, PIN, Reason, Remark, Status, ReturnedBy, RecievedBy, RecievedDate, ApprovedBy, ApprovedDate, CreatedBy, CreatedDate, RMRNNo);
}
public void UpdateFixedAsset()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateFixedAsset", ID, ItemID, SNo, TagNo, RecievedFrom, RecievedDate, Cost, Remark, Location, LastModifiedBy, LastModifiedDate, Model);
}
public void InsertFixedAsset()
{
SQLHelper.ExecuteSP(ConnectionString, "AddFixedAsset", FARNID, FAIVID, ItemID, SNo, TagNo, RecievedFrom, RecievedDate, Cost, Remark, Location, Status, CreatedBy, CreatedDate, Model);
}
public void UpdateMaintenance()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateMaintenance", ID, CustodianID, MaintainedBy, MaintainanceDate, Problem, ServiceCost, SpareCost, Remark, LastModifiedBy, LastModifiedDate);
}
public void VerifyFARN()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateFARNApprove", ID, VerifiedDate, Status, VerifiedStatus);
}
public void CancelMaintenance(Guid ID, Guid LastModifiedBy, DateTime LastModifiedDate)
{
SQLHelper.ExecuteSP(ConnectionString, "CancelMaintenance", ID, LastModifiedBy, LastModifiedDate);
}
public void InsertBINCard()
{
SQLHelper.ExecuteSP(ConnectionString, "AddBINCard", ItemID, BeginingQuantity, MinOrderQuantity, CurrentQuantity, Location, ShelfNo, RankNo, Remark, Status, CreatedBy, CreatedDate);
}
public void UpdateFARN()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdateFARN", ID, ItemID, SuppliedBy, SupplierPhone, SupplierEmail, InvoiceNo, Location, Quantity, UnitPrice, Remark,
ReceivedBy, ReceivedDate, DeliveredBy, DeliveredDate, VerifiedBy, VerifiedDate, RefNo, RefDate, LastModifiedBy, LastModifiedDate, Model);
}
public void UpdateStoreIssueVoucher()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdateStoreIssueVoucher", ID, WorkUnitID, ItemID, RequestedQuantity, IssuedQuantity, UnitPrice, Remark, IssuedBy, IssuedDate, IssuedTo, ApprovedBy, ApprovedDate, LastModifiedBy, LastModifiedDate);
}
public void InsertFixedAssetCard()
{
SQLHelper.ExecuteSP(ConnectionString, "AddFixedAssetCard", ItemID, BeginingQuantity, CurrentQuantity, Location, Remark, Status, CreatedBy, CreatedDate);
}
public void CancelStoreIssueVoucher(Guid ID, Guid LastModifiedBy, DateTime LastModifiedDate)
{
SQLHelper.ExecuteSP(ConnectionString, "CancelStoreIssueVoucher", ID, LastModifiedBy, LastModifiedDate);
}
public void UpdateBorrowedFixedAsset()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdateBorrowedFixedAsset", ID, RMID, ItemID, Returned, DispatchedFrom, DispatchedTo, DispatchingDate, ReturningDate, Reason, PreparedBy,
PreparedDate, CheckedBy, CheckedDate, ApprovedBy, ApprovedDate, ReceivedBy, ReceivedDate, ArrivalConfirmedBy, ArrivalConfirmedDate, LastModifiedBy, LastModifiedDate);
}
public void ApproveRM()
{
SQLHelper.ExecuteSP(ConnectionString, "UpdateSIVApprove", ID, ApprovedDate, Status, ApprovedStatus);
}
public void UpdateStoreRequest()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdateStoreRequest", ID, Type, WorkUnitID, ItemID, RequestTypeID, Quantity, Purpose, Remark,
StorekeeperAction, Status, RequestedBy, RequestedDate, ReviewedBy, ReviewedDate, ApprovedBy, ApprovedDate, LastModifiedBy, LastModifiedDate);
}
public void UpdatePurchaseRequest()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdatePurchaseRequest", ID, Quantity, Purpose, Remark, RequestedBy, RequestedDate, ApprovedBy, ApprovedDate, LastModifiedBy, LastModifiedDate);
}
public void ApproveSR()
{
//ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "UpdateSRApprove", ID, Status, ApprovedDate, ApprovedStatus);
}
public void InsertTransferedMaterial()
{
ResolveName();
SQLHelper.ExecuteSP(ConnectionString, "AddTransferedMaterial", RMRNID, FAIVID, ItemID, RMTNNo, Quantity, ConditionID, UnitCost, Reason, Remark, TransferredBy,
TransferredDate, TransferedTo, RecievedDate, ApprovedBy, ApprovedDate, Status, CreatedBy, CreatedDate);
}