/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteCountrySubOffice(Guid id)
{
bool isDeleted = false;
using (var dbContext = new SCMSEntities())
{
CountrySubOffice ctrySubOffice = dbContext.CountrySubOffices.Single(c => c.Id.Equals(id));
dbContext.CountrySubOffices.Remove(ctrySubOffice);
if (dbContext.SaveChanges() > 0)
{
isDeleted = true;
}
}
return(isDeleted);
}
/// <summary>
///
/// </summary>
/// <param name="CountrySubOffice"></param>
/// <returns></returns>
public bool EditCountrySubOffice(CountrySubOffice ctrySubOffice)
{
bool isSaved = false;
using (var context = new SCMSEntities())
{
context.CountrySubOffices.Attach(ctrySubOffice);
((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(ctrySubOffice, System.Data.EntityState.Modified);
if (context.SaveChanges() > 0)
{
isSaved = true;
}
}
return(isSaved);
}
/// <summary>
///
/// </summary>
/// <param name="ctrySubOffice"></param>
/// <returns></returns>
public bool AddCountrySubOffice(CountrySubOffice ctrySubOffice)
{
bool isSaved = false;
if (ctrySubOffice.Id.Equals(Guid.Empty))
{
ctrySubOffice.Id = Guid.NewGuid();
}
using (var dbContext = new SCMSEntities())
{
dbContext.CountrySubOffices.Add(ctrySubOffice);
if (dbContext.SaveChanges() > 0)
{
isSaved = true;
}
}
return(isSaved);
}
public ActionResult GRNTemplate(Model.GoodsReceivedNote model)
{
Dictionary <String, String> data = new Dictionary <string, string>();
using (var db = new SCMSEntities())
{
Model.GoodsReceivedNote grnentity = model;
Model.PurchaseOrder po = db.PurchaseOrders.FirstOrDefault(p => p.Id == model.PurchaseOrderId);
CountrySubOffice csof = db.CountrySubOffices.FirstOrDefault(p => p.Id == model.CountryOfficeId);
data.Add("{SUPPLIER}", po != null ? po.Supplier.Name : "<sub>________________________________________</sub>");
data.Add("{GRN}", "<sub>________________________________________</sub>");
//data.Add("{GRN}", grnentity.RefNumber.IsNotNullOrEmpty() ? grnentity.RefNumber : "<sub>________________________________________</sub>");
data.Add("{DNN}", grnentity.DnNumber ?? "<sub>________________________________________</sub>");
data.Add("{OFFICE}", csof != null ? csof.Name : "<sub>________________________________________</sub>");
data.Add("{LOCATION}", csof != null ? csof.Location.Name : "<sub>________________________________________</sub>");
data.Add("{ORNO}", po != null ? po.OrderRequest.RefNumber : "<sub>________________________________________</sub>");
data.Add("{PONO}", po != null ? po.RefNumber : "<sub>________________________________________</sub>");
data.Add("{DELIVERY_DATE}", "<sub>________________________________________</sub>");
int r = 1;
String detailHtml = "";
foreach (POItemsView poItem in model.POItemz)
{
detailHtml += "<tr><td align=\"center\">" + r++ + "</td><td>";
detailHtml += poItem.ItemName;
detailHtml += "</td><td>";
detailHtml += poItem.unitOfMessure;
detailHtml += "</td><td class='central'>";
detailHtml += poItem.QtyOrdered.ToString("##,###");
detailHtml += "</td><td class='central'>";
detailHtml += poItem.QtyDelivered.ToString("##,###");
detailHtml += "</td><td class='central'>";
detailHtml += poItem.QtyDamaged.ToString("##,###");
detailHtml += "</td><td>";
detailHtml += poItem.comments;
}
while (r < 21)
{
detailHtml += "<tr><td align=\"center\">" + r++ + "</td><td>";
detailHtml += "</td><td>";
detailHtml += "</td><td class='central'>";
detailHtml += "</td><td class='central'>";
detailHtml += "</td><td class='central'>";
detailHtml += "</td><td>";
}
data.Add("{DETAILS}", detailHtml);
var recBy = db.VStaffDetails.FirstOrDefault(p => p.StaffID == grnentity.ReceivedBy);
data.Add("{SIGNATURE2}", "<sub>___________________________________________</sub>");
data.Add("{SIGNATURE_DATE}", grnentity.DeliverDate.Value.ToShortDateString());
data.Add("{TRANSPORTER_NAME}", grnentity.DeliveredBy.IsNotNullOrWhiteSpace() ? grnentity.DeliveredBy : "<sub>_________________________________________</sub>");
data.Add("{TRANSPORTER_COMPANY}", grnentity.DeliveryCompany.IsNotNullOrEmpty() ? grnentity.DeliveryCompany : "<sub>_____________________________________</sub>");
data.Add("{DRIVER_ID}", grnentity.DriverLicenseNumber.IsNotNullOrEmpty() ? grnentity.DriverLicenseNumber : "<sub>________________________________________</sub>");
data.Add("{VEHICLE_PLATE}", grnentity.VehicleRegNumber.IsNotNullOrEmpty() ? grnentity.VehicleRegNumber : "<sub>_________________________________________</sub>");
data.Add("{RECEIVED_BY}", recBy != null ? recBy.StaffName : "<sub>_______________________________________________</sub>");
data.Add("{TITLE}", recBy != null ? recBy.Designation : "<sub>____________________________________________________</sub>");
}
Byte[] output = WkHtml2Pdf.CreateReport(data, "goods-received-note.html");
return(File(output, "application/pdf", "GRN_Template_" + DateTime.Now.FormatDDMMMYYYYHHmm()));
}
