public List<WFResolution> GetListByRoleAndResolutionUS(PurchaseRequest obj)
{
if (!obj.AssignRole.HasValue)
return new List<WFResolution>();
var list = GetListResolutionChangeByRole(obj.AssignRole.Value);
if (obj.AssignRole == Constants.PR_REQUESTOR_ID_US)
{
if (obj.WFResolutionID == Constants.PRUS_RESOLUTION_REJECTED_TO_REQUESTOR)//case PR Reject
{
list = list.Where(p => p.ID != Constants.PRUS_RESOLUTION_REJECTED_TO_CORP_CTRLER).ToList<WFResolution>();
}
else if (obj.WFResolutionID == Constants.PRUS_RESOLUTION_REJECTED_TO_DEPT_HEAD)
{
list = list.Where(p => p.ID != Constants.PRUS_RESOLUTION_NEW &&
p.ID != Constants.PRUS_RESOLUTION_CANCELLED).ToList<WFResolution>();
}
else if (obj.WFResolutionID == Constants.PRUS_RESOLUTION_NEW)
{
list = list.Where(p => p.ID != Constants.PR_RESOLUTION_REJECT
&& p.ID != Constants.PRUS_RESOLUTION_REJECTED_TO_CORP_CTRLER &&
p.ID != Constants.PRUS_RESOLUTION_CANCELLED).ToList<WFResolution>();
}
else
{
list = list.Where(p => p.ID != Constants.PRUS_RESOLUTION_CANCELLED
&& p.ID != Constants.PRUS_RESOLUTION_REJECTED_TO_CORP_CTRLER).ToList<WFResolution>();
}
}
else if (obj.AssignRole == Constants.PR_PURCHASING_ID_US)
{
if (obj.WFResolutionID == Constants.PRUS_RESOLUTION_REJECTED_TO_DEPT_HEAD)
{
list = list.Where(p => p.ID == Constants.PRUS_RESOLUTION_WAITING_FOR_CORP_CTRLER_APPROVAL
|| p.ID == Constants.PRUS_RESOLUTION_REJECTED_TO_REQUESTOR
|| p.ID == Constants.PRUS_RESOLUTION_CANCELLED).ToList<WFResolution>();
}
else if (obj.WFResolutionID == Constants.PRUS_RESOLUTION_TO_BE_PROCESSED)
{
list = list.Where(p => p.ID == Constants.PRUS_RESOLUTION_TO_BE_PROCESSED).ToList<WFResolution>();
}
else
{
//case Requestor send PR to Group Purchasing
list = list.Where(p => p.ID == Constants.PRUS_RESOLUTION_WAITING_FOR_DEPT_HEAD_APPROVAL
|| p.ID == Constants.PRUS_RESOLUTION_REJECTED_TO_REQUESTOR
|| p.ID == Constants.PR_RESOLUTION_REJECT).ToList<WFResolution>();
}
}
else
{
list = new List<WFResolution>();
list.Add(obj.WFResolution);
}
return list;
}
// Methods
override public void ProcessRequest(
PurchaseRequest request )
{
if( request.Amount < 25000.0 )
Console.WriteLine( "{0} {1} approved request# {2}",
this, name, request.Number);
else
if( successor != null )
successor.ProcessRequest( request );
}
// Methods
override public void ProcessRequest(
PurchaseRequest request )
{
if( request.Amount < 100000.0 )
Console.WriteLine( "{0} {1} approved request# {2}",
this, name, request.Number);
else
Console.WriteLine( "Request# {0} requires " +
"an executive meeting!", request.Number );
}
private void btnRegistrarSolicitudCompra_Click(object sender, EventArgs e)
{
List <dynamic> lst = items.Select(x => new
{
idProduct = x.idProduct,
weight = x.weight,
remark = x.remark,
requiresRefrigeration = x.requieresRefrigerationBool
}).Cast <dynamic>().ToList();
//var lst1 = lst.Where(x => x.requieresRefrigeration == "Si").ToList();
if (lst.Count == 0)
{
string text = "Debe agregar productos para realizar esta acción";
string title = "Información";
MessageBox.Show(text, title, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string token = Session.Token;
int idClient = Session.IdProfile;
dynamic objectAPI = new System.Dynamic.ExpandoObject();
objectAPI.desiredDate = Convert.ToDateTime(dtpFechaDeseadaEntrega.Value);
//objectAPI.pruebaDate = DateTime.UtcNow.Subtract(new DateTime(dtpFechaDeseadaEntrega.Value,DateTimeKind.Utc)).TotalMilliseconds;
objectAPI.idClient = idClient;
objectAPI.idPurchaseRequestType = 1;
objectAPI.purchaseRequestProducts = lst;
var createNewPurchaseRequest = VirtualFairIntegration.CreateNewPurchaseRequest(token, objectAPI);
if (createNewPurchaseRequest.statusCode == 200)
{
string text = "Se deben completar todos los campos requeridos";
string title = "Información";
MessageBox.Show(text, title, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (createNewPurchaseRequest.statusCode == 201)
{
string text = createNewPurchaseRequest.message;
string title = "Información";
MessageBox.Show(text, title, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
var solicitudCompra = new PurchaseRequest();
solicitudCompra.Show();
}
}
}
public override void ProcessRequest(PurchaseRequest request)
{
if (request.Amount < 50000)
{
System.Console.WriteLine("Director {0} approve purchase request: {1}, Amount: {2}, purpose: {3}.", Name, request.Number, request.Amount, request.Purpose);
}
else
{
this.Successor.ProcessRequest(request);
}
}
public void addPurchaseRequest(string name, int price, int quantity)
{
PurchaseRequest pr = new PurchaseRequest();
pr.ItemName = name;
pr.ItemPrice = price;
pr.ItemQuantity = quantity;
pr.Deleted = 0;
db.PurchaseRequest.Add(pr);
db.SaveChanges();
}
public override void ProcessRequest(PurchaseRequest request)
{
if (request.Amount < 25000.0)
{
Console.WriteLine("{0}-{1} approved the request of purshing {2}", this, Name, request.ProductName);
}
else if (NextApprover != null)
{
NextApprover.ProcessRequest(request);
}
}
public override void ProcessRequest(PurchaseRequest request)
{
if (request.Amount < 100000.0)
{
Console.WriteLine("{0}-{1} approved the request of purshing {2}", this, Name, request.ProductName);
}
else
{
Console.WriteLine("Request需要组织一个会议讨论");
}
}
public static PurchaseRequest create(int departmentID, string information)
{
PurchaseRequest p = new PurchaseRequest();
p.DepartmentId = departmentID;
p.Information = information;
p.Date = DateTime.Now;
p.Status = "Pending";
p.Note = "";
return(p);
}
public IActionResult Purchase([FromBody] PurchaseRequest request)
{
try
{
var result = productsService.Purchase(request.ProductType, request.Coins.ToList());
return(new OkObjectResult(new PurchaseResponse(result, productsService.GetProducts())));
}
catch (ArgumentException ex)
{
return(new BadRequestObjectResult(new ValidationError(ex.Message)));
}
}
public void WhenPurchaseAnItem()
{
var requestBody = new PurchaseRequest
{
Item = "m",
PaymentTypeId = "adyenEPS",
Cuntry = "AT",
LandingUrl = "https://www.gametwist.com/en/?modal=shop"
};
PostRequestPurchase(requestBody);
}
public List<WFResolution> GetListByRoleAndResolution(PurchaseRequest obj)
{
if (!obj.AssignRole.HasValue)
return new List<WFResolution>();
var list = GetListResolutionChangeByRole(obj.AssignRole.Value);
if (obj.AssignRole == Constants.PR_REQUESTOR_ID)
{
if (obj.WFResolutionID == Constants.PR_RESOLUTION_REJECT)//case PR Reject
{
list = list.Where(p => p.ID != Constants.PR_RESOLUTION_NEW_ID &&
p.ID != Constants.PR_RESOLUTION_SR_MANAGER_REJECT_TO_REQUESTOR).ToList<WFResolution>();
}
else if (obj.WFResolutionID == Constants.PR_RESOLUTION_SR_MANAGER_REJECT_TO_REQUESTOR)
{
list = list.Where(p => p.ID != Constants.PR_RESOLUTION_NEW_ID &&
p.ID != Constants.PR_RESOLUTION_REJECT).ToList<WFResolution>();
}
else if (obj.WFResolutionID == Constants.PR_RESOLUTION_NEW_ID)
{
list = list.Where(p => p.ID != Constants.PR_RESOLUTION_REJECT
&& p.ID != Constants.PR_RESOLUTION_SR_MANAGER_REJECT_TO_REQUESTOR &&
p.ID != Constants.PR_RESOLUTION_CANCEL).ToList<WFResolution>();
}
else
{
list = list.Where(p => p.ID != Constants.PR_RESOLUTION_REJECT
&& p.ID != Constants.PR_RESOLUTION_SR_MANAGER_REJECT_TO_REQUESTOR).ToList<WFResolution>();
}
}
else if (obj.AssignRole == Constants.PR_PURCHASING_ID)
{
if (obj.WFResolutionID == Constants.PR_RESOLUTION_SR_MANAGER_REJECT_TO_PURCHASING)
{
list = list.Where(p => p.ID == Constants.PR_RESOLUTION_TO_BE_APPROVED_BY_SR_MANAGER
|| p.ID == Constants.PR_RESOLUTION_SR_MANAGER_REJECT_TO_PURCHASING
|| p.ID == Constants.PR_RESOLUTION_REJECT).ToList<WFResolution>();
}
else
{
//case Requestor send PR to Group Purchasing
list = list.Where(p => p.ID == Constants.PR_RESOLUTION_TO_BE_APPROVED_BY_PURCHASING
|| p.ID == Constants.PR_RESOLUTION_TO_BE_APPROVED_BY_SR_MANAGER
|| p.ID == Constants.PR_RESOLUTION_REJECT).ToList<WFResolution>();
}
}
else
{
list = new List<WFResolution>();
list.Add(obj.WFResolution);
}
return list;
}
public PurchaseResponse MakePurchase(PurchaseRequest purchaseRequest)
{
var purchaseResponse = new PurchaseResponse
{
CustomerId = purchaseRequest.CustomerId,
Price = 100,
Message = "Response",
Visits = 10
};
var streamWriter = new StreamWriter(@"C:\Temp\WS.log", true);
streamWriter.WriteLine(DateTime.Now + " " + purchaseRequest.CustomerId);
streamWriter.Close();
return purchaseResponse;
}
public static void Main(string[] args)
{
// https://developer.mastercard.com/portal/display/api/Software+Development+Kit
// http://newsroom.mastercard.com/2014/07/11/masterpass-continues-global-expansion-product-enhancements-planned-for-august/
{
//FullName = System.Reflection.TargetInvocationException, InnerException = System.IO.FileNotFoundException: The JVM/ CLR feature is not available within this build.
System.Console.WriteLine(
typeof(object).AssemblyQualifiedName
);
// jsc java natives/ where is the ctor we think of?
PaymentClient client = new PaymentClient(getPrivateKey(), "my-client-id", false);
PurchaseRequest purchaseRequest = new PurchaseRequest();
Amount amount = new Amount();
amount.setCurrency("GBP");
amount.setValue(new BigInteger("441250"));
purchaseRequest.setAmount(amount);
MerchantIdentity merchantIdentity = new MerchantIdentity();
merchantIdentity.setClientId("my-merchant-id");
merchantIdentity.setPassword("my-merchant-password");
purchaseRequest.setMerchantIdentity(merchantIdentity);
purchaseRequest.setClientReference(getClientReference());
Card card = new Card();
card.setAccountNumber("6XXXXXXXXXXXXXXX");
card.setExpiryMonth("01");
card.setExpiryYear("11");
card.setSecurityCode("111");
purchaseRequest.setFundingCard(card);
Purchase purchase = client.createPurchase(purchaseRequest);
CLRProgram.CLRMain();
}
}
public Error Validate(PurchaseRequest request)
{
if(!purchaseRepository.IsValidCustomer(request.customerId))
{
return new Error
{
Code = "1001",
Message = "Invalid Customer Id"
};
}
if(!purchaseRepository.IsValidProduct(request.productId))
{
return new Error
{
Code = "1002",
Message = "Invalid Product Id"
};
}
return null;
}
public bool IsInCCList(PurchaseRequest pr, string loginName)
{
int? result = dbContext.check_in_list_string(pr.CCList, loginName, Constants.SEPARATE_USER_ADMIN_USERNAME);
return result.HasValue ? result.Value == 1 ? true : false : false;
}
/// <summary>
/// Delete purchase request
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
private void Delete(PurchaseRequest objUI)
{
if (objUI != null)
{
// Get current group in dbContext
PurchaseRequest objDb = GetByID(objUI.ID);
if (objDb != null)
{
// Set delete info
objDb.DeleteFlag = true;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
// Submit changes to dbContext
dbContext.SubmitChanges();
}
}
}
/// <summary>
/// Write Insert Log For Employee
/// </summary>
/// <param name="objInfo"></param>
/// <param name="logId"></param>
public bool WriteLogForSetUpApproval(PurchaseRequest newInfo, List<PurchaseRequestApproval> listApproval, bool insertApproval)
{
bool isUpdated = false;
try
{
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.PurchaseRequest.ToString(), ELogAction.Update.ToString());
// Get old info
PurchaseRequest oldInfo = new PurchaseRequestDao().GetByID(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.WFResolutionID != oldInfo.WFResolutionID)
{
commonDao.InsertLogDetail(logId, "WFResolutionID", "Resolution", oldInfo.WFResolution.Name, new ResolutionDao().GetByID(newInfo.WFResolutionID).Name);
isUpdated = true;
}
if (newInfo.WFStatusID != oldInfo.WFStatusID)
{
commonDao.InsertLogDetail(logId, "WFStatusID", "Status", oldInfo.WFStatus.Name, new StatusDao().GetByID(newInfo.WFStatusID).Name);
isUpdated = true;
}
if (insertApproval)
{
foreach (PurchaseRequestApproval item in listApproval)
{
commonDao.InsertLogDetail(logId, "Approval", "Approval", string.Empty, new UserAdminDao().GetById(item.ApproverId).UserName +
" (" + new RoleDao().GetByID(item.ApproverGroup).Name + ")");
isUpdated = true;
}
}
else
{
if (newInfo.AssignRole != oldInfo.AssignRole || newInfo.AssignID != oldInfo.AssignID)
{
commonDao.InsertLogDetail(logId, "Assign", "Assign", oldInfo.UserAdmin.UserName + " (" + oldInfo.WFRole.Name + ")", ((newInfo.AssignID.HasValue ? new UserAdminDao().GetById(newInfo.AssignID.Value).UserName : string.Empty)
+ " (" + (newInfo.AssignRole.HasValue ? new RoleDao().GetByID(newInfo.AssignRole.Value).Name : string.Empty) + ")"));
isUpdated = true;
}
}
if (isUpdated)
{
// Insert Key Name
string key = Constants.PER_REVIEW_EFORM_MASTER_PREFIX + oldInfo.ID.ToString();
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
return isUpdated;
}
/// <summary>
/// Update setup approval
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <returns>Message</returns>
public Message UpdateForSetupApproval(PurchaseRequest objUI,List<PurchaseRequestApproval> listApproval,bool insertApproval)
{
Message msg = null;
try
{
if (objUI != null)
{
PurchaseRequest objDb = GetByID(objUI.ID);
if (objDb != null)
{
if (objDb.UpdateDate.ToString() == objUI.UpdateDate.ToString())
{
if (insertApproval)
{
InsertMultiApproval(listApproval);
}
new PurchaseRequestLogDao().WriteLogForSetUpApproval(objUI, listApproval, insertApproval);
objDb.WFResolutionID = objUI.WFResolutionID;
objDb.AssignID = objUI.AssignID;
objDb.AssignRole = objUI.AssignRole;
objDb.InvolveID = objUI.InvolveID;
objDb.InvolveRole = objUI.InvolveRole;
objDb.InvolveDate = objUI.InvolveDate;
objDb.InvolveResolution = objUI.InvolveResolution;
objDb.UpdateDate = DateTime.Now;
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'", "updated");
}
else
{
msg = new Message(MessageConstants.E0025, MessageType.Error, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'");
}
}
}
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Update setup approval
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <returns>Message</returns>
public Message UpdateForUSAccouting(PurchaseRequest objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
PurchaseRequest objDb = GetByID(objUI.ID);
if (objDb != null)
{
if (objDb.UpdateDate.ToString() == objUI.UpdateDate.ToString())
{
new PurchaseRequestLogDao().WriteLogForPurchasingConfirm(objUI);
objDb.WFResolutionID = objUI.WFResolutionID;
objDb.AssignID = objUI.AssignID;
objDb.AssignRole = objUI.AssignRole;
objDb.InvolveID = objUI.InvolveID;
objDb.InvolveRole = objUI.InvolveRole;
objDb.InvolveDate = objUI.InvolveDate;
objDb.InvolveResolution = objUI.InvolveResolution;
objDb.USAccounting = objUI.USAccounting;
objDb.WFStatusID = objUI.WFStatusID;
objDb.UpdateDate = DateTime.Now;
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'", "updated");
}
else
{
msg = new Message(MessageConstants.E0025, MessageType.Error, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'");
}
}
}
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Update confirm
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <param name="listInvoice">List<PurchaseInvoice></param>
/// <returns>Message</returns>
public Message UpdateConfirm(PurchaseRequest objUI, List<PurchaseInvoice> listInvoice)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
PurchaseRequest objDb = GetByID(objUI.ID);
if (objDb != null)
{
new PurchaseRequestLogDao().WriteLogForPurchasingConfirm(objUI);
objDb.PurchaseAppoval = objUI.PurchaseAppoval;
objDb.PaymentAppoval = objUI.PaymentAppoval;
if (objDb.WFResolutionID != 0 && objUI.WFResolutionID != 0)
objDb.WFResolutionID = objUI.WFResolutionID;
if (objDb.WFStatusID != 0 && objUI.WFStatusID != 0)
objDb.WFStatusID = objUI.WFStatusID;
objDb.AssignID = objUI.AssignID;
objDb.AssignRole = objUI.AssignRole;
objDb.InvolveID = objUI.InvolveID;
objDb.InvolveRole = objUI.InvolveRole;
objDb.InvolveDate = objUI.InvolveDate;
objDb.InvolveResolution = objUI.InvolveResolution;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
dbContext.SubmitChanges();
DeleteInvoices(objDb.ID);
InsertMultiInvoice(listInvoice);
msg = new Message(MessageConstants.I0001, MessageType.Info, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'", "updated");
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Update approval with comment
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <param name="objComment">PurchaseComment</param>
/// <returns>Message</returns>
public Message UpdateForApproval(PurchaseRequest objUI, PurchaseComment objComment)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (objUI != null)
{
PurchaseRequest objDb = GetByID(objUI.ID);
if (objDb != null)
{
#region Insert Comment
if (objComment != null && !string.IsNullOrEmpty(objComment.Contents))
{
PurchaseRequestCommentDao commentDao = new PurchaseRequestCommentDao();
commentDao.Insert(objComment);
}
#endregion
// Check valid update date
if (IsValidUpdateDate(objUI, objDb, out msg))
{
objDb.WFResolutionID = objUI.WFResolutionID;
objDb.AssignID = objUI.AssignID;
objDb.AssignRole = objUI.AssignRole;
objDb.InvolveID = objUI.InvolveID;
objDb.InvolveRole = objUI.InvolveRole;
objDb.InvolveDate = objUI.InvolveDate;
objDb.UpdateDate = DateTime.Now;
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, " Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'", "updated");
trans.Commit();
}
else
{
trans.Rollback();
}
}
}
}
catch
{
// Rollback transaction
if (trans != null)
{
trans.Rollback();
}
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
finally
{
if ((trans.Connection != null) && (trans.Connection.State == System.Data.ConnectionState.Open))
{
trans.Connection.Close();
}
}
return msg;
}
/// <summary>
/// Write Insert Log For Employee
/// </summary>
/// <param name="objInfo"></param>
/// <param name="logId"></param>
private void WriteInsertLogForPurchaseRequest(PurchaseRequest objInfo, string logId)
{
try
{
if ((objInfo != null) && (logId != null))
{
// Insert to Log Detail
commonDao.InsertLogDetail(logId, "ID", "ID", null, objInfo.ID.ToString());
commonDao.InsertLogDetail(logId, "WFStatusID", "Status", null, objInfo.WFStatus.Name);
commonDao.InsertLogDetail(logId, "WFResolutionID", "Resolution", null, objInfo.WFResolution.Name);
commonDao.InsertLogDetail(logId, "Requestor", "Requestor", null, objInfo.UserAdmin1.UserName);
commonDao.InsertLogDetail(logId, "RequestDate", "RequestDate", null, objInfo.RequestDate.ToString(Constants.DATETIME_FORMAT_VIEW));
if (objInfo.ExpectedDate.HasValue)
{
commonDao.InsertLogDetail(logId, "ExpectedDate", "Expected Date", null, objInfo.ExpectedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW));
}
commonDao.InsertLogDetail(logId, "SubDepartment", "Sub Department", null, objInfo.Department.DepartmentName);
commonDao.InsertLogDetail(logId, "Justification", "Justification", null, objInfo.Justification);
commonDao.InsertLogDetail(logId, "BillableToClient", "BillableToClient", null, objInfo.BillableToClient ? "Yes" : "No");
if (objInfo.Priority.HasValue)
{
commonDao.InsertLogDetail(logId, "Priority", "Priority", null, objInfo.Priority.Value == 1 ? "Urgent" : string.Empty);
}
if (!string.IsNullOrEmpty(objInfo.VendorName))
{
commonDao.InsertLogDetail(logId, "VendorName", "VendorName", null, objInfo.VendorName);
}
if (!string.IsNullOrEmpty(objInfo.VendorName))
{
commonDao.InsertLogDetail(logId, "VendorPhone", "VendorPhone", null, objInfo.VendorPhone);
}
if (!string.IsNullOrEmpty(objInfo.VendorName))
{
commonDao.InsertLogDetail(logId, "VendorEmail", "VendorEmail", null, objInfo.VendorEmail);
}
if (!string.IsNullOrEmpty(objInfo.VendorName))
{
commonDao.InsertLogDetail(logId, "VendorAddress", "VendorAddress", null, objInfo.VendorAddress);
}
commonDao.InsertLogDetail(logId, "MoneyType", "Money Type", null, objInfo.MoneyType == Constants.TYPE_MONEY_USD ? "USD" : "VND");
if (objInfo.OtherCost.HasValue)
{
commonDao.InsertLogDetail(logId, "OtherCost", "Other Cost", null, objInfo.OtherCost.Value.ToString());
}
if (!string.IsNullOrEmpty(objInfo.SaleTaxName))
{
commonDao.InsertLogDetail(logId, "SaleTaxName", "Sale Tax Name", null, objInfo.SaleTaxName);
}
if (objInfo.SaleTaxValue.HasValue)
{
commonDao.InsertLogDetail(logId, "SaleTaxValue", "Sale Tax Value", null, objInfo.SaleTaxValue.Value.ToString());
}
if (objInfo.Shipping.HasValue)
{
commonDao.InsertLogDetail(logId, "Shipping", "Shipping", null, objInfo.Shipping.Value.ToString());
}
if (objInfo.ServiceCharge.HasValue)
{
commonDao.InsertLogDetail(logId, "ServiceCharge", "Service Charge", null, objInfo.ServiceCharge.Value.ToString());
}
if (objInfo.Discount.HasValue)
{
commonDao.InsertLogDetail(logId, "Discount", "Discount", null, objInfo.Discount.Value.ToString());
}
if (!string.IsNullOrEmpty(objInfo.CCList))
{
commonDao.InsertLogDetail(logId, "CCList", "CCList", null, objInfo.CCList);
}
if (objInfo.AssignID.HasValue && objInfo.AssignRole.HasValue)
{
commonDao.InsertLogDetail(logId, "Assign", "Assign", null, objInfo.UserAdmin.UserName + " (" + objInfo.WFRole.Name + ")");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Write Insert Log For Employee
/// </summary>
/// <param name="objInfo"></param>
/// <param name="logId"></param>
public bool WriteLogForPurchasingConfirm(PurchaseRequest newInfo)
{
bool isUpdated = false;
try
{
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.PurchaseRequest.ToString(), ELogAction.Update.ToString());
// Get old info
PurchaseRequest oldInfo = new PurchaseRequestDao().GetByID(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.WFResolutionID != oldInfo.WFResolutionID)
{
commonDao.InsertLogDetail(logId, "WFResolutionID", "Resolution", oldInfo.WFResolution.Name, new ResolutionDao().GetByID(newInfo.WFResolutionID).Name);
isUpdated = true;
}
if (newInfo.AssignRole != oldInfo.AssignRole || newInfo.AssignID != oldInfo.AssignID)
{
commonDao.InsertLogDetail(logId, "Assign", "Assign", oldInfo.UserAdmin.UserName + " (" + oldInfo.WFRole.Name + ")", ((newInfo.AssignID.HasValue ? new UserAdminDao().GetById(newInfo.AssignID.Value).UserName : string.Empty)
+ " (" + (newInfo.AssignRole.HasValue ? new RoleDao().GetByID(newInfo.AssignRole.Value).Name : string.Empty) + ")"));
isUpdated = true;
}
if (!string.IsNullOrEmpty(newInfo.PurchaseAppoval) && newInfo.PurchaseAppoval != oldInfo.PurchaseAppoval)
{
commonDao.InsertLogDetail(logId, "PurchaseAppoval", "Purchase Appoval", oldInfo.PurchaseAppoval, newInfo.PurchaseAppoval);
isUpdated = true;
}
if (!string.IsNullOrEmpty(newInfo.PaymentAppoval) && newInfo.PaymentAppoval != oldInfo.PaymentAppoval)
{
commonDao.InsertLogDetail(logId, "PaymentAppoval", "Payment Appoval", oldInfo.PaymentAppoval, newInfo.PaymentAppoval);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = Constants.PER_REVIEW_EFORM_MASTER_PREFIX + oldInfo.ID.ToString();
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
return isUpdated;
}
public void RenderRfq(Stream stream, VendorModel vendor, IEnumerable<ItemModel> items, UserModel user, int RfqNumber, PurchaseRequest Pr, DateTime DateRequested)
{
Document document = new Document(PageSize.LETTER);
try {
PdfWriter writer = PdfWriter.GetInstance(document, stream);
document.Open();
// Create a page in the document and add it to the bottom layer
document.NewPage();
//Pass Document to this
CurrentDoc = document;
page = writer.DirectContentUnder;
page.BeginText();
int top = (int)document.GetTop(0);
SetFontSizeTo(16);
PrintText("REQUEST FOR QUOTATION (THIS IS NOT AN ORDER)", 20, 10);
SetFontSizeTo(10);
//Header
PrintText("Company Name: {0}".WithTokens(Pr.User.Company.Name), 20, 30); // Company Name
PrintText("Address: 8th Floor Gedisco Tower, 534 Asuncion St., Binondo, Manila", 20, 45); // Company Address
PrintText("Purchasing Department", 20, 60);
PrintText("Issued By: {0} {1}".WithTokens(user.FirstName, user.LastName), 20, 75); // Requested By
PrintTextRight("RFQ NO: {0}".WithTokens(RfqNumber), 70, 30); // RFQ Number
PrintTextRight("Date: {0}".WithTokens(DateTime.Now.ToShortDateString()), 70, 45); // Date Created
PrintTextRight("PR No: {0}".WithTokens(Pr.PRNo), 70, 60); // PR Number
//Body
SetFontSizeTo(14);
PrintText("BID/OFFER/QUOTE MUST BE RECEIVED BY:", 20, 105); // Requested By
PrintTextRight("Date: {0}".WithTokens(DateRequested.ToShortDateString()), 95, 105); // Date Required
SetFontSizeTo(10);
PrintText("Attention: {0} {1}".WithTokens(user.FirstName, user.LastName), 40, 125); // Vendor Contact Person
PrintText("Tel No: {0}".WithTokens("+63 2 244 9296"), 40, 140); // Vendor Tel No
PrintText("Email Address: {0}".WithTokens(user.Email), 40, 155); // Vendor Email
PrintText("Fax No: {0}".WithTokens("+63 2 241 7826"), 240, 125); // Vendor Fax No
SetFontSizeTo(8);
PrintText("Unless otherwise requested, quote on each item separately. Unit Prices shall be shown. If unable to furnish", 20, 175); // Vendor Email
PrintText("items as specified, submit sample and/or descriptive specifications of substitute offered.", 20, 185); // Vendor Email
//Items
SetFontSizeTo(8);
PrintText("_______________________________________________________________________________________________________________________", 20, 210);
PrintText("Item No.", 20, 205);
PrintText("Item Description", 70, 205);
PrintText("Quantity", 370, 205);
PrintText("Unit Price", 420, 205);
PrintText("Discount", 470, 205);
PrintText("Total", 520, 205);
//// Items..
//int staryY = 225;
//int itemCount = 1;
//foreach (var item in items) {
// PrintItem(itemCount.ToString(), item.Description, item.Quantity.ToString(), ref staryY);
// itemCount++;
//}
//PrintText("********** NOTHING FOLLOWS **********", 75, staryY + 15);
// START HERE ----------------------------
Paragraph Grid = new Paragraph("\n\n\n\n\n\n\n\n\n");
Grid.Alignment = 1;
Grid.SpacingAfter = 35f;
document.Add(Grid);
Paragraph Grid2 = new Paragraph();
Grid2.Alignment = 1;
Grid2.SpacingBefore = 35f;
//Start Table -----------------------------------
PdfPTable rightTable = new PdfPTable(7);
int[] widths = { 1, 1, 1, 7, 2, 2, 2 };
rightTable.SetWidths(widths);
rightTable.TotalWidth = 570f;
rightTable.LockedWidth = true;
Font tableFont = new Font(Font.FontFamily.HELVETICA, 8);
rightTable.HorizontalAlignment = Element.ALIGN_CENTER;
rightTable.AddCell(new Phrase("Item No.", tableFont));
rightTable.AddCell(new Phrase("Item Description", tableFont));
rightTable.AddCell(new Phrase("Quantity", tableFont));
rightTable.AddCell(new Phrase("Unit Price", tableFont));
rightTable.AddCell(new Phrase("Discount", tableFont));
rightTable.AddCell(new Phrase("Total Amount", tableFont));
rightTable.HorizontalAlignment = Element.ALIGN_LEFT;
int itemCount = 1;
foreach (var item in items) {
rightTable.AddCell(new Phrase(item.ItemNumber.ToString(), tableFont));
rightTable.AddCell(new Phrase(item.Description, tableFont));
rightTable.AddCell(new Phrase(item.Quantity.ToString(), tableFont));
rightTable.AddCell(new Phrase("", tableFont));
rightTable.AddCell(new Phrase("", tableFont));
rightTable.AddCell(new Phrase("", tableFont));
itemCount++;
}
//Nothing Follows
rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("******** NOTHING FOLLOWS ********", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase(""));
Grid2.Add(rightTable);
document.Add(Grid2);
// End of table -----------------------------------
// Footer
SetFontSizeTo(10);
PrintTextBottom("If accepted within _____ days, the undersigned offers and agrees to honor this quotation.", 20, 85);
PrintTextBottom("Print Name of Person:", 20, 65);
PrintTextBottom("Company Name:", 20, 50);
PrintTextBottom("Address:", 20, 35);
PrintTextBottom("Email Address:", 20, 20);
PrintTextBottom("No. of Days to Deliver:", 200, 65);
PrintTextBottom("Telephone No.:", 200, 50);
PrintTextBottom("Fax No.:", 200, 35);
page.EndText();
writer.Flush();
}
finally {
document.Close();
}
}
public static void Main( string[] args )
{
// Setup Chain of Responsibility
Director Larry = new Director( "Larry" );
VicePresident Sam = new VicePresident( "Sam" );
President Tammy = new President( "Tammy" );
Larry.SetSuccessor( Sam );
Sam.SetSuccessor( Tammy );
// Generate and process different requests
PurchaseRequest rs = new PurchaseRequest(
2034, 350.00, "Supplies" );
Larry.ProcessRequest( rs );
PurchaseRequest rx = new PurchaseRequest(
2035, 32590.10, "Project X" );
Larry.ProcessRequest( rx );
PurchaseRequest ry = new PurchaseRequest(
2036, 122100.00, "Project Y" );
Larry.ProcessRequest( ry );
}
public bool IsAssigned(PurchaseRequest pr, int userAdminID, int loginRole)
{
if ((pr.AssignID.HasValue && pr.AssignID.Value == userAdminID &&
pr.AssignRole.HasValue && pr.AssignRole.Value == loginRole) )
return true;
return false;
}
/// <summary>
/// Write Insert Log For Employee
/// </summary>
/// <param name="objInfo"></param>
/// <param name="logId"></param>
private bool WriteUpdateLogForPurchaseRequest(PurchaseRequest newInfo, string logId)
{
bool isUpdated = false;
try
{
// Get old info
PurchaseRequest oldInfo = new PurchaseRequestDao().GetByID(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.WFStatusID != oldInfo.WFStatusID)
{
commonDao.InsertLogDetail(logId, "WFStatusID", "Status", oldInfo.WFStatus.Name, new StatusDao().GetByID(newInfo.WFStatusID).Name);
isUpdated = true;
}
if (newInfo.WFResolutionID != oldInfo.WFResolutionID)
{
commonDao.InsertLogDetail(logId, "WFResolutionID", "Resolution", oldInfo.WFResolution.Name, new ResolutionDao().GetByID(newInfo.WFResolutionID).Name);
isUpdated = true;
}
if (newInfo.RequestDate != oldInfo.RequestDate)
{
commonDao.InsertLogDetail(logId, "RequestDate", "Request Date", oldInfo.RequestDate.ToString(Constants.DATETIME_FORMAT_VIEW), newInfo.RequestDate.ToString(Constants.DATETIME_FORMAT_VIEW));
isUpdated = true;
}
if (newInfo.ExpectedDate != oldInfo.ExpectedDate)
{
commonDao.InsertLogDetail(logId, "ExpectedDate", "Expected Date", oldInfo.ExpectedDate.HasValue ? oldInfo.ExpectedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW) : string.Empty, newInfo.ExpectedDate.HasValue ? newInfo.ExpectedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW) : string.Empty);
isUpdated = true;
}
if (newInfo.SubDepartment != oldInfo.SubDepartment)
{
commonDao.InsertLogDetail(logId, "SubDepartment", "Sub Department", oldInfo.Department.DepartmentName, new DepartmentDao().GetById(newInfo.SubDepartment).DepartmentName);
isUpdated = true;
}
if (newInfo.BillableToClient != oldInfo.BillableToClient)
{
commonDao.InsertLogDetail(logId, "BillableToClient", "Billable To Client", oldInfo.BillableToClient ? "Yes" : "No", newInfo.BillableToClient ? "Yes" : "No");
isUpdated = true;
}
if (newInfo.Priority != oldInfo.Priority)
{
commonDao.InsertLogDetail(logId, "Priority", "Priority", oldInfo.Priority.HasValue ? (oldInfo.Priority.Value == 1 ? "Urgent" : string.Empty) : string.Empty, newInfo.Priority.HasValue ? (newInfo.Priority.Value == 1 ? "Urgent" : string.Empty) : string.Empty);
isUpdated = true;
}
if (newInfo.VendorName != oldInfo.VendorName)
{
commonDao.InsertLogDetail(logId, "VendorName", "VendorName", oldInfo.VendorName, newInfo.VendorName);
isUpdated = true;
}
if (newInfo.VendorPhone != oldInfo.VendorPhone)
{
commonDao.InsertLogDetail(logId, "VendorPhone", "VendorPhone", oldInfo.VendorPhone, newInfo.VendorPhone);
isUpdated = true;
}
if (newInfo.VendorEmail != oldInfo.VendorEmail)
{
commonDao.InsertLogDetail(logId, "VendorEmail", "VendorEmail", oldInfo.VendorEmail, newInfo.VendorEmail);
isUpdated = true;
}
if (newInfo.VendorAddress != oldInfo.VendorAddress)
{
commonDao.InsertLogDetail(logId, "VendorAddress", "VendorAddress", oldInfo.VendorAddress, newInfo.VendorAddress);
isUpdated = true;
}
if (newInfo.MoneyType != oldInfo.MoneyType)
{
commonDao.InsertLogDetail(logId, "MoneyType", "Money Type", oldInfo.MoneyType == Constants.TYPE_MONEY_USD ? "USD" : "VND", newInfo.MoneyType == Constants.TYPE_MONEY_USD ? "USD" : "VND");
isUpdated = true;
}
if (newInfo.OtherCost != oldInfo.OtherCost)
{
commonDao.InsertLogDetail(logId, "OtherCost", "Other Cost", oldInfo.OtherCost.HasValue ? oldInfo.OtherCost.Value.ToString() : string.Empty, newInfo.OtherCost.HasValue ? newInfo.OtherCost.Value.ToString() : string.Empty);
isUpdated = true;
}
if (newInfo.SaleTaxName != oldInfo.SaleTaxName)
{
commonDao.InsertLogDetail(logId, "SaleTaxName", "SaleTaxName", oldInfo.SaleTaxName, newInfo.SaleTaxName);
isUpdated = true;
}
if (newInfo.SaleTaxValue != oldInfo.SaleTaxValue)
{
commonDao.InsertLogDetail(logId, "SaleTaxValue", "Sale Tax Value", oldInfo.SaleTaxValue.HasValue ? oldInfo.SaleTaxValue.Value.ToString() : string.Empty, newInfo.SaleTaxValue.HasValue ? newInfo.SaleTaxValue.Value.ToString() : string.Empty);
isUpdated = true;
}
if (newInfo.Shipping != oldInfo.Shipping)
{
commonDao.InsertLogDetail(logId, "Shipping", "Shipping", oldInfo.Shipping.HasValue ? oldInfo.Shipping.Value.ToString() : string.Empty, newInfo.Shipping.HasValue ? newInfo.Shipping.Value.ToString() : string.Empty);
isUpdated = true;
}
if (newInfo.ServiceCharge != oldInfo.ServiceCharge)
{
commonDao.InsertLogDetail(logId, "ServiceCharge", "ServiceCharge", oldInfo.ServiceCharge.HasValue ? oldInfo.ServiceCharge.Value.ToString() : string.Empty, newInfo.ServiceCharge.HasValue ? newInfo.ServiceCharge.Value.ToString() : string.Empty);
isUpdated = true;
}
if (newInfo.Discount != oldInfo.Discount)
{
commonDao.InsertLogDetail(logId, "Discount", "Discount", oldInfo.Discount.HasValue ? oldInfo.Discount.Value.ToString() : string.Empty, newInfo.Discount.HasValue ? newInfo.Discount.Value.ToString() : string.Empty);
isUpdated = true;
}
if (newInfo.CCList != oldInfo.CCList)
{
commonDao.InsertLogDetail(logId, "CCList", "CCList", oldInfo.CCList, newInfo.CCList);
isUpdated = true;
}
if (newInfo.AssignRole != oldInfo.AssignRole || newInfo.AssignID != oldInfo.AssignID)
{
commonDao.InsertLogDetail(logId, "Assign", "Assign", oldInfo.UserAdmin.UserName + " (" + oldInfo.WFRole.Name + ")", ((newInfo.AssignID.HasValue ? new UserAdminDao().GetById(newInfo.AssignID.Value).UserName : string.Empty)
+ " (" + (newInfo.AssignRole.HasValue ? new RoleDao().GetByID(newInfo.AssignRole.Value).Name : string.Empty) + ")"));
isUpdated = true;
}
if (newInfo.USAccounting != oldInfo.USAccounting)
{
commonDao.InsertLogDetail(logId, "USAccounting", "USAccounting", oldInfo.USAccounting.HasValue ? new UserAdminDao().GetById(oldInfo.USAccounting.Value).UserName : string.Empty, newInfo.USAccounting.HasValue ? new UserAdminDao().GetById(newInfo.USAccounting.Value).UserName : string.Empty);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = Constants.PER_REVIEW_EFORM_MASTER_PREFIX + oldInfo.ID.ToString();
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
}
}
catch (Exception ex)
{
throw ex;
}
return isUpdated;
}
public string GetLastInvolveIdByRole(PurchaseRequest pr, string roleId)
{
string result = "";
string[] arrInvoleId = string.IsNullOrEmpty(pr.InvolveID) ? new string[0] :
pr.InvolveID.Split(new char[]{Constants.SEPARATE_INVOLVE_CHAR},
StringSplitOptions.RemoveEmptyEntries);
string[] arrInvoleRole = string.IsNullOrEmpty(pr.InvolveRole) ? new string[0] :
pr.InvolveRole.Split(new char[]{Constants.SEPARATE_INVOLVE_CHAR},
StringSplitOptions.RemoveEmptyEntries);
for (int i = arrInvoleRole.Length - 1; i >= 0; i--)
if (arrInvoleRole[i].Equals(roleId))
result = arrInvoleId[i];
return result;
}
/// <summary>
/// Check update date whether is valid
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <param name="objDb">PurchaseRequest</param>
/// <param name="msg">Message</param>
/// <returns>bool</returns>
private bool IsValidUpdateDate(PurchaseRequest objUI, PurchaseRequest objDb, out Message msg)
{
bool isValid = false;
msg = null;
try
{
if ((objUI != null) && (objUI.UpdateDate != null))
{
if (objDb != null)
{
if (objDb.UpdateDate.ToString().Equals(objUI.UpdateDate.ToString()))
{
isValid = true;
}
else
{
msg = new Message(MessageConstants.E0025, MessageType.Error, "Purchase Request Id " + objDb.ID);
}
}
}
}
catch
{
throw;
}
return isValid;
}
///// <summary>
///// Write Update Log For When Role Manager
///// </summary>
///// <param name="newInfo"></param>
///// <param name="logId"></param>
///// <returns></returns>
//public void WriteUpdateLogForRoleManager(PurchaseRequest newInfo, ELogAction action)
//{
// bool isUpdated = false;
// try
// {
// // Get old info
// string logId = commonDao.UniqueId;
// commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.PurchaseRequest.ToString(), action.ToString());
// PurchaseRequest oldInfo = new PurchaseRequestDao().GetByID(newInfo.ID);
// if ((oldInfo != null) && (newInfo != null) && (logId != null))
// {
// if (newInfo.WFStatusID != oldInfo.WFStatusID)
// {
// commonDao.InsertLogDetail(logId, "WFStatusID", "Status", new WFStatusDao().GetByID(oldInfo.WFStatusID).Name, new WFStatusDao().GetByID(newInfo.WFStatusID).Name);
// isUpdated = true;
// }
// if (newInfo.WFResolutionID != oldInfo.WFResolutionID)
// {
// WFResolution objRes = new ResolutionDao().GetByID(newInfo.WFResolutionID);
// if (objRes != null)
// {
// commonDao.InsertLogDetail(logId, "WFResolutionID", "Resolution", oldInfo.WFResolutionID.ToString(), objRes.Name);
// isUpdated = true;
// }
// }
// if (newInfo.AssignRole != oldInfo.AssignRole)
// {
// if (newInfo.AssignRole.HasValue)
// {
// WFRole obj = new RoleDao().GetByID(newInfo.AssignRole.Value);
// if (obj != null)
// {
// UserAdmin objUserAdmin = new UserAdminDao().GetById(newInfo.AssignID.Value);
// if (objUserAdmin != null)
// {
// commonDao.InsertLogDetail(logId, "AssignID", " Forward to", oldInfo.UserAdmin.UserName + " (" + oldInfo.WFRole.Name + ")", objUserAdmin.UserName + " (" + obj.Name + ")");
// isUpdated = true;
// }
// }
// }
// }
// if (isUpdated)
// {
// // Insert Key Name
// string key = Constants.PR_REQUEST_PREFIX + oldInfo.ID.ToString();
// commonDao.InsertLogDetail(logId, "EmployeeId", "Key for Update", key, null);
// }
// else
// {
// commonDao.DeleteMasterLog(logId);
// }
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
/// <summary>
/// Write Log For PurchaseRequest
/// </summary>
/// <param name="oldInfo"></param>
/// <param name="newInfo"></param>
/// <param name="action"></param>
public void WriteLogForPurchaseRequest(PurchaseRequest oldInfo, PurchaseRequest newInfo, ELogAction action)
{
try
{
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
switch (action)
{
case ELogAction.Insert:
// Insert to Master Log
commonDao.InsertMasterLog(logId, newInfo.CreatedBy, ELogTable.PurchaseRequest.ToString(), action.ToString());
// Write Insert Log
WriteInsertLogForPurchaseRequest(newInfo, logId);
break;
case ELogAction.Update:
// Insert to Master Log
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.PurchaseRequest.ToString(), action.ToString());
// Write Update Log
bool isUpdated = false;
isUpdated = WriteUpdateLogForPurchaseRequest(newInfo, logId);
if (!isUpdated)
{
commonDao.DeleteMasterLog(logId);
}
break;
case ELogAction.Delete:
// Insert to Master Log
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.PurchaseRequest.ToString(), action.ToString());
// Write Delete Log
string key = newInfo.ID.ToString();
commonDao.InsertLogDetail(logId, "PurchaseRequest_ID", "Key for Delete", key, null);
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public void RenderCanvasSheet(Stream stream, IEnumerable<CanvasItemModel> items, UserModel currentUser,UserModel requestedBy, PurchaseRequest Pr, string[] Vendors)
{
Document document = new Document(PageSize.LETTER);
try {
PdfWriter writer = PdfWriter.GetInstance(document, stream);
document.Open();
// Create a page in the document and add it to the bottom layer
document.NewPage();
//Pass Document to this
CurrentDoc = document;
page = writer.DirectContentUnder;
page.BeginText();
int top = (int)document.GetTop(0);
SetFontSizeTo(16);
PrintText("CANVASS SHEET", 20, 10);
SetFontSizeTo(10);
//Header
PrintText("Company Name: " + requestedBy.CompanyName, 20, 30); // Company Name
PrintText("Department: " + requestedBy.DepartmentName, 20, 45); // Company Address
PrintText("Purpose: " + Pr.Purpose, 20, 60); // Purpose
PrintTextRight("Date: {0}".WithTokens(DateTime.Now.ToShortDateString()), 70, 30); // Date Created
PrintTextRight("PR No: {0}".WithTokens(Pr.PRNo), 70, 45); // PR Number
SetFontSizeTo(8);
// START HERE ----------------------------
Paragraph Grid = new Paragraph("\n");
Grid.Alignment = 1;
Grid.SpacingAfter = 10f;
document.Add(Grid);
Paragraph Grid2 = new Paragraph();
Grid2.Alignment = 1;
Grid2.SpacingBefore = 35f;
//Start Table -----------------------------------
PdfPTable rightTable = new PdfPTable(7);
int[] widths = { 1, 7, 2, 2, 2, 2, 2 };
rightTable.SetWidths(widths);
rightTable.TotalWidth = 570f;
rightTable.LockedWidth = true;
Font tableFont = new Font(Font.FontFamily.HELVETICA, 8);
PdfPCell rightAlignedCell = new PdfPCell();
rightAlignedCell.HorizontalAlignment = Element.ALIGN_CENTER;
//Headers
rightAlignedCell.Phrase = new Phrase("Item No.", tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase("Item Description", tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase("Quantity", tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase("UOM", tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase(Vendors[0], tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase(Vendors[1], tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase(Vendors[2], tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.HorizontalAlignment = Element.ALIGN_RIGHT;
foreach (var item in items) {
string priceVendor1 = item.PriceVendor1 == 0 ? "NONE" : item.PriceVendor1.ToString();
string priceVendor2 = item.PriceVendor2 == 0 ? "NONE" : item.PriceVendor2.ToString();
string priceVendor3 = item.PriceVendor3 == 0 ? "NONE" : item.PriceVendor3.ToString();
rightTable.AddCell(new Phrase(item.ItemNumber.ToString(), tableFont));
rightTable.AddCell(new Phrase(item.ItemDescription, tableFont));
rightAlignedCell.Phrase = new Phrase(item.Quantity.ToString(), tableFont); rightTable.AddCell(rightAlignedCell);
rightTable.AddCell(new Phrase(item.UOM, tableFont));
rightAlignedCell.Phrase = new Phrase(priceVendor1, tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase(priceVendor2, tableFont); rightTable.AddCell(rightAlignedCell);
rightAlignedCell.Phrase = new Phrase(priceVendor3, tableFont); rightTable.AddCell(rightAlignedCell);
}
Grid2.Add(rightTable);
document.Add(Grid2);
// Footer
SetFontSizeTo(10);
PrintTextBottom("Requested By:", 20, 105);
PrintTextBottom("{0} {1}".WithTokens(requestedBy.FirstName, requestedBy.LastName), 20, 35);
PrintTextBottom("Prepared By:", 265, 105);
PrintTextBottom("{0} {1}".WithTokens(currentUser.FirstName, currentUser.LastName), 265, 35);
PrintTextBottom("Approved By:", 450, 105);
PrintTextBottom("{0}".WithTokens("______________________"), 450, 35);
page.EndText();
writer.Flush();
}
finally {
document.Close();
}
}
public bool IsInInvolveList(PurchaseRequest pr, int userAdminID, int loginRole)
{
int? result = dbContext.check_in_list_int(pr.InvolveID, userAdminID,
pr.InvolveRole, loginRole, Constants.SEPARATE_INVOLVE_SIGN);
return result.HasValue ? result.Value == 1 ? true : false : false;
}
abstract public void ProcessRequest(
PurchaseRequest request );
public bool IsRequestor(PurchaseRequest pr, int userAdminID, int loginRole)
{
if (loginRole == Constants.PR_REQUESTOR_ID && pr.Requestor == userAdminID)
return true;
return false;
}
/// <summary>
/// Insert purchase request
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <returns>Message</returns>
public Message Insert(PurchaseRequest objUI)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (objUI != null)
{
objUI.DeleteFlag = false;
dbContext.PurchaseRequests.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
//Write Log
new PurchaseRequestLogDao().WriteLogForPurchaseRequest(null, objUI, ELogAction.Insert);
msg = new Message(MessageConstants.I0001, MessageType.Info, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'", "added");
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
finally
{
if ((trans.Connection != null) && (trans.Connection.State == System.Data.ConnectionState.Open))
{
trans.Connection.Close();
}
}
return msg;
}
/// <summary>
/// Update purchase request
/// </summary>
/// <param name="objUI">PurchaseRequest</param>
/// <param name="oldItemList">List of old purchase items</param>
/// <param name="newItemList">List of new purchase items</param>
/// <returns>Message</returns>
public Message Update(PurchaseRequest objUI,List<PurchaseItem> oldItemList,List<PurchaseItem> newItemList)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (objUI != null)
{
// Get current group in dbContext
PurchaseRequest objDb = GetByID(objUI.ID);
if (objDb != null)
{
if (objDb.UpdateDate.ToString() == objUI.UpdateDate.ToString())
{
new PurchaseRequestLogDao().WriteLogForPurchaseRequest(null, objUI, ELogAction.Update);
#region Purchase Request
// Update info by objUI
objDb.ExpectedDate = objUI.ExpectedDate;
objDb.CCList = objUI.CCList;
objDb.WFStatusID = objUI.WFStatusID;
objDb.PaymentID = objUI.PaymentID;
objDb.WFResolutionID = objUI.WFResolutionID;
objDb.SubDepartment = objUI.SubDepartment;
objDb.Justification = objUI.Justification;
objDb.BillableToClient = objUI.BillableToClient;
objDb.VendorName = objUI.VendorName;
objDb.VendorPhone = objUI.VendorPhone;
objDb.VendorEmail = objUI.VendorEmail;
objDb.VendorAddress = objUI.VendorAddress;
objDb.MoneyType = objUI.MoneyType;
objDb.SaleTaxName = objUI.SaleTaxName;
objDb.SaleTaxValue = objUI.SaleTaxValue;
objDb.OtherCost = objUI.OtherCost;
objDb.Shipping = objUI.Shipping;
objDb.Discount = objUI.Discount;
objDb.ServiceCharge = objUI.ServiceCharge;
objDb.AssignID = objUI.AssignID;
objDb.AssignRole = objUI.AssignRole;
objDb.InvolveID = objUI.InvolveID;
objDb.InvolveRole = objUI.InvolveRole;
objDb.InvolveDate = objUI.InvolveDate;
objDb.InvolveResolution = objUI.InvolveResolution;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
objDb.Priority = objUI.Priority;
#endregion
#region Purchase Item
if (oldItemList.Count > 0)
{
string oldItemID = string.Empty;
foreach (PurchaseItem oldItem in oldItemList) //case Update Old item
{
UpdatePurchaseItem(oldItem);
oldItemID += oldItem.ID + ",";
}
foreach (PurchaseItem deleteItem in GetListOldPurchaseItem(objDb.ID))
{
if (!oldItemID.TrimEnd(',').Split(',').Contains(deleteItem.ID.ToString()))
{
DeletePurchaseItem(deleteItem);
}
}
}
if (newItemList.Count > 0)
{
InsertMultiItem(newItemList);
}
#endregion
// Submit changes to dbContext
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'", "updated");
trans.Commit();
}
else
{
msg = new Message(MessageConstants.E0025, MessageType.Error, "Purchase Request '" + Constants.PR_REQUEST_PREFIX + objUI.ID + "'");
trans.Rollback();
}
}
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
