public async Task <IActionResult> Putmember_type(int id, industry industry) { if (id != industry.id) { return(BadRequest()); } _context.Entry(industry).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!member_typeExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <industry> > Postmember_type(industry industry) { _context.industries.Add(industry); await _context.SaveChangesAsync(); return(CreatedAtAction("Getmember_type", new { id = industry.id }, industry)); }
public ActionResult Edit([Bind(Include = "industryID,industryName,isActive")] industry industry) { try { var i = repo.Single(industry.industryID); if (i == null) { return(HttpNotFound()); } i.industryName = industry.industryName; i.isActive = industry.isActive; i.dataIsUpdated = BaseUtil.GetCurrentDateTime(); i.modifiedBy = Convert.ToInt64(BaseUtil.GetSessionValue(AdminInfo.UserID.ToString())); if (ModelState.IsValid) { repo.Update(i); return(RedirectToAction("Index")); } } catch (Exception e) { BaseUtil.CaptureErrorValues(e); } return(View(industry)); }
public IQueryable getArea(measure pMeasure, industry pIndustry) { var seriesQuery = (from records in db.series where records.measureID == pMeasure.measureID && records.industryID == pIndustry.industryID select new { areaResult = records.area }) .Distinct(); var query = (from val in seriesQuery select new { areaID = val.areaResult.areaID, areaName = val.areaResult.areaName }); return(query); }
public JsonResult getArea(measureIndustry pData) { measure measureToSend = new measure(); industry industryToSend = new industry(); measureToSend.measureID = pData.measureID; measureToSend.measureName = pData.measureName; industryToSend.industryID = pData.industryID; industryToSend.industryName = pData.industryName; var queryResult = downloadModel.getArea(measureToSend, industryToSend); return(Json(queryResult, "application/json")); }
public int InsertIndustry(industry ind) { industryDataContext db = new industryDataContext(); try { db.industry.InsertOnSubmit(ind); db.SubmitChanges(); return(int.Parse(ind.IndID.ToString())); } catch { return(0); } }
public int UpdateIndustryfoByIndID(industry ind) { industryDataContext db = new industryDataContext(); try { var result = (from item in db.industry where item.IndID == ind.IndID select item).Single(); result.IndName = ind.IndName; result.IndChildID = ind.IndChildID; result.IndChildName = ind.IndChildName; db.SubmitChanges(); return(int.Parse(result.IndID.ToString())); } catch { return(0); } }
public ActionResult Create([Bind(Include = "industryName,isActive")] industry industry) { try { if (ModelState.IsValid) { industry.createdBy = Convert.ToInt64((BaseUtil.GetSessionValue(AdminInfo.employerID.ToString()))); industry.modifiedBy = Convert.ToInt64((BaseUtil.GetSessionValue(AdminInfo.employerID.ToString()))); industry.isActive = industry.isActive; industry.dataIsCreated = BaseUtil.GetCurrentDateTime(); industry.dataIsUpdated = BaseUtil.GetCurrentDateTime(); repo.Insert(industry); return(RedirectToAction("Index")); } } catch (Exception e) { BaseUtil.CaptureErrorValues(e); } return(View(industry)); }
public JsonResult postindustry(industry pIndustry) { addModel.checkIndustry(pIndustry); return(Json(pIndustry, "application/json")); }
public void treevIndustry(industry ind, string ter) { advanceSearch.Get <Button>(SearchCriteria.ByAutomationId("btnSelectIndustries")).Click(); Tree managingOfficeRegion = advanceSearch.Get <Tree>(SearchCriteria.ByAutomationId("tvHierarchy")); DateTime beginWait = DateTime.Now; switch (ind) { case industry.Primary: advanceSearch.Get <RadioButton>(SearchCriteria.ByAutomationId("optPrimary")).Click(); advanceSearch.Get(SearchCriteria.ByAutomationId("txtTermName")).SetValue(ter); while (!Console.KeyAvailable && DateTime.Now.Subtract(beginWait).TotalSeconds < 5) { Thread.Sleep(250); } foreach (TreeNode node in managingOfficeRegion.Nodes) { Console.WriteLine(node.Name.ToString()); node.Select(); advanceSearch.Keyboard.PressSpecialKey(KeyboardInput.SpecialKeys.SPACE); } break; case industry.Secondry: advanceSearch.Get <RadioButton>(SearchCriteria.ByAutomationId("optSecondary")).Click(); advanceSearch.Get(SearchCriteria.ByAutomationId("txtTermName")).SetValue(ter); while (!Console.KeyAvailable && DateTime.Now.Subtract(beginWait).TotalSeconds < 5) { Thread.Sleep(250); } foreach (TreeNode node in managingOfficeRegion.Nodes) { Console.WriteLine(node.Name.ToString()); node.Select(); advanceSearch.Keyboard.PressSpecialKey(KeyboardInput.SpecialKeys.SPACE); } break; case industry.All: advanceSearch.Get <RadioButton>(SearchCriteria.ByAutomationId("optAll")).Click(); advanceSearch.Get(SearchCriteria.ByAutomationId("txtTermName")).SetValue(ter); while (!Console.KeyAvailable && DateTime.Now.Subtract(beginWait).TotalSeconds < 5) { Thread.Sleep(250); } // will select all option filtered in search foreach (TreeNode node in managingOfficeRegion.Nodes) { Console.WriteLine(node.Name.ToString()); node.Select(); advanceSearch.Keyboard.PressSpecialKey(KeyboardInput.SpecialKeys.SPACE); } break; } advanceSearch.Get <Button>(SearchCriteria.ByAutomationId("btnSave")).Click(); }
public string insertFromCsv(string fileName) { string[] strArray; string firstLine = string.Empty; Regex r = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); StreamReader sr = new StreamReader(fileName); string headerline = sr.ReadLine(); firstLine = sr.ReadLine(); strArray = r.Split(firstLine); area newArea = new area(); measure newMeasure = new measure(); industry newIndustry = new industry(); series newSeries = new series(); newArea.areaID = strArray[2]; newArea.areaName = strArray[1]; newMeasure.measureID = strArray[4]; newMeasure.measureName = strArray[3]; newIndustry.industryID = strArray[6]; newIndustry.industryName = strArray[5]; newSeries.areaID = newArea.areaID; newSeries.measureID = newMeasure.measureID; newSeries.industryID = newIndustry.industryID; newSeries.seriesID = newArea.areaID + strArray[0]; newSeries.beginYear = "NA"; newSeries.beginPeriod = "NA"; newSeries.endYear = "NA"; newSeries.endPeriod = "NA"; newSeries.blsTable = strArray[0]; db.areas.Add(newArea); db.industries.Add(newIndustry); db.measures.Add(newMeasure); db.series.Add(newSeries); db.SaveChanges(); //start reading from 2nd line in CSV foreach (var line in File.ReadAllLines(fileName, Encoding.GetEncoding(1250)).Skip(1)) { strArray = r.Split(line); //assign split string to variables data_table newData = new data_table(); int year = Convert.ToInt32(strArray[7]); long value = Convert.ToInt64(strArray[8]); newData.seriesID = newSeries.seriesID; newData.period = "NA"; newData.year = year; newData.value = value; db.data_table.Add(newData); db.SaveChanges(); } return("Updated Database"); }
public void checkIndustry(industry pIndustry) { db.industries.Add(pIndustry); db.SaveChanges(); }
public Task RemoveIndustryAsync(industry industry) { throw new NotImplementedException(); }