public void CopyChildEntities(int ParentID)
{
string con = ConfigurationHelper.GetsmARTDBContextConnectionString();
SalesOrderItemLibrary soItemLib = new SalesOrderItemLibrary();
soItemLib.Initialize(con);
IEnumerable <SalesOrderItem> soItems = soItemLib.GetAllBySalesOrderID(ParentID, new string[] { "SalesOrder", "Item" });
Session["SalesOrderItem"] = soItems;
SalesOrderNotesLibrary soNotesLib = new SalesOrderNotesLibrary();
soNotesLib.Initialize(con);
IEnumerable <SalesOrderNotes> soNotess = soNotesLib.GetAllByParentID(ParentID);
Session["SalesOrderNotes"] = soNotess;
SalesOrderAttachmentsLibrary soAttachmentsLib = new SalesOrderAttachmentsLibrary();
soAttachmentsLib.Initialize(con);
IEnumerable <SalesOrderAttachments> soAttachmentss = soAttachmentsLib.GetAllByParentID(ParentID);
Session["SalesOrderAttachments"] = soAttachmentss;
}
public ActionResult SelectOpneBookingItem(int?id)
{
if (id.HasValue)
{
// Update Container details
Container container = new ContainerLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString()).GetByID(id.ToString(), new string[] { "Booking.Sales_Order_No.Party" });
if (container != null)
{
ClearChildEntities(new string[] { "ScaleDetails", "ScaleNotes", "ScaleAttachments", "ScaleExpense" });
Scale result = new Scale();
result.Ticket_Type = "Shipping Ticket";
result.Container_No = new Container();
result.Container_No = container;
// Update Scale Items
if (container.Booking != null && container.Booking.Sales_Order_No != null)
{
IEnumerable <SalesOrderItem> soItems = new SalesOrderItemLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString())
.GetAllBySalesOrderID(container.Booking.Sales_Order_No.ID,
new string[] { "SalesOrder.Party", "Item" }
);
List <ScaleDetails> scaleDetails = new List <ScaleDetails>();
int count = 0;
foreach (var soItem in soItems)
{
count += 1;
ScaleDetails scaleDetail = new ScaleDetails()
{
ID = count,
Item_Received = soItem.Item,
Apply_To_Item = soItem.Item,
Split_Value = 100,
Scale = new Scale(),
Created_By = HttpContext.User.Identity.Name,
Updated_By = HttpContext.User.Identity.Name,
Created_Date = DateTime.Now,
Last_Updated_Date = DateTime.Now
};
scaleDetails.Add(scaleDetail);
}
Session["ScaleDetails"] = scaleDetails;
}
ViewBag.IsFromOpneBooking = true;
result.ID = 0;
return(Display(result));
}
}
return(RedirectToAction("New"));
}
private void ValidateSOItem(int soId, ScaleDetails scaleItem)
{
if (soId > 0)
{
SalesOrderItemLibrary soItemLib = new SalesOrderItemLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderItem> soItems = soItemLib.GetAllBySalesOrderID(soId, new string[] { "Item" });
var isSOItem = (from i in soItems
where i.Item.ID == scaleItem.Item_Received.ID
select i).FirstOrDefault();
if (isSOItem == null)
{
ModelState.AddModelError("Item_Received", string.Format("Scale details item {0} mismatch to selected sales order items.", scaleItem.Item_Received.Short_Name));
}
}
}
protected override void DeleteChildEntities(string[] childEntityList, string parentID)
{
foreach (string ChildEntity in childEntityList)
{
switch (ChildEntity)
{
#region /* Case Statements - All child grids */
case "SalesOrderItem":
if (Session[ChildEntity] != null)
{
SalesOrderItemLibrary salesorderItemLibrary = new SalesOrderItemLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderItem> resultList = (IList <SalesOrderItem>)Session[ChildEntity];
foreach (SalesOrderItem item in resultList)
{
salesorderItemLibrary.Delete(item.ToString());
}
}
break;
case "SalesOrderNotes":
if (Session[ChildEntity] != null)
{
SalesOrderNotesLibrary salesorderNotesLibrary = new SalesOrderNotesLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderNotes> resultList = (IList <SalesOrderNotes>)Session[ChildEntity];
foreach (SalesOrderNotes note in resultList)
{
salesorderNotesLibrary.Delete(note.ToString());
}
}
break;
case "SalesOrderAttachments":
if (Session[ChildEntity] != null)
{
SalesOrderAttachmentsLibrary salesorderLibrary = new SalesOrderAttachmentsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderAttachments> resultList = (IList <SalesOrderAttachments>)Session[ChildEntity];
foreach (SalesOrderAttachments attachment in resultList)
{
salesorderLibrary.Delete(attachment.ToString());
}
}
break;
#endregion
}
}
}
protected override void SaveChildEntities(string[] childEntityList, SalesOrder entity)
{
foreach (string ChildEntity in childEntityList)
{
switch (ChildEntity)
{
#region /* Case Statements - All child grids */
case "SalesOrderItem":
if (Session[ChildEntity] != null)
{
SalesOrderItemLibrary salesorderItemLibrary = new SalesOrderItemLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderItem> resultList = (IList <SalesOrderItem>)Session[ChildEntity];
foreach (SalesOrderItem salesorderItem in resultList)
{
salesorderItem.SalesOrder = new SalesOrder {
ID = entity.ID
};
//itemNote.Notes = System.Web.HttpUtility.HtmlDecode(itemNote.Notes);
salesorderItemLibrary.Add(salesorderItem);
}
}
break;
case "SalesOrderNotes":
if (Session[ChildEntity] != null)
{
SalesOrderNotesLibrary salesorderNotesLibrary = new SalesOrderNotesLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderNotes> resultList = (IList <SalesOrderNotes>)Session[ChildEntity];
foreach (SalesOrderNotes salesorderNote in resultList)
{
salesorderNote.Parent = new SalesOrder {
ID = entity.ID
};
//itemNote.Notes = System.Web.HttpUtility.HtmlDecode(itemNote.Notes);
salesorderNotesLibrary.Add(salesorderNote);
}
}
break;
case "SalesOrderAttachments":
if (Session[ChildEntity] != null)
{
SalesOrderAttachmentsLibrary salesorderLibrary = new SalesOrderAttachmentsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <SalesOrderAttachments> resultList = (IList <SalesOrderAttachments>)Session[ChildEntity];
string destinationPath;
string sourcePath;
FilelHelper fileHelper = new FilelHelper();
foreach (SalesOrderAttachments salesorder in resultList)
{
destinationPath = fileHelper.GetSourceDirByFileRefId(salesorder.Document_RefId.ToString()); // Path.Combine(Configuration.GetsmARTDocPath(), SalesOrder.Document_RefId.ToString());
sourcePath = fileHelper.GetTempSourceDirByFileRefId(salesorder.Document_RefId.ToString()); // Path.Combine(Configuration.GetsmARTTempDocPath(), SalesOrder.Document_RefId.ToString());
salesorder.Document_Path = fileHelper.GetFilePath(sourcePath);
fileHelper.MoveFile(salesorder.Document_Name, sourcePath, destinationPath);
salesorder.Parent = new SalesOrder {
ID = entity.ID
};
salesorderLibrary.Add(salesorder);
}
}
break;
#endregion
}
}
}
