public static string GetOrganizationName()
{
PartyLibrary partyLib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
Party orgParty = partyLib.GetByType("Organization").FirstOrDefault();
return(orgParty.Party_Name);
}
public static SelectList IndividualPartyList(object selectedItem)
{
ILibrary <Party> lib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Party> result = ((PartyLibrary)lib).GetByType("Individual");
SelectList sList = new SelectList(result, "ID", "License_No", selectedItem);
return(sList);
}
public static SelectList PartyList(string PartyType, object selectedItem)
{
ILibrary <Party> lib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Party> result = ((PartyLibrary)lib).GetByType(PartyType);
SelectList sList = new SelectList(result, "ID", "Party_Name", selectedItem);
return(sList);
}
public static Party GetPartyByID(string id)
{
int partyID = 0;
int.TryParse(id, out partyID);
ILibrary <Party> lib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
return(lib.GetByID(partyID.ToString()));
}
public static SelectList IndividualReportPartyList(object selectedItem)
{
Party selectDropDown = new Party()
{
ID = 0,
Party_Name = " -- Select Value ---"
};
IEnumerable <Party> selectList = new Party[] { selectDropDown };
ILibrary <Party> lib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Party> result = ((PartyLibrary)lib).GetByType("Individual");
selectList = selectList.Concat <Party>(result);
SelectList sList = new SelectList(selectList, "ID", "Party_Name", selectedItem);
return(sList);
}
public ActionResult Validate(Scale data)
{
ModelState.Clear();
data.Ticket_Type = ReceivingTicketType;
data.QScale = true;
if (string.IsNullOrEmpty(data.Ticket_Status))
{
data.Ticket_Status = TicketStatus.Open.ToString();
}
if (data.Party_ID != null && data.Party_ID.ID == 0 && !string.IsNullOrEmpty(data.Party_ID.License_No))
{
PartyLibrary partyLib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
Party party = partyLib.GetByLicenseNo(data.Party_ID.License_No);
if (party != null)
{
ModelState.AddModelError("Party", "Duplicate License#.");
}
}
// Request Status is required.
if (data.Ticket_Type != null && data.Ticket_Status.Contains("Select"))
{
ModelState.AddModelError("Ticket Status", "Request Status is a required field.");
}
// Ticket Type is required.
if (data.Ticket_Type != null && data.Ticket_Type.Contains("Select"))
{
ModelState.AddModelError("Ticket Type", "Ticket type is a required field.");
}
//// Vehicle Plate is required.
//if (string.IsNullOrEmpty(data.Vehicle_Plate_No))
// ModelState.AddModelError("Vehicle plate number ", "Vehicle plate number is a required field.");
if (data.Ticket_Status != null && data.Ticket_Status.ToLower().Contains("close"))
{
// Party is required
if (data.Party_ID.ID == 0 && string.IsNullOrEmpty(data.Party_ID.License_No))
{
ModelState.AddModelError("Party", "Driving licence number is a required field.");
}
// Item is reuired.
if (!IsLineItemExits(data.ID))
{
ModelState.AddModelError("ScaleDetails", "There is at least one line item is required in the item details.");
}
// Gross Weight is required.
if (data.Net_Weight <= 0)
{
ModelState.AddModelError("Net_Weight ", "Net weight is a required field.");
}
// Amount is required
if (data.Item_Amount <= 0)
{
ModelState.AddModelError("Amount", "Amount is a required field.");
}
// State is rquire
if (string.IsNullOrEmpty(data.State.Trim()))
{
ModelState.AddModelError("State", "State is a required field.");
}
// Zip Code is rquire
if (data.PrimaryAddress != null && string.IsNullOrEmpty(data.PrimaryAddress.Zip_Code))
{
ModelState.AddModelError("Zip_Code", "Zip code is a required field.");
}
// DOB is required
if (data.Party_ID != null && string.IsNullOrEmpty(data.Party_ID.Party_DOB))
{
ModelState.AddModelError("Party_DOB", "Party DOB is a required field.");
}
// Vehicle Year is required
if (string.IsNullOrEmpty(data.Vehicle_Year.Trim()))
{
ModelState.AddModelError("Vehicle_Year", "Vehicle Year is a required field.");
}
// Vehicle Sate is required
if (string.IsNullOrEmpty(data.Plate_State.Trim()))
{
ModelState.AddModelError("Plate_State", "Plate State is a required field.");
}
//// Amount is required
//if (data.Ticket_Settled)
// ModelState.AddModelError("Settled", "Ticket already paid.");
}
ValidQScaleItems(data);
if (!ModelState.IsValid)
{
return(Json(new {
success = false,
errors = ModelState.Errors()
}));
}
return(Json(new {
success = true,
errors = ""
}));
}
private void SaveThumbScannerAttachment(int Id, byte[] data, string fileName, EnumAttachmentRefType refType, FileFormat fileFormat, bool updateParty = true)
{
Guid guid = SaveFile(data, string.Format("{0}.{1}", fileName, fileFormat.ToString()));
ScaleAttachments attachments = new ScaleAttachments();
attachments.Document_Name = string.Format("{0}.{1}", fileName, fileFormat.ToString());// "Thumb-Image.jpeg";
attachments.Document_RefId = guid;
attachments.Document_Size = data.LongLength;
attachments.Document_Title = "Thumb-Image";
attachments.Document_Type = "jpeg";
attachments.Ref_Type = (int)refType;
attachments.Updated_By = User.Identity.Name;
attachments.Created_By = User.Identity.Name;
attachments.Created_Date = DateTime.Now;
attachments.Last_Updated_Date = DateTime.Now;
attachments.Parent = new Scale {
ID = Id
};
string destinationPath;
string sourcePath;
FilelHelper fileHelper = new FilelHelper();
destinationPath = fileHelper.GetSourceDirByFileRefId(attachments.Document_RefId.ToString()); // Path.Combine(Configuration.GetsmARTDocPath(), Scale.Document_RefId.ToString());
sourcePath = fileHelper.GetTempSourceDirByFileRefId(attachments.Document_RefId.ToString()); // Path.Combine(Configuration.GetsmARTTempDocPath(), Scale.Document_RefId.ToString());
attachments.Document_Path = fileHelper.GetFilePath(sourcePath);
if (Id > 0)
{
fileHelper.MoveFile(attachments.Document_Name, sourcePath, destinationPath);
ScaleAttachmentsLibrary ScaleLibrary = new ScaleAttachmentsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
attachments.Document_Name = string.Format("{0}.{1}", fileName, "jpg");
ScaleAttachments scaleAttachment = ScaleLibrary.Add(attachments);
if (updateParty)
{
Scale scale = new ScaleLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString()).GetByID(Id.ToString(), new string[] { "Party_ID" });
PartyLibrary partyLib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
Party party = partyLib.GetByID(scale.Party_ID.ID.ToString());
if (party != null)
{
party.PhotoRefId = scaleAttachment.Document_RefId.ToString();
partyLib.Modify(party);
}
}
}
else
{
if (Session["ScaleAttachments"] == null)
{
Session["ScaleAttachments"] = new List <ScaleAttachments>();
}
IList <ScaleAttachments> iList = (IList <ScaleAttachments>)Session["ScaleAttachments"];
iList.Add(attachments);
}
}
public JsonResult _SaveCustomerImages(string scaleId, string partyId)
{
try
{
if (!string.IsNullOrEmpty(partyId))
{
// Get party
PartyLibrary partyLib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
smART.ViewModel.Party party = partyLib.GetByID(partyId);
if (party != null)
{
FilelHelper fileHelper = new FilelHelper();
string filePath;
// Save Customer Image
if (!string.IsNullOrEmpty(party.PhotoRefId))
{
filePath = fileHelper.GetFilePathByFileRefId(party.PhotoRefId);
if (System.IO.File.Exists(filePath))
{
Byte[] photoBytes = fileHelper.GetBytesFromFile(filePath);
SaveAttachment(Convert.ToInt32(scaleId), photoBytes, CommonHelper.GetFileNameByDocType((int)EnumAttachmentRefType.Customer), EnumAttachmentRefType.Customer, FileFormat.jpeg);
}
}
// Signature Image
if (!string.IsNullOrEmpty(party.SignatureImageRefId))
{
filePath = fileHelper.GetFilePathByFileRefId(party.SignatureImageRefId);
if (System.IO.File.Exists(filePath))
{
Byte[] photoBytes = fileHelper.GetBytesFromFile(filePath);
SaveAttachment(Convert.ToInt32(scaleId), photoBytes, CommonHelper.GetFileNameByDocType((int)EnumAttachmentRefType.Signature), EnumAttachmentRefType.Signature, FileFormat.bmp);
}
}
// Thumb Image
if (!string.IsNullOrEmpty(party.ThumbImage1RefId))
{
filePath = fileHelper.GetFilePathByFileRefId(party.ThumbImage1RefId);
if (System.IO.File.Exists(filePath))
{
Byte[] photoBytes = fileHelper.GetBytesFromFile(filePath);
SaveAttachment(Convert.ToInt32(scaleId), photoBytes, CommonHelper.GetFileNameByDocType((int)EnumAttachmentRefType.Thumbprint1), EnumAttachmentRefType.Thumbprint1, FileFormat.jpg);
}
}
// License Image
if (!string.IsNullOrEmpty(party.LicenseImageRefId))
{
filePath = fileHelper.GetFilePathByFileRefId(party.LicenseImageRefId);
if (System.IO.File.Exists(filePath))
{
Byte[] photoBytes = fileHelper.GetBytesFromFile(filePath);
SaveAttachment(Convert.ToInt32(scaleId), photoBytes, CommonHelper.GetFileNameByDocType((int)EnumAttachmentRefType.DriverLicense), EnumAttachmentRefType.DriverLicense, FileFormat.jpg);
}
}
// Vehicle Image
if (!string.IsNullOrEmpty(party.VehicleImageRegId))
{
filePath = fileHelper.GetFilePathByFileRefId(party.VehicleImageRegId);
if (System.IO.File.Exists(filePath))
{
Byte[] photoBytes = fileHelper.GetBytesFromFile(filePath);
SaveAttachment(Convert.ToInt32(scaleId), photoBytes, CommonHelper.GetFileNameByDocType((int)EnumAttachmentRefType.Vehicle), EnumAttachmentRefType.Vehicle, FileFormat.jpg);
}
}
// Cash Card Image
if (!string.IsNullOrEmpty(party.CashCardImageRefId))
{
filePath = fileHelper.GetFilePathByFileRefId(party.CashCardImageRefId);
if (System.IO.File.Exists(filePath))
{
Byte[] photoBytes = fileHelper.GetBytesFromFile(filePath);
SaveAttachment(Convert.ToInt32(scaleId), photoBytes, CommonHelper.GetFileNameByDocType((int)EnumAttachmentRefType.CashCard), EnumAttachmentRefType.CashCard, FileFormat.jpg);
}
}
}
}
return(Json(new { Sucess = "True" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Sucess = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
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));
}
}
public string SaveTicketImage(String scaleId, string documentType)
{
var docfiles = new List <string>();
try {
int intScaleId = Convert.ToInt32(scaleId);
if (intScaleId <= 0)
{
throw new Exception("Invalid ticket id.");
}
int intDocType = Convert.ToInt32(documentType);
string fileName = CommonHelper.GetFileNameByDocType(intDocType);
if (string.IsNullOrEmpty(fileName))
{
throw new Exception("Invalid document type.");
}
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
// Get scale
Scale scale = new ScaleLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString()).GetByID(scaleId, new string[] { "Party_ID" });
if (scale == null)
{
throw new Exception("Given scale id not found in database.");
}
FilelHelper fileHelper = new FilelHelper();
foreach (string file in httpRequest.Files)
{
// Save file
string docRefID = Guid.NewGuid().ToString();
var destinationPath = fileHelper.GetSourceDirByFileRefId(docRefID); // Path.Combine(Configuration.GetsmARTTempDocPath(), docRefID);
fileHelper.CreateDirectory(destinationPath);
var postedFile = httpRequest.Files[file];
postedFile.SaveAs(Path.Combine(destinationPath, fileName));
docfiles.Add(docRefID);
// Add attachment
ScaleAttachments attachments = new ScaleAttachments();
attachments.Document_Name = fileName;
attachments.Document_RefId = new Guid(docRefID);
attachments.Document_Size = 0;
attachments.Document_Title = fileName;
attachments.Document_Type = "jpeg";
attachments.Ref_Type = intDocType;
attachments.Updated_By = User.Identity.Name;
attachments.Created_By = User.Identity.Name;
attachments.Created_Date = DateTime.Now;
attachments.Last_Updated_Date = DateTime.Now;
attachments.Parent = new Scale {
ID = intScaleId
};
attachments.Document_Path = destinationPath;
ScaleAttachmentsLibrary ScaleLibrary = new ScaleAttachmentsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
attachments.Document_Name = fileName;
ScaleAttachments scaleAttachment = ScaleLibrary.Add(attachments);
// Update file ref in party master
if (scale.Party_ID != null && scale.Party_ID.ID > 0)
{
PartyLibrary partyLib = new PartyLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
Party party = partyLib.GetByID(scale.Party_ID.ID.ToString());
if (party != null)
{
SetPartyImageRefByDocType(intDocType, scaleAttachment.Document_RefId.ToString(), party);
partyLib.Modify(party);
}
}
}
}
}
catch (Exception ex) {
//string details = string.Format("Method: {1} {0} Message: {2} {0} Stack Trace: {3}", System.Environment.NewLine, "SaveTicketImage", ex.Message, ex.StackTrace.ToString());
ExceptionHandler.HandleException(ex, "An error occured in SaveTicketImage utils.");
//smART.Common.MessageLogger.Instance.LogMessage(ex, details, Common.Priority.High, 0, System.Diagnostics.TraceEventType.Error, "Service Error", "Service");
}
return(docfiles.FirstOrDefault());
}
