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();
}
