//public Party SaveParty(string licenseNo, string name,string state,string loginUser,string imageRefId) {
public Party SaveParty(Party party, AddressBook address)
{
Party entity = null;
// Save Party
if (party != null)
{
PartyLibrary partyLib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
entity = partyLib.GetByID(party.ID.ToString());
if (entity == null || entity.ID <= 0)
{
entity = new Party();
}
entity.License_No = party.License_No;
entity.Party_Name = party.Party_Name;
entity.Party_Short_Name = party.Party_Short_Name;
entity.State = party.State;
entity.Created_By = party.Created_By;
entity.Created_Date = DateTime.Now;
entity.Active_Ind = true;
entity.IsActive = true;
entity.Updated_By = party.Updated_By;
entity.Last_Updated_Date = DateTime.Now;
entity.Party_Type = "Individual";
entity.LicenseImageRefId = party.LicenseImageRefId;
entity.Party_DOB = party.Party_DOB;
entity.ACLicense_ID = party.ACLicense_ID;
entity.ThumbImage1RefId = party.ThumbImage1RefId;
entity.ThumbImage2RefId = party.ThumbImage2RefId;
entity.PhotoRefId = party.PhotoRefId;
entity.SignatureImageRefId = party.SignatureImageRefId;
entity.VehicleImageRegId = party.VehicleImageRegId;
entity.CashCardImageRefId = party.CashCardImageRefId;
if (entity == null || entity.ID <= 0)
{
entity = partyLib.Add(entity);
}
else
{
entity = partyLib.Modify(entity);
}
// Save Address
if (address != null)
{
AddressBookLibrary addressLib = new AddressBookLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
AddressBook addressBook = addressLib.GetPrimaryAddressesByPartyId(entity.ID);
if (addressBook == null || addressBook.ID <= 0)
{
addressBook = new AddressBook();
}
addressBook.Party = entity;
addressBook.Address1 = address.Address1;
addressBook.City = address.City;
addressBook.State = party.State;
addressBook.Zip_Code = address.Zip_Code;
addressBook.Country = address.Country;
addressBook.Primary_Flag = true;
addressBook.Address_Type = address.Address_Type;
addressBook.Created_By = party.Created_By;
addressBook.Created_Date = DateTime.Now;
addressBook.Active_Ind = true;
addressBook.Updated_By = party.Updated_By;
addressBook.Last_Updated_Date = DateTime.Now;
if (addressBook == null || addressBook.ID <= 0)
{
addressLib.Add(addressBook);
}
else
{
addressLib.Modify(addressBook);
}
}
}
return(entity);
}
protected override void SaveChildEntities(string[] childEntityList, Party entity)
{
foreach (string ChildEntity in childEntityList)
{
switch (ChildEntity)
{
#region /* Case Statements - All child grids */
case "AddressBook":
if (Session[ChildEntity] != null)
{
ILibrary <AddressBook> contactLibrary = new AddressBookLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <AddressBook> resultList = (IList <AddressBook>)Session[ChildEntity];
//if (resultList.Count() == 1 || resultList.Count(o => o.Primary_Flag == true) <= 0)
// resultList.FirstOrDefault().Primary_Flag = true;
foreach (AddressBook contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Bank":
if (Session[ChildEntity] != null)
{
ILibrary <Bank> contactLibrary = new BankLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Bank> resultList = (IList <Bank>)Session[ChildEntity];
foreach (Bank contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Bin":
if (Session[ChildEntity] != null)
{
ILibrary <Bin> contactLibrary = new BinLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Bin> resultList = (IList <Bin>)Session[ChildEntity];
foreach (Bin contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Contact":
if (Session[ChildEntity] != null)
{
ILibrary <Contact> contactLibrary = new ContactLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Contact> resultList = (IList <Contact>)Session[ChildEntity];
foreach (Contact contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Note":
if (Session[ChildEntity] != null)
{
ILibrary <Note> contactLibrary = new NoteLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Note> resultList = (IList <Note>)Session[ChildEntity];
foreach (Note contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
#endregion
}
}
}
public HttpResponseMessage SaveTicket([FromBody] Ticket value)
{
try {
if (value.Scale == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
// Start transaction.
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
})) {
smART.ViewModel.Scale newScale = new Scale();
// Add new party if already exists
if (!string.IsNullOrEmpty(value.Scale.License_No))
{
PartyLibrary partyLib = new PartyLibrary(ConString);
Party party = partyLib.GetByLicenseNo(value.Scale.License_No);
if (party != null)
{
newScale.Party_ID = party;
}
else
{
// Add new party
party = new Party();
party.Party_Name = value.Scale.Customer_Name;
party.Party_Short_Name = value.Scale.Customer_Name;
party.License_No = value.Scale.License_No;
party.Party_Type = "Individual";
party.Created_By = value.Scale.Created_By;
party.Updated_By = value.Scale.Created_By;
party.Created_Date = value.Scale.Created_Date;
party.Last_Updated_Date = value.Scale.Created_Date;
party.Active_Ind = true;
party.IsActive = true;
party.State = !string.IsNullOrEmpty(value.Scale.Customer_State) ? value.Scale.Customer_State.ToString().Trim() : "";
party.ACLicense_ID = value.Scale.Customer_ACLicense_ID;
party.Party_DOB = value.Scale.Customer_DOB;
//string dobString = value.Scale.Customer_DOB;
//DateTime dobDt;
//if (smART.Common.DateTimeHelper.IsValidDate(dobString, out dobDt))
// party.Party_DOB = dobDt;
party = partyLib.Add(party);
newScale.Party_ID = party;
// Add new Address
AddressBook address = new AddressBook();
address.Address1 = value.Scale.Customer_Address;
address.City = value.Scale.Customer_City;
address.State = value.Scale.Customer_State;
address.Country = value.Scale.Customer_Country;
address.Party = party;
address.Created_By = value.Scale.Created_By;
address.Updated_By = value.Scale.Created_By;
address.Created_Date = value.Scale.Created_Date;
address.Last_Updated_Date = value.Scale.Created_Date;
address.Primary_Flag = true;
address.Active_Ind = true;
address.Zip_Code = value.Scale.Customer_Zip;
AddressBookLibrary addressLib = new AddressBookLibrary(ConString);
addressLib.Add(address);
}
}
// Save Scale
ScaleLibrary lib = new ScaleLibrary(ConString);
newScale.Ticket_Status = "Open";
newScale.QScale = true;
newScale.Gross_Weight = value.ScaleDetails.Sum(s => s.GrossWeight);
newScale.Tare_Weight = value.ScaleDetails.Sum(s => s.TareWeight);;
newScale.Net_Weight = value.ScaleDetails.Sum(s => s.NetWeight);
value.Scale.MapServiceEntityToServerEntity(newScale);
smART.ViewModel.Scale scale = lib.Add(newScale);
// Save scale detail
if (value.ScaleDetails != null)
{
ScaleDetailsLibrary libScaleDetail = new ScaleDetailsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
ItemLibrary libItem = new ItemLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
foreach (var item in value.ScaleDetails)
{
smART.ViewModel.ScaleDetails newScaleDetails = new smART.ViewModel.ScaleDetails();
newScaleDetails.Apply_To_Item = libItem.GetByID(item.Item_ID.ToString());
newScaleDetails.Item_Received = libItem.GetByID(item.Item_ID.ToString());
newScaleDetails.Scale = scale;
item.MapServiceEntityToServerEntity(newScaleDetails);
ScaleDetails scaleDetails = libScaleDetail.Add(newScaleDetails);
// Set docuent related id if document is related to item
if (value.ScaleAttachments != null && value.ScaleAttachments.Count > 0)
{
Model.ScaleAttachments modelAttach = value.ScaleAttachments.Where(w => w.Document_RelatedID == item.ID).FirstOrDefault();
if (modelAttach != null && modelAttach.Document_RelatedTo == 1)
{
modelAttach.Document_RelatedID = scaleDetails.ID;
}
}
}
}
// Save Max Ticket ID in Device Settings
DeviceSettingLibrary deviceLib = new DeviceSettingLibrary(ConString);
DeviceSettings deviceSettings = deviceLib.GetByUniueID(scale.Unique_ID.Value);
deviceSettings.MaxTicket_ID = value.Scale.ID;
deviceLib.Modify(deviceSettings);
// Save Attachments
if (value.ScaleAttachments != null)
{
ScaleAttachmentsLibrary libAttach = new ScaleAttachmentsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
FilelHelper fileHelper = new FilelHelper();
foreach (var item in value.ScaleAttachments)
{
smART.ViewModel.ScaleAttachments newScaleAttachment = new smART.ViewModel.ScaleAttachments();
// Save file
Guid docRefId = Guid.NewGuid();
string destinationPath = fileHelper.GetSourceDirByFileRefId(docRefId.ToString());
fileHelper.MoveFile(item.Document_Title, fileHelper.GetTempSourceDirByFileRefId(item.Document_Path), destinationPath);
// Save attachment
newScaleAttachment.Parent = scale;
newScaleAttachment.Document_RefId = docRefId;
newScaleAttachment.Document_Path = Path.Combine(destinationPath, item.Document_Title);
item.MapServiceEntityToServerEntity(newScaleAttachment);
libAttach.Add(newScaleAttachment);
}
}
// Complete transaction.
scope.Complete();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex) {
ExceptionHandler.HandleException(ex, "An error occured in SaveTicket.");
//string details = string.Format("Method: {1} {0} Message: {2} {0} Stack Trace: {3}", System.Environment.NewLine, "SaveTicket", ex.Message, ex.StackTrace.ToString());
//smART.Common.MessageLogger.Instance.LogMessage(ex, details, Common.Priority.High, 0, System.Diagnostics.TraceEventType.Error, "Service Error", "Service");
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
