public IHttpActionResult PutProjectViewModel(int id, ProjectViewModel projectviewmodel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != projectviewmodel.ProjectID)
{
return(BadRequest());
}
db.Entry(projectviewmodel).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectViewModelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT api/TimeSheets/5
public IHttpActionResult PutTimeSheet(int id, TimeSheetViewModel timesheet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != timesheet.TimeSheetID)
{
return(BadRequest());
}
db.Entry(timesheet).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TimeSheetExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static void AddOption(string fixtureID, string workcenter, string optionName, double prodTime, int?SectionLength = null)
{
using (var db = new TimeContext())
{
var fixture = db.Fixtures.Where(item => item.FxCode == fixtureID && item.WorkCenter == workcenter).FirstOrDefault();
if (fixture == null)
{
FixtureTB.AddInstance(fixtureID, workcenter);
}
fixture = db.Fixtures.Where(item => item.FxCode == fixtureID && item.WorkCenter == workcenter).FirstOrDefault();
OptionTB optionindex = new OptionTB();
if (SectionLength == null)
{
optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime).FirstOrDefault();
}
else
{
optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault();
}
if (!fixture.Options.Contains(optionindex))
{
fixture.Options.Add(optionindex);
}
db.SaveChanges();
}
}
public static void AddOption(string product, string workcenter, string optionName, double prodTime, int?SectionLength = null)
{
using (var db = new TimeContext())
{
var prod = db.Prod.Where(item => item.ProdCode == product && item.WorkCenter == workcenter).FirstOrDefault();
OptionTB optionindex = new OptionTB();
if (SectionLength == null)
{
optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime).FirstOrDefault();
}
else
{
optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault();
}
if (!prod.Options.Contains(optionindex))
{
prod.Options.Add(optionindex);
}
db.SaveChanges();
}
}
static void saveToDB(TimeContext db, Time time)
{
Console.WriteLine(time.Output);
db.Times.Add(time);
db.SaveChanges();
Console.WriteLine("Data was successfully saved!");
}
public static void AddInstance(string ParamName, string ParamValue)
{
using (var db = new TimeContext())
{
var paramindex = db.Params.Where(item => item.ParamName == ParamName && item.ParamValue == ParamValue).FirstOrDefault();
if (paramindex == null)
{
db.Params.Add(new ParametersTB {
ParamName = ParamName, ParamValue = ParamValue
});
}
db.SaveChanges();
}
}
public static void AddInstance(string FamCode, string workcenter)
{
using (var db = new TimeContext())
{
var prod = db.ProdFam.Where(item => item.FamCode == FamCode && item.WorkCenter == workcenter).FirstOrDefault();
if (prod == null)
{
db.ProdFam.Add(new ProdFamTB
{
FamCode = FamCode,
WorkCenter = workcenter
});
}
db.SaveChanges();
}
}
static void Main(string[] args)
{
using (var context = new TimeContext())
{
var emp = new Employee()
{
FirstName = "Joe",
LastName = "Smith",
YearlySalarhy = 75000m
};
context.Employees.Add(emp);
context.SaveChanges();
Console.WriteLine($"New Employee ID: {emp.EmployeeID}");
Console.ReadLine();
}
}
public static void AddInstance(string FixtureCode, string WorkCenter)
{
using (var db = new TimeContext())
{
var fixture = db.Fixtures.Where(item => item.FxCode == FixtureCode && item.WorkCenter == WorkCenter).FirstOrDefault();
if (fixture == null)
{
db.Fixtures.Add(new FixtureTB
{
FxCode = FixtureCode,
WorkCenter = WorkCenter
});
}
db.SaveChanges();
}
}
public ActionResult TimeFormatting()
{
int formatDuration = 0;
if (int.TryParse(Request["Time"].ToString(), out formatDuration))
{
ViewBag.OutputData = TimeCalculations.Calculations(formatDuration);
db.Times.Add(new Time()
{
Output = ViewBag.OutputData
});
db.SaveChanges();
}
else
{
ViewBag.OutputData = "The number is too large or wrong input data.";
}
return(View("Index", db.Times.ToList().Reverse <Time>().Take(5).Reverse()));
}
private void computeButton_Click(object sender, EventArgs e)
{
formatDuration = 0;
if (int.TryParse(inputData.Text, out formatDuration))
{
outputCurrent.Text = TimeCalculations.Calculations(formatDuration);
db.Times.Add(new Time()
{
Output = outputCurrent.Text
});
db.SaveChanges();
OnLoad(e);
}
else
{
outputCurrent.Text = "The number is too large or wrong input data.";
}
inputData.Clear();
}
public static void AddInstance(string optionName, double ProdTime, int?SectionLength = null)
{
using (var db = new TimeContext())
{
var optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == ProdTime &&
item.sectionLength == SectionLength).FirstOrDefault();
if (optionindex == null)
{
db.Options.Add(new OptionTB
{
OptionName = optionName,
ProdTime = ProdTime,
sectionLength = SectionLength
});
}
db.SaveChanges();
}
}
public Optic(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
ID = row.Field <string>("Family Product"),
Optic = row.Field <string>("Optic"),
Length = row.Field <string>("Length"),
Workcenter = row.Field <string>("Work Center")
} into grp
select new
{
ProdFam = grp.Key.ID,
Optic = grp.Key.Optic,
Length = grp.Key.Length,
workcenter = grp.Key.Workcenter,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
using (var db = new TimeContext())
{
foreach (var row in newSort)
{
ProdFamTB.AddInstance(row.ProdFam, row.workcenter);
int length = Int32.Parse(row.Length);
OptionTB.AddInstance(optionName, row.Sum, length);
ParametersTB.AddInstance("Optic", row.Optic);
OptionTB.AddParam(optionName, row.Sum, "Optic", row.Optic);
ProdFamTB.AddOption(row.ProdFam, row.workcenter, optionName, row.Sum, length);
db.SaveChanges();
}
}
}
public static void AddParam(string optionName, double prodTime, string ParamName, string ParamValue, int?SectionLength = null)
{
using (var db = new TimeContext())
{
OptionTB optionindex = new OptionTB();
if (SectionLength == null)
{
optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime).FirstOrDefault();
}
else
{
optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault();
}
var paramindex = db.Params.Where(item => item.ParamName == ParamName && item.ParamValue == ParamValue).FirstOrDefault();
if (!optionindex.Params.Contains(paramindex))
{
optionindex.Params.Add(paramindex);
db.SaveChanges();
}
}
}
public static void AddOption(string FamCode, string workcenter, string optionName, double prodTime, int?SectionLength = null)
{
using (var db = new TimeContext())
{
var prodfam = db.ProdFam.Where(item => item.FamCode == FamCode && item.WorkCenter == workcenter).FirstOrDefault();
if (prodfam == null)
{
ProdFamTB.AddInstance(FamCode, workcenter);
}
prodfam = db.ProdFam.Where(item => item.FamCode == FamCode && item.WorkCenter == workcenter).FirstOrDefault();
var optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime &&
item.sectionLength == SectionLength).FirstOrDefault();
if (!prodfam.Options.Contains(optionindex))
{
prodfam.Options.Add(optionindex);
}
db.SaveChanges();
}
}
public void Save()
{
_context.SaveChanges();
}
public void save()
{
m_context.SaveChanges();
}
