public ActionResult UpdateServiceOrderPartLines(string uniqueId, string serviceOrderNo, string transactionType, string technicinanNo, string quantity, string specialityCode, string failureCode, string lineProperty, string serviceOrderRelation, string description, string serviceComments, string itemNumber, string site, string wareHouse, string transSerialCodeNo, string colorId, string sizeId, string configId, string locationId) { string userName = null; bool isSuccess = false; userName = User.Identity.Name.ToString().Split('\\')[1]; try { SerivceOrderPartLine serviceOrderPartLine = new SerivceOrderPartLine(); isSuccess = serviceOrderPartLine.UpdateServiceOrderPartLines(uniqueId, serviceOrderNo, transactionType, technicinanNo, quantity, specialityCode, failureCode, lineProperty, serviceOrderRelation, description, serviceComments, itemNumber, site, wareHouse, transSerialCodeNo, colorId = "", sizeId = "", configId = "", locationId, userName); if (isSuccess) { ViewData["ServiceOrderPartLines"] = GetServiceOrderPartLinesByServiceOrderID(serviceOrderNo); } else { throw new Exception("Service Order Part Lines updation failed"); } TempData.Keep(); } catch (Exception ex) { TempData.Keep(); if (!isSuccess) { ExceptionLog.LogException(ex, userName); throw ex; } } return(View("ServiceOrderPartLinesView")); }
public HttpResponseMessage CreateNewClient([FromBody] ClientServiceModel clientServiceModel) { try { Client client = clientServiceModel.client; client.DateLastUpdated = DateTime.Now; if (client.ParentID == null) { client.ParentID = 0; client.DivisionName = client.ClientName; } context.Clients.InsertOnSubmit(client); context.SubmitChanges(); foreach (int clientService in clientServiceModel.clientServices) { context.Client_Services.InsertOnSubmit(new Client_Service { ClientID = client.ClientID, ServiceID = clientService }); } context.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, client.ClientID)); } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage GetClaimFileDataForUser(string Token) { try { using (context = new OrgSys2017DataContext()) { var filters = context.GetFilteredData(Token, "Document")?.ToList(); var userRoleName = context.GetUserRole(Token).FirstOrDefault().RoleName; var qservice = new QueryService("Claim_Documents", "Document", Token); if (filters == null && userRoleName != "OSIUser") { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } var dataView = context.GetPortalPortalDataView(Token, "Document").ToList(); var query = qservice.BuildQuery(dataView, filters); var con = new Connection(); var result = con.SelectData(query); return(Request.CreateResponse(HttpStatusCode.OK, result)); } } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage UpdateSessionClient(string token, int clientId) { try { using (var con = new OrgSys2017DataContext()) { var isSessionActive = con.CheckIfTokenValid(token) == 10001; if (!isSessionActive) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); } var session = con.Sessions.Single(x => x.SessionToken == token); var user = con.Users.Single(x => x.UserID == int.Parse(session.UserID)); var isInternalUser = user.UserType == 1; //all internal users have a default clientId of 0 in session table var hasPermission = (isInternalUser && clientId == 0) ? true : con.ClientDivisionUserViews.Any(x => x.UserID == user.UserID && x.RootClientID == clientId); if (!hasPermission || !isInternalUser) { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } con.Sessions.Single(x => x.SessionToken == token).ClientID = clientId + ""; con.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
// POST: api/ProductionSchedule public string Post(HttpRequestMessage value) { try { string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5); JObject json = JObject.Parse(message); DateTime date = new DateTime(); date = (DateTime)json["date"]; Production_Schedule ps = new Production_Schedule(); ps = (from p in db.Production_Schedule where DbFunctions.TruncateTime(p.Production_Schedule_Date) == DbFunctions.TruncateTime(date) select p).FirstOrDefault(); if (ps == null) { generateProductionSchedule(); } else { return("false|Production schedule has already been generated."); } return("true|Succesfully generated production schedule."); } catch (Exception e) { ExceptionLog.LogException(e, "ProductionScheduleController POST"); return("false|Failed to generate Production Schedule."); } }
// GET: api/PartType/5 public string Get(int id) { try { JObject result = JObject.FromObject(new { blueprints = from p in db.Part_Blueprint orderby p.Name where p.Part_Type_ID == id select new { Name = p.Name, Blueprint_ID = p.Blueprint_ID, File_Type = p.File_Type, Removed = false } }); return("true|" + result.ToString()); } catch (Exception e) { ExceptionLog.LogException(e, "BluePrintController GET ID"); return("false|Failed to retrieve blueprints for part type # " + id + "."); } }
// GET: api/UniqueRawMaterial/5 public string Get(int id) { try { JObject result = JObject.FromObject(new { unique_raw_materials = from p in db.Unique_Raw_Material join rm in db.Raw_Material on p.Raw_Material_ID equals rm.Raw_Material_ID orderby rm.Name where p.Unique_Raw_Material_ID == id select new { Raw_Material_ID = p.Raw_Material_ID, Raw_Material_Name = rm.Name, Raw_Material_Description = rm.Description, Unique_Raw_Material_ID = p.Unique_Raw_Material_ID, Dimension = p.Dimension, Quality = p.Quality, Date_Added = p.Date_Added, Date_Used = p.Date_Used, Cost_Price = p.Cost_Price, Supplier_Order_ID = p.Supplier_Order_ID } }); return("true|" + result.ToString()); } catch (Exception e) { ExceptionLog.LogException(e, "UniqueRawMaterial GET ID"); return("false|Failed to retrieve Unique Raw Material."); } }
public HttpResponseMessage GetPortalClaimManagerData(string Token, string StatusString, [FromBody] ClaimManagerFieldList Fields) { try { var status = ""; switch (StatusString) { case "open": status = "(9, 19)"; break; case "closed": status = "(29)"; break; case "draft": status = "(0)"; break; default: status = ""; break; } var qservice = new QueryService("Claims", "Claim", Token); //if the same table needs to be joined multiple times, the correct aliases must be referenced in [PermissionDataFilter] table //qservice.JoinTableList.Add($" LEFT JOIN [Claim_UserAssigned] ON [Claim_UserAssigned].[ClaimReferenceNumber] = [Claims].[ClaimRefNu] "); qservice.JoinTableList.Add($" INNER JOIN [User_Profiles] ON [User_Profiles].[UserID] = [Session].[UserID] "); qservice.WhereClauseQueryList.Add($" [Claims].ClientID = [ClientDivisionUserView].[ClientID] "); qservice.WhereClauseQueryList.Add($" [Claims].[Status] IN {status} "); qservice.WhereClauseQueryList.Add($" [Claims].Archived = 0 "); qservice.WhereClauseQueryList.Add($" Claims.Description IN(SELECT SL.Abbreviation FROM User_Service_Permission as USP INNER JOIN Services_LookUp as SL on USP.ServiceTypeID = SL.ServiceID WHERE USP.UserID = Session.UserID AND Claims.ClientID = USP.ClientID)"); qservice.SelectColumnList.Add("[Claims].ClaimID"); qservice.SelectColumnList.Add("[Claims].Description"); context = new OrgSys2017DataContext(); var filters = context.GetFilteredData(Token, "Claim")?.ToList(); var UserRoleName = context.GetUserRole(Token).FirstOrDefault()?.RoleName; //at this time, users are only assigned a single role if ((filters == null && UserRoleName != "OSIUser") || UserRoleName == null) { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } var dataView = context.GetPortalPortalDataView(Token, "Claim").ToList(); var query = qservice.BuildQueryFromPermissions(dataView, filters); var con = new Connection(); var result = con.SelectData(query); var response = Request.CreateResponse(); response.Content = new StringContent(result); return(response); } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
// GET: api/UniqueMachineStatusses public string Get() { try { JObject result = JObject.FromObject(new { unique_machine_statuses = from p in db.Machines join b in db.Unique_Machine on p.Machine_ID equals b.Machine_ID orderby p.Name select new { Unique_Machine_ID = b.Unique_Machine_ID, Unique_Machine_Serial = b.Unique_Machine_Serial, Machine_Status_ID = b.Machine_Status_ID, Manufacturer = p.Manufacturer, Model = p.Model, Name = p.Name } }); return("true|" + result.ToString()); } catch (Exception e) { ExceptionLog.LogException(e, "UniqueMachineStatusController GET"); return("false|Failed to retrieve Unique Machines Statuses."); } }
// POST: api/UniqueMachineStatusses public string Post(HttpRequestMessage value) { try { Model.Unique_Machine mach = new Model.Unique_Machine(); string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5); JArray machineDetails = JArray.Parse(message); foreach (JObject mac in machineDetails) { int um_ID = (int)mac["Unique_Machine_ID"]; mach = (from p in db.Unique_Machine where p.Unique_Machine_ID == um_ID select p).First(); mach.Machine_Status_ID = (int)mac["Machine_Status_ID"]; } db.SaveChanges(); return("true|Unique Machine Statuses successfully updated."); } catch (Exception e) { ExceptionLog.LogException(e, "UniqueMachineStatusController POST"); return("false|An error has occured updating the Unique Machine Statuses on the system."); } }
public HttpResponseMessage GetUserProfile(string token) { try { using (OrgSys2017DataContext context = new OrgSys2017DataContext()) { UserProfile profile = new UserProfile(); var USER_ID = context.GetUserIDSession(token).SingleOrDefault().UserID; //gets the two most recent sessions by ther user var LastLoginTime = (from Session in context.Sessions where Session.UserID == USER_ID.ToString() orderby Session.SessionID descending select Session).Take(2).ToList(); var UserName = (from User_Profile in context.User_Profiles where User_Profile.UserID == USER_ID select User_Profile.EmpFirstName + " " + User_Profile.EmpLastName); profile.USER_ID = USER_ID; profile.Name = UserName.First(); profile.previousSessions = LastLoginTime; //return a json object of the 2 most recent sessions return(Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(profile))); } } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public HttpResponseMessage EmployeeOptionsExternal(string token) { try { var clientId = con.GetClientIDBySession(token).SingleOrDefault().ClientID; var clientDivisions = con.GetClientDivisions(Convert.ToInt32(clientId)); List <int?> divisionIds = clientDivisions.Select(division => division.ClientID).ToList(); //using the same filter(s) as for claim since user cannot create a claim for an employee they cannot view var filters = con.GetFilteredData(token, "Claim").ToList(); if (filters.FindIndex(f => f.FilterValue == "DIVISION_TREE") > -1) { var userProfiles = (from UserProfile in con.User_Profiles where divisionIds.Contains(UserProfile.ClientID) select UserProfile).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(userProfiles))); } else if (filters.FindIndex(f => f.FilterValue == "DIVISION") > -1) { var userProfiles = (from UserProfile in con.User_Profiles where UserProfile.ClientID == clientId select UserProfile).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(userProfiles))); } else { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage UpdateUser(string token, int userId, [FromBody] User user) { try { if (!hasAuthorizedRole(con, token)) { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } var target = con.Users.Single(x => x.UserID == userId); if (target == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } target.Active = user.Active; con.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.NoContent)); } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage Register(string token, [FromBody] UserRegistration user) { try { if (!hasAuthorizedRole(con, token)) { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } var salt = MembershipProvider.CreateNewSalt(); var hash = MembershipProvider.GenerateHash(user.PasswordClear, salt); var userId = con.OnboardUser(user.Username, hash, Convert.ToBase64String(salt), user.ClientID, user.LastName, user.FirstName, user.DOB, user.Email, user.UserTypeID, user.DivisionID); var role = new User_Role { Role_ID = user.RoleID, UserID = userId, DateCreated = DateTime.Now, isActive = true }; con.User_Roles.InsertOnSubmit(role); con.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, userId)); } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
protected bool ChangePassword(string token, UserAcc account) { try { var isActive = con.ValidatePasswordRecoveryAttempt(token, account.username) == 1; if (isActive) { var user = con.GetUserInfo(account.username).SingleOrDefault(); if (user != null) { //check if the user actually exists string SHASalt = MembershipProvider.CreateNewSaltString(); //Create Salt String byte[] saltBytes = Convert.FromBase64String(SHASalt); //Convert Salt String //Generte Hash and Salt for new password and add it to the Database var SHAHash = MembershipProvider.GenerateHash(account.password, saltBytes); //used only for external, so set permission to 2 con.Set_PasswordPermissions(user.UserID.ToString(), SHAHash, SHASalt); return(true); } else { return(false); //user doesnt exist } } else { return(false); //username is null } } catch (Exception ex) { ExceptionLog.LogException(ex); return(false); //error occured } }
public HttpResponseMessage GetClientLogo(string token) { try { using (context = new OrgSys2017DataContext()) { var logoFileName = context.GetClientLogo(token).SingleOrDefault().LogoPath; var filePath = $@"\\OSI-DEV01\umbrella\logos\{logoFileName}"; var mimeType = Path.GetExtension(filePath) == "png" ? "image/png" : "image/jpeg"; var logoBytes = File.ReadAllBytes(filePath); var base64Data = Convert.ToBase64String(logoBytes); var response = new HttpResponseMessage(HttpStatusCode.OK); response.Content = new StringContent(JsonConvert.SerializeObject(new { imageBase64 = $"data:{mimeType};base64,{base64Data}" })); return(response); } } catch (Exception e) { ExceptionLog.LogException(e); return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } }
// GET: api/SupplierQuote public string Get() { try { JObject result = JObject.FromObject(new { supplier_quotes = from p in db.Supplier_Quote select new { Supplier_Quote_ID = p.Supplier_Quote_ID, Supplier_Quote_Serial = p.Supplier_Quote_Serial, Supplier_Quote_Date = p.Supplier_Quote_Date, Supplier_ID = p.Supplier_ID, Supplier_Name = p.Supplier.Name, Supplier_Quote_Expiry_Date = p.Supplier_Quote_Expiry_Date, rms = from d in db.Supplier_Quote_Detail_Raw_Material where d.Supplier_Quote_ID == p.Supplier_Quote_ID select new { Raw_Material_ID = d.Raw_Material_ID, Raw_Material_Name = d.Raw_Material.Name, Quantity = d.Quantity, Price = d.Price, Dimension = d.Dimension }, cs = from d in db.Supplier_Quote_Component where d.Supplier_Quote_ID == p.Supplier_Quote_ID select new { Component_ID = d.Component_ID, Component_Name = d.Component.Name, Quantity_Requested = d.Quantity_Requested, Price = d.Price }, ps = from d in db.Supplier_Quote_Detail_Part where d.Supplier_Quote_ID == p.Supplier_Quote_ID select new { Part_Type_Name = d.Part_Type.Name, Part_Type_ID = d.Part_Type_ID, Quantity = d.Quantity, Price = d.Price } } }); return("true|" + result.ToString()); } catch (Exception e) { ExceptionLog.LogException(e, "SupplierQuoteController GET"); return("false|Failed to retrieve Supplier Quotes."); } }
public HttpResponseMessage UpdateBillingItem([FromBody] string billDetails, string token) { if (con.CheckIfTokenValid(token) != 10001 && con.IsUserInternal(token) == 1) { return(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } try { BillingDetail UpdateBill = JsonConvert.DeserializeObject <BillingDetail>(billDetails); BillingDetail OldBill = con.BillingDetails.SingleOrDefault(i => i.BillID == UpdateBill.BillID); OldBill.BillDate = UpdateBill.BillDate; OldBill.CompletionDate = UpdateBill.CompletionDate; OldBill.BillMethod = UpdateBill.BillMethod; OldBill.BillReason = UpdateBill.BillReason; OldBill.BillDuration = UpdateBill.BillDuration; OldBill.DirectContact = UpdateBill.DirectContact; OldBill.Postage = UpdateBill.Postage; OldBill.Courier = UpdateBill.Courier; OldBill.Billable = UpdateBill.Billable; OldBill.Comments = UpdateBill.Comments; OldBill.ClientID = UpdateBill.ClientID; con.SubmitChanges(); return(new HttpResponseMessage(HttpStatusCode.OK)); } catch (Exception ex) { ExceptionLog.LogException(ex); return(new HttpResponseMessage(HttpStatusCode.BadRequest) { Content = new StringContent(JsonConvert.SerializeObject(ex)) }); } }
// GET: api/UpdatePartStatus public string Get() { try { JObject result = JObject.FromObject(new { parts = from p in db.Parts join pt in db.Part_Type on p.Part_Type_ID equals pt.Part_Type_ID orderby p.Part_Serial where p.Part_Status_ID == 1 || p.Part_Status_ID == 2 || p.Part_Status_ID == 6 select new { Part_ID = p.Part_ID, Part_Serial = p.Part_Serial, Part_Status_ID = p.Part_Status_ID, Date_Added = p.Date_Added, Name = pt.Name, Part_Stage = p.Part_ID, Job_Card_ID = from j in db.Job_Card where j.Job_Card_Detail.Any(x => x.Parts.Any(y => y.Part_ID == p.Part_ID)) select j.Job_Card_ID } }); return("true|" + result.ToString()); } catch (Exception e) { ExceptionLog.LogException(e, "UpdatePartStatusController GET"); return("false|Failed to retrieve Part Statuses."); } }
private void updateChildren(int part_ID, int status, int job_card_ID) { try { if (status == 2)//I.e Completed { List <Job_Card_Detail> details = (from d in db.Job_Card_Detail where d.Job_Card_ID == job_card_ID select d).ToList(); foreach (Job_Card_Detail det in details) { List <Part> parts = (from d in db.Parts where d.Job_Card_Detail.Contains(db.Job_Card_Detail.Where(x => x.Job_Card_Details_ID == det.Job_Card_Details_ID).FirstOrDefault()) && d.Parent_ID == part_ID select d).ToList(); foreach (Part p in parts) { if (p.Part_Status_ID == 1 || p.Part_Status_ID == 2 || p.Part_Status_ID == 3) { p.Part_Status_ID = 7; } } } db.SaveChanges(); } } catch (Exception e) { ExceptionLog.LogException(e, "JobCardController updateChildren"); } }
// POST: api/UpdatePartStatus public string Post(HttpRequestMessage value) { try { string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5); JArray partStatusDetails = JArray.Parse(message); foreach (JObject partObject in partStatusDetails) { Model.Part ps = new Model.Part(); int part_id = (int)partObject["Part_ID"]; ps = (from p in db.Parts where p.Part_ID == part_id select p).First(); ps.Part_Status_ID = (int)partObject["Part_Status_ID"]; } db.SaveChanges(); return("true|Part Statuses successfully updated on the system."); } catch (Exception e) { ExceptionLog.LogException(e, "UpdatePartStatusController POST"); return("false|An error has occured updating the Part Statuses on the system."); } }
public ActionResult UpdateRepairLineItems(string uniqueId, string serviceOrderNo, string serialNumberList, string serviceOrderRelation, string conditionId, string symptomAreaId, string symptomCodeId, string diagnosisAreaId, string diagnosisCodeId, string resolutionId, string repairStageId, string technicianNo, string description, string serviceComments) { string userName = null; bool isSuccess = false; try { userName = User.Identity.Name.ToString().Split('\\')[1]; RepairType repairType = new RepairType(); isSuccess = repairType.UpdateRepairLineItems(uniqueId, serviceOrderNo, serialNumberList, conditionId, symptomAreaId, symptomCodeId, diagnosisAreaId, diagnosisCodeId, resolutionId, repairStageId, technicianNo, description, serviceComments, userName); if (isSuccess) { TempData["ServiceOrderId"] = serviceOrderNo; Session["SID"] = serviceOrderNo; } ViewData["RepairLinesList"] = GetRepairLinesDetails(TempData["ServiceOrderId"].ToString()); TempData.Keep(); } catch (Exception ex) { TempData.Keep(); if (!isSuccess) { ExceptionLog.LogException(ex, userName); throw ex; } } return(View("RepairLineDetails")); }
public void UpdateClient(string token, [FromBody] Client updatedClient) { try { var userId = context.GetUserIDSession(token).SingleOrDefault().UserID; var originalClient = context.Clients .Where(x => x.ClientID == updatedClient.ClientID) .SingleOrDefault(); var propertiesNotUpdated = new List <string> { "User_Groups", "UserID", "LogoPath", "IsActive", "ImportID", "OrgsysDivisionID", "DivisionName", "ParentID" }; var properties = typeof(Client).GetProperties().Where(x => !propertiesNotUpdated.Contains(x.Name)); //update entity properties foreach (var p in properties) { p.SetValue(originalClient, p.GetValue(updatedClient)); } originalClient.DateLastUpdated = DateTime.Now; originalClient.LastUpdatedByUserID = userId; context.SubmitChanges(); } catch (Exception e) { ExceptionLog.LogException(e); } }
// GET: api/UniqueMachine/5 public string Get(int id) { try { JObject result = JObject.FromObject(new { unique_machines = from p in db.Unique_Machine orderby p.Unique_Machine_Serial where p.Unique_Machine_ID == id select new { Unique_Machine_ID = p.Unique_Machine_ID, Unique_Machine_Serial = p.Unique_Machine_Serial, Machine_Status_ID = p.Machine_Status_ID, Machine_ID = p.Machine_ID } }); return("true|" + result.ToString()); } catch (Exception e) { ExceptionLog.LogException(e, "UniqueMachineController GET ID"); return("false|Failed to retrieve Unique Machines."); } }
public void AddClient(string token, [FromBody] Client client) { try { var userId = context.GetUserIDSession(token).SingleOrDefault().UserID; var userGroup = new User_Group { UserID = userId, AssignDate = DateTime.Now, DateFrom = DateTime.Now, DateTo = new DateTime(2020, 01, 01) }; client.DateLastUpdated = DateTime.Now; client.LastUpdatedByUserID = userId; client.User_Groups.Add(userGroup); context.Clients.InsertOnSubmit(client); context.SubmitChanges(); } catch (Exception e) { ExceptionLog.LogException(e); } }
public ActionResult GetServiceOrderLineBySerialNumberOrderProcess(string serialNumber) { string userName = null; ServiceOrderLine serviceOrderLineObject = new ServiceOrderLine(); List <ServiceOrderLine> serviceOrderLineList = new List <ServiceOrderLine>(); userName = User.Identity.Name.ToString().Split('\\')[1]; try { if (!String.IsNullOrEmpty(serialNumber)) { serviceOrderLineList = serviceOrderLineObject.GetServiceOrderLinesDetailsBySerialNumber(serialNumber, "", userName); if (serviceOrderLineList.Count > 0) { serviceOrderLineObject.PartNumber = serviceOrderLineList[0].PartNumber; serviceOrderLineObject.Warranty = serviceOrderLineList[0].Warranty; serviceOrderLineObject.RepairType = serviceOrderLineList[0].RepairType; serviceOrderLineObject.LineProperty = serviceOrderLineList[0].LineProperty; ViewData["ServiceOrderLineinProcess"] = serviceOrderLineList; } } else { serviceOrderLineObject.ServiceOrderLineList = serviceOrderLineList; ViewData["ServiceOrderLineinProcess"] = serviceOrderLineObject; } TempData.Keep(); } catch (Exception ex) { TempData.Keep(); ExceptionLog.LogException(ex, userName); } return(View("PartDetailsView", serviceOrderLineObject)); }
public void UpdateClientContact(string token, [FromBody] Client_Contact updatedClientContact) { try { var userId = context.GetUserIDSession(token).SingleOrDefault().UserID; var originalClientContact = context.Client_Contacts .Where(x => x.ContactID == updatedClientContact.ContactID) .SingleOrDefault(); var properties = typeof(Client_Contact).GetProperties(); //update entity properties foreach (var p in properties) { p.SetValue(originalClientContact, p.GetValue(updatedClientContact)); } originalClientContact.DateLastUpdated = DateTime.Now; originalClientContact.LastUpdatedByUserID = userId; context.SubmitChanges(); } catch (Exception e) { ExceptionLog.LogException(e); } }
public HttpResponseMessage GetReportedComments(string Token, string ClaimID) { try { if (context.CheckIfTokenValid(Token) == 10001) { using (var command = OrgsysdbConn.CreateCommand()) { OrgsysdbConn.Open(); command.CommandText = "PORTALORG_GetReportedCommentsByClaimID"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ClaimID", ClaimID); var da = new MySqlDataAdapter(command); var dt = new DataTable(); da.Fill(dt); OrgsysdbConn.Close(); return(Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(dt, Formatting.None))); } } return(Request.CreateResponse(HttpStatusCode.NotFound)); } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
// POST: api/PriceList public string Post(HttpRequestMessage value) { try { string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5); JObject json = JObject.Parse(message); JObject clientDetails = (JObject)json["client"]; JArray contactDetails = (JArray)clientDetails["contact_details"]; JArray parts = (JArray)json["parts"]; int c = (int)json["c_ID"]; string to = (string)contactDetails[c]["Email_Address"]; string subject = "WME Price List"; string body = "Walter Meano Engineering Price List for " + (string)clientDetails["Name"] + "\n\nItems on Price List:\n"; foreach (JObject part in parts) { body += (string)part["Name"] + "\t\tR " + (decimal)part["Selling_Price"] + " per unit\n"; } Email.SendEmail(to, subject, body); return("true|Price List successfully sent to " + to); } catch (Exception e) { ExceptionLog.LogException(e, "PriceListController"); return("false|An error has occured sending the email to the customer."); } }
// PUT: api/Component/5 public string Put(int id, HttpRequestMessage value) { try { Component component = new Component(); component = (from p in db.Components where p.Component_ID == id select p).First(); string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5); JObject json = JObject.Parse(message); JObject cmpDetails = (JObject)json["component"]; JArray supplierDetails = (JArray)json["suppliers"]; component.Quantity = (int)cmpDetails["Quantity"]; component.Unit_Price = (decimal)cmpDetails["Unit_Price"]; component.Description = (string)cmpDetails["Description"]; component.Dimension = (string)cmpDetails["Dimension"]; component.Name = (string)cmpDetails["Name"]; component.Min_Stock = (int)cmpDetails["Min_Stock"]; string errorString = "false|"; bool error = false; if ((from t in db.Components where t.Name == component.Name && t.Component_ID != id select t).Count() != 0) { error = true; errorString += "The Component name entered already exists on the system. "; } if (error) { return(errorString); } db.Component_Supplier.RemoveRange(db.Component_Supplier.Where(x => x.Component_ID == id)); foreach (JObject supplier in supplierDetails) { Component_Supplier cs = new Component_Supplier(); cs.Component_ID = id; cs.Supplier_ID = (int)supplier["Supplier_ID"]; cs.is_preferred = Convert.ToBoolean(Convert.ToInt32(supplier["Is_Prefered"])); cs.unit_price = (decimal)supplier["unit_price"]; db.Component_Supplier.Add(cs); } db.SaveChanges(); return("true|Component successfully updated."); } catch (Exception e) { ExceptionLog.LogException(e, "ComponentController PUT"); return("false|An error has occured updating the Component on the system."); } }