private string GetValue(string key, BLL.GiftCertificate certificate)
{
if (!string.IsNullOrEmpty(key) && certificate != null)
{
switch (key.ToUpper())
{
case CertificateFields.DONOR:
return(certificate.Donor.Name);
case CertificateFields.ETA:
return(certificate.ETA.ToShortDateString());
case CertificateFields.GIFTDATE:
return(certificate.GiftDate.ToShortDateString());
case CertificateFields.REFERENCENO:
return(certificate.ReferenceNo);
case CertificateFields.SINUMBER:
return(certificate.SINumber);
case CertificateFields.VESSEL:
return(certificate.Vessel);
}
}
return(string.Empty);
}
/// <summary>
/// Gifts the certificate model.
/// </summary>
/// <param name="GiftCertificateModel">The gift certificate model.</param>
/// <returns></returns>
public static Models.GiftCertificateViewModel GiftCertificateModel(BLL.GiftCertificate GiftCertificateModel)
{
GiftCertificateViewModel giftCertificateViewModel = new GiftCertificateViewModel();
giftCertificateViewModel.GiftCertificateID = GiftCertificateModel.GiftCertificateID;
giftCertificateViewModel.GiftDate = GiftCertificateModel.GiftDate;
giftCertificateViewModel.DonorID = GiftCertificateModel.DonorID;
giftCertificateViewModel.SINumber = GiftCertificateModel.SINumber;
giftCertificateViewModel.ReferenceNo = GiftCertificateModel.ReferenceNo;
giftCertificateViewModel.Vessel = GiftCertificateModel.Vessel;
giftCertificateViewModel.ETA = GiftCertificateModel.ETA;
giftCertificateViewModel.ProgramID = GiftCertificateModel.ProgramID;
giftCertificateViewModel.PortName = GiftCertificateModel.PortName;
giftCertificateViewModel.DModeOfTransport = GiftCertificateModel.DModeOfTransport;
var giftCertificateDetail = GiftCertificateModel.GiftCertificateDetails.FirstOrDefault();
if (giftCertificateDetail != null)
{
giftCertificateViewModel.CommodityTypeID = giftCertificateDetail.Commodity.CommodityTypeID;
}
else
{
giftCertificateViewModel.CommodityTypeID = 1;//by default 'food'
}
giftCertificateViewModel.GiftCertificateDetails =
GiftCertificateDetailsViewModel.GenerateListOfGiftCertificateDetailsViewModel(
GiftCertificateModel.GiftCertificateDetails.ToList());
return(giftCertificateViewModel);
}
private string PopulateCertificate(string templateString, BLL.GiftCertificate cert)
{
templateString = SearchAndReplace(CertificateFields.DONOR, GetValue(CertificateFields.DONOR, cert), templateString);
templateString = SearchAndReplace(CertificateFields.ETA, GetValue(CertificateFields.ETA, cert), templateString);
templateString = SearchAndReplace(CertificateFields.GIFTDATE, GetValue(CertificateFields.GIFTDATE, cert), templateString);
templateString = SearchAndReplace(CertificateFields.REFERENCENO, GetValue(CertificateFields.REFERENCENO, cert), templateString);
templateString = SearchAndReplace(CertificateFields.SINUMBER, GetValue(CertificateFields.SINUMBER, cert), templateString);
templateString = SearchAndReplace(CertificateFields.VESSEL, GetValue(CertificateFields.VESSEL, cert), templateString);
return(templateString);
}
/// <summary>
/// Updates the specified gift certificate model.
/// </summary>
/// <param name="giftCertificateModel">The gift certificate model.</param>
/// <param name="inserted">The inserted gift certificate detail.</param>
/// <param name="updated">The updated gift certificate detail.</param>
/// <param name="deleted">The deleted gift certificate detail.</param>
public void Update(GiftCertificate giftCertificateModel, List <GiftCertificateDetail> inserted,
List <GiftCertificateDetail> updated, List <GiftCertificateDetail> deleted)
{
// DRMFSSEntities1 db = new DRMFSSEntities1();
BLL.GiftCertificate orginal = _unitOfWork.GiftCertificateRepository.Get(p => p.GiftCertificateID == giftCertificateModel.GiftCertificateID).SingleOrDefault();
if (orginal != null)
{
orginal.GiftDate = giftCertificateModel.GiftDate;
orginal.DonorID = giftCertificateModel.DonorID;
orginal.SINumber = giftCertificateModel.SINumber;
orginal.ReferenceNo = giftCertificateModel.ReferenceNo;
orginal.Vessel = giftCertificateModel.Vessel;
orginal.ETA = giftCertificateModel.ETA;
orginal.ProgramID = giftCertificateModel.ProgramID;
orginal.PortName = giftCertificateModel.PortName;
orginal.DModeOfTransport = giftCertificateModel.DModeOfTransport;
foreach (BLL.GiftCertificateDetail insert in inserted)
{
orginal.GiftCertificateDetails.Add(insert);
}
foreach (BLL.GiftCertificateDetail delete in deleted)
{
BLL.GiftCertificateDetail deletedGiftDetails = _unitOfWork.GiftCertificateDetailRepository.FindBy(p => p.GiftCertificateDetailID == delete.GiftCertificateDetailID).SingleOrDefault();
if (deletedGiftDetails != null)
{
_unitOfWork.GiftCertificateDetailRepository.Delete(deletedGiftDetails);
}
}
foreach (BLL.GiftCertificateDetail update in updated)
{
BLL.GiftCertificateDetail updatedGiftDetails = _unitOfWork.GiftCertificateDetailRepository.Get(p => p.GiftCertificateDetailID == update.GiftCertificateDetailID).SingleOrDefault();
if (updatedGiftDetails != null)
{
updatedGiftDetails.CommodityID = update.CommodityID;
updatedGiftDetails.BillOfLoading = update.BillOfLoading;
updatedGiftDetails.YearPurchased = update.YearPurchased;
updatedGiftDetails.AccountNumber = update.AccountNumber;
updatedGiftDetails.WeightInMT = update.WeightInMT;
updatedGiftDetails.EstimatedPrice = update.EstimatedPrice;
updatedGiftDetails.EstimatedTax = update.EstimatedTax;
updatedGiftDetails.DCurrencyID = update.DCurrencyID;
updatedGiftDetails.DFundSourceID = update.DFundSourceID;
updatedGiftDetails.DBudgetTypeID = update.DBudgetTypeID;
updatedGiftDetails.ExpiryDate = update.ExpiryDate;
}
}
_unitOfWork.Save();
}
}
public static Models.GiftCertificateViewModel GiftCertificateModel(BLL.GiftCertificate GiftCertificateModel)
{
GiftCertificateViewModel giftCertificateViewModel = new GiftCertificateViewModel();
giftCertificateViewModel.GiftCertificateID = GiftCertificateModel.GiftCertificateID;
giftCertificateViewModel.GiftDate = GiftCertificateModel.GiftDate;
giftCertificateViewModel.DonorID = GiftCertificateModel.DonorID;
giftCertificateViewModel.SINumber = GiftCertificateModel.SINumber;
giftCertificateViewModel.ReferenceNo = GiftCertificateModel.ReferenceNo;
giftCertificateViewModel.Vessel = GiftCertificateModel.Vessel;
giftCertificateViewModel.ETA = GiftCertificateModel.ETA;
giftCertificateViewModel.ProgramID = GiftCertificateModel.ProgramID;
giftCertificateViewModel.PortName = GiftCertificateModel.PortName;
giftCertificateViewModel.DModeOfTransport = GiftCertificateModel.DModeOfTransport;
giftCertificateViewModel.GiftCertificateDetails =
GiftCertificateDetailsViewModel.GenerateListOfGiftCertificateDetailsViewModel(
GiftCertificateModel.GiftCertificateDetails);
return(giftCertificateViewModel);
}
public string Parse(int certificateId, int templateId)
{
IUnitOfWork repository = new UnitOfWork();
LetterTemplateService letterService = new LetterTemplateService();
GiftCertificateService giftService = new GiftCertificateService(repository);
BLL.GiftCertificate gift = giftService.FindById(certificateId);
BLL.LetterTemplate template = letterService.FindById(templateId);
string raw = HttpContext.Current.Server.HtmlDecode(template.Template);
string tableString = string.Empty;
int startIndex = raw.IndexOf("<table id=\"detail\"");//("<table id=\"detail\" style=\"width:100%;\">")
if (startIndex != -1)
{
int lastIndex = raw.IndexOf("</table>", startIndex) + 8;
if (lastIndex != -1)
{
int length = lastIndex - startIndex;
tableString = raw.Substring(startIndex, length);
}
}
if (@tableString != "")
{
raw = raw.Replace(@tableString, "{tablePlaceHolder}");
}
raw = PopulateCertificate(raw, gift);
string populatedTable = string.Empty;
if (@tableString != "")
{
populatedTable = PopulateTableData(gift.GiftCertificateDetails.ToList(), tableString.Replace(" ", ""));
}
string finalString = raw.Replace("{tablePlaceHolder}", populatedTable);
return(finalString);
}
public ActionResult Create(GiftCertificateViewModel giftcertificate)
{
if (ModelState.IsValid)
{
BLL.GiftCertificate giftCertificateModel = giftcertificate.GenerateGiftCertificate();
InsertGiftCertificate(giftcertificate, giftCertificateModel);
//repository.Add( giftCertificate );
return(RedirectToAction("Index"));
}
ViewBag.Commodities = _commodityService.GetAllCommodity().OrderBy(o => o.Name);
ViewBag.CommodityTypes = _commodityTypeService.GetAllCommodityType().OrderBy(o => o.Name);
ViewBag.DCurrencies = _detailService.GetAllDetail().Where(d => d.MasterID == BLL.Master.Constants.CURRENCY).OrderBy(o => o.SortOrder);
ViewBag.DFundSources = _detailService.GetAllDetail().Where(d => d.MasterID == BLL.Master.Constants.FUND_SOURCE).OrderBy(o => o.SortOrder);
ViewBag.DBudgetTypes = _detailService.GetAllDetail().Where(d => d.MasterID == BLL.Master.Constants.BUDGET_TYPE).OrderBy(o => o.SortOrder);
ViewBag.Donors = new SelectList(_donorService.GetAllDonor().OrderBy(o => o.Name), "DonorID", "Name");
ViewBag.Programs = new SelectList(_programService.GetAllProgram(), "ProgramID", "Name");
ViewBag.DModeOfTransports = new SelectList(_detailService.GetAllDetail().Where(d => d.MasterID == BLL.Master.Constants.TRANSPORT_MODE).OrderBy(o => o.SortOrder), "DetailID", "Name");
//return the model with the values pre-populated
return(Create()); //GiftCertificateViewModel.GiftCertificateModel(giftcertificate));
}
