public JsonResult Add(string clientId, string partnerId, string carrierId,
string partnerEDINo, string eDIDocCode, string eDIDocType, string directory,
string line, string entryName, string import, string importNote)
{
string result = string.Empty;
int intValue;
ClientService clientService = new ClientService();
PartnerService partnerService = new PartnerService();
try
{
ClientPartner clientPartner = new ClientPartner();
Client queryClient = clientService.GetByClientId(clientId);
if(queryClient != null)
{
clientPartner.Client = unitOfWork.ClientRepository.GetByID(queryClient.Id);
}
clientPartner.CarrierId = carrierId != null ? carrierId : String.Empty;
clientPartner.PartnerEDINo = partnerEDINo != null ? partnerEDINo : String.Empty;
clientPartner.EDIDocCode = eDIDocCode != null ? eDIDocCode : String.Empty;
clientPartner.EDIDocType = eDIDocType != null ? eDIDocType : String.Empty;
clientPartner.Directory = directory != null ? directory : String.Empty;
Partner queryPartner = partnerService.GetByPartnerId(partnerId);
if (queryPartner != null)
{
clientPartner.Partner = unitOfWork.PartnerRepository.GetByID(queryPartner.Id);
}
clientPartner.Line = Int32.TryParse(line, out intValue) ? intValue : 0;
clientPartner.EntryName = entryName;
clientPartner.Import = import;
clientPartner.ImportNote = importNote;
unitOfWork.ClientPartnerRepository.Insert(clientPartner);
unitOfWork.Save();
}
catch (Exception ex)
{
result = ex.Message;
}
return Json(result);
}
public ActionResult GetListClients()
{
ClientService clientService = new ClientService();
return Json(clientService.GetAllExposeDto().OrderBy(m => m.ClientName), JsonRequestBehavior.AllowGet);
}
public ActionResult GetList(JQueryDataTableParamModel param)
{
ClientService clientService = new ClientService();
var allClients = clientService.GetAllExposeDto();
IEnumerable<ClientDto> filteredClients;
if (!string.IsNullOrEmpty(param.sSearch))
{
//Used if particulare columns are filtered
var clientIdFilter = Convert.ToString(Request["sSearch_1"]);
//Optionally check whether the columns are searchable at all
var isClientIdSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
filteredClients = allClients
.Where(c => isClientIdSearchable && c.Name != null && c.Name.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredClients = allClients;
}
var isClientIdSortable = Convert.ToBoolean(Request["bSortable_1"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func<ClientDto, string> orderingFunction = (c => sortColumnIndex == 1 && isClientIdSortable ? c.ClientId.ToString() :
"");
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
filteredClients = filteredClients.OrderBy(orderingFunction);
else
filteredClients = filteredClients.OrderByDescending(orderingFunction);
IEnumerable<ClientDto> displayedClients;
if (param.iDisplayLength != -1)
displayedClients = filteredClients.Skip(param.iDisplayStart).Take(param.iDisplayLength);
else
displayedClients = filteredClients;
var result = from c in displayedClients
select new[]
{
c.Id.ToString(),
c.IsActive,
c.ClientId,
c.ClientName,
c.ShortName,
c.AddressLine1,
c.AddressLine2,
c.City,
c.State,
c.Postcode,
c.EDINo,
c.Mfrid,
c.NextPack,
c.EndPack,
c.NextASN,
c.SupplierNo,
c.TaxNo,
c.ABN,
c.Phone,
c.ClientContactEmail,
c.AQRAMEmail,
c.FreightforwarderEmail,
c.Line.ToString(),
c.EntryName,
c.Import,
c.ImportNote
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = allClients.Count(),
iTotalDisplayRecords = filteredClients.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
public ActionResult Index()
{
ClientService clientService = new ClientService();
PartnerService partnerService = new PartnerService();
ClientPartnerModel model = new ClientPartnerModel();
model.Clients = clientService.GetAllExposeDto().ToList();
model.Partners = partnerService.GetAllExposeDto().ToList();
return View(model);
}
