public HttpResponseMessage CreateClient([FromBody] RequestImport request) { HttpResponseMessage message; var isSuccess = false; var msg = "Client Name already exists"; var name = request.Name; //validate clientno var validationResult = validateRequest(request); if (!validationResult.isSuccess) { message = Request.CreateResponse(HttpStatusCode.OK, new{ message = validationResult.message, validationResult.isSuccess }); return(message); } var clientNo = Convert.ToInt32(request.clientNo); using (EverestPortalContext context = new EverestPortalContext()) { if (!context.Clients.Any(c => c.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase))) { if (!string.IsNullOrEmpty(name)) { var newClient = new Client() { Name = name, IsMyClient = false }; newClient = context.Clients.Add(newClient); context.SaveChanges(); context.ClientMaps.Add(new ClientMap { ClientId = newClient.Id, IRPClientNo = Convert.ToInt16(clientNo) }); context.SaveChanges(); isSuccess = true; msg = "Client successfully created"; } else { msg = "Enter the valid name"; } } else { msg = "Client Name already exists"; } } var result = new { message = msg, isSuccess }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); }
private dynamic validateRequest(RequestImport request) { var isSuccess = true; var msg = ""; if (string.IsNullOrEmpty(request.clientNo)) { msg = "Client number cannot be empty."; isSuccess = false; } else { var clientNo = 0; if (int.TryParse(request.clientNo, out clientNo)) { if (clientNo <= 0) { msg = "Client number needs to be greater than zero."; isSuccess = false; } else { using (EverestPortalContext context = new EverestPortalContext()) { if (context.ClientMaps.Any(c => c.IRPClientNo.ToString() == request.clientNo.Trim())) { msg = "Client number already exists."; isSuccess = false; } } } } else { msg = "Client number needs to be an integer."; isSuccess = false; } } var result = new { message = msg, isSuccess }; return(result); }
public HttpResponseMessage ImportTerritories(RequestImport req) { //var clientid = req.clientId; HttpResponseMessage message; var selectedClients = req.selectedClients; using (EverestPortalContext context = new EverestPortalContext()) { if (req.selectAll) { return(ImportTerritoriesForAllClients("IRP_Import_Territory_All", req.EmailId)); } } var drs = executeImportTerritoryDefinitions(selectedClients); string msg = "Territory definitions are imported sucessfully"; if (drs.Count == 0) { msg = "No territory definitions are imported"; } var logCollection = drs.Select(row => new { clientId = Convert.ToString(row["ClientId"]), clientName = Convert.ToString(row["ClientName"]), dimensionId = Convert.ToString(row["DimensionId"]), territoryDefinition = Convert.ToString(row["TerritoryDefinition"]), status = Convert.ToString(row["Status"]), timeOfImport = Convert.ToString(row["TimeOfImport"]), username = Convert.ToString(row["UserName"]) }).ToList(); var result = new { message = msg, isSuccess = true, log = logCollection }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); }
public HttpResponseMessage ExportTdw([FromBody] RequestImport req) { HttpResponseMessage message; var clientIds = req.selectedClients; if (req.selectAll) { using (EverestPortalContext context = new EverestPortalContext()) { var clients = context.Clients.ToList(); clientIds = new List <int>(); foreach (var ic in clients) { if (ic.Id != null) { clientIds.Add(Convert.ToInt32(ic.Id)); } } } } foreach (var id in clientIds) { insertClient(id); } //Execute job excuteJobExportTdw(); //saves the history details for the export TDW SaveTdwExportHistory(clientIds, req.selectAll); var result = new { message = "exported to TDW successfully", isSuccess = true }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); }
public HttpResponseMessage ImportMarkets(RequestImport req) { try { //var clientid = req.clientId; HttpResponseMessage message; var selectedClients = req.selectedClients; using (EverestPortalContext context = new EverestPortalContext()) { if (req.selectAll) { return(ImportMarketsForAllClients("IRP_Import_Market_All", req.EmailId)); //var importedClients = (from c in context.Clients // join // cm in context.ClientMaps on c.Id equals cm.ClientId // select c.Id).Distinct().ToList(); ////var clients = context.Clients.ToList(); //selectedClients = new List<int>(); //foreach (var ic in importedClients) //{ // if (ic != null) // { // selectedClients.Add(Convert.ToInt32(ic)); // } //} } } var drs = executeImportMarketDefinitions(selectedClients); string msg = "Market definitions imported sucessfully"; if (drs.Count == 0) { msg = "No market definitions are imported"; } var logCollection = drs.Select(row => new { clientId = Convert.ToString(row["ClientId"]), clientName = Convert.ToString(row["ClientName"]), dimensionId = Convert.ToString(row["DimensionId"]), marketDefinition = Convert.ToString(row["MarketDefinition"]), status = Convert.ToString(row["Status"]), timeOfImport = Convert.ToString(row["TimeOfImport"]), username = Convert.ToString(row["UserName"]) }).ToList(); var result = new { message = msg, isSuccess = true, log = logCollection }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); } catch (Exception ex) { throw ex; } }
public HttpResponseMessage ImportDeliverablesAndSubscriptionForClient(RequestImport req) { //var clientid = req.clientId; HttpResponseMessage message; var selectedClientIds = req.selectedClients; var importMessage = string.Empty; try { if (req.selectAll) { return(ImportDeliverablesforAllClients("IRP_Import_Subscription_Deliverables_All", req.EmailId)); } using (EverestPortalContext context = new EverestPortalContext()) { //if (req.selectAll) //{ // return ImportDeliverablesforAllClients("IRP_Import_Subscription_Deliverables_All"); //var clients = context.ClientMaps.ToList(); //selectedClientIds = new List<int>(); //foreach (var ic in clients) //{ // if (ic.ClientId != null) // { // selectedClientIds.Add(Convert.ToInt32(ic.ClientId)); // } //} // } List <DataRow> nonIAMCollection = new List <DataRow>(); List <DataRow> IAMCollection = new List <DataRow>(); List <DataRow> subResponse = new List <DataRow>(); List <DataRow> deliResponse = new List <DataRow>(); foreach (var clientid in selectedClientIds) { List <DataRow> subTempResponse = new List <DataRow>(); List <DataRow> deliTempResponse = new List <DataRow>(); var clientNo = context.ClientMaps.FirstOrDefault(c => c.ClientId == clientid).IRPClientNo; executeDeliverablesIAM(clientNo, ref subTempResponse, ref deliTempResponse); subResponse.AddRange(subTempResponse); deliResponse.AddRange(deliTempResponse); subTempResponse = new List <DataRow>(); deliTempResponse = new List <DataRow>(); executeDeliverablesNonIAM(clientNo, ref subTempResponse, ref deliTempResponse); subResponse.AddRange(subTempResponse); deliResponse.AddRange(deliTempResponse); } var dataDeli = deliResponse.Select(dr => new { SubscriptionId = dr != null ? Convert.ToString(dr["SubscriptionId"]) : "", DeliverableId = dr != null ? Convert.ToString(dr["DeliverableId"]) : "", Frequency = dr != null ? Convert.ToString(dr["Frequency"]) : "", FrequencyType = dr != null ? Convert.ToString(dr["FrequencyType"]) : "", Period = dr != null ? Convert.ToString(dr["Period"]) : "", Status = dr != null ? Convert.ToString(dr["Status"]) : "" }); var dataSub = subResponse.Select(dr => new { SubscriptionId = dr != null ? Convert.ToString(dr["SubscriptionId"]) : "", Country = dr != null ? Convert.ToString(dr["Country"]) : "", Service = dr != null ? Convert.ToString(dr["Service"]) : "", TerritoryBase = dr != null ? Convert.ToString(dr["TerritoryBase"]) : "", DataType = dr != null ? Convert.ToString(dr["DataType"]) : "", ClienId = dr != null ? Convert.ToString(dr["ClientId"]) : "", Status = dr != null ? Convert.ToString(dr["Status"]) : "" }); var result = new { sResponse = dataSub, dResponse = dataDeli, IsSelectAll = false, importMessage }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); } } catch (Exception ex) { string exMessage = ex.Message; throw ex; } }
public HttpResponseMessage ImportClients([FromBody] RequestImport request) { HttpResponseMessage message; using (EverestPortalContext context = new EverestPortalContext()) { var isSuccess = false; List <int> clientids = request.selectedClients; if (request.selectAll) { var irpclients = context.IRPClients.ToList(); clientids = new List <int>(); foreach (var ic in irpclients) { if (ic.ClientId != null) { clientids.Add(Convert.ToInt32(ic.ClientId)); } } } foreach (var clientid in clientids) { if (!context.ClientMaps.Any(x => x.IRPClientId == clientid)) { var irpClient = context.IRPClients.FirstOrDefault(i => i.ClientId == clientid); if (irpClient != null && !string.IsNullOrEmpty(irpClient.ClientName)) { var newClient = new Client() { Name = irpClient.ClientName, IsMyClient = false }; if (!context.Clients.Any(c => c.Name == newClient.Name)) { context.Clients.Add(newClient); context.SaveChanges(); context.ClientMaps.Add(new ClientMap { ClientId = newClient.Id, IRPClientId = irpClient.ClientId, IRPClientNo = irpClient.ClientNo, }); context.SaveChanges(); } } } isSuccess = true; } var result = new { message = "selected client is successfully imported", isSuccess }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); } }