public async Task <IActionResult> PutAnnual(int id, Annual annual)
{
if (id != annual.AnnualId)
{
return(BadRequest());
}
_context.Entry(annual).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnnualExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Annual> > PostAnnual(Annual annual)
{
_context.Annual.Add(annual);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetAnnual", new { id = annual.AnnualId }, annual));
}
private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(annualTxt.Text))
{
MessageBox.Show("", "Please input the annual projection value !", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string test = "";
try
{
test = Annual.List("SELECT * from budget WHERE year='" + yearCbx.Text + "' AND weekly = '" + weeklyTxt.Text + "'").First().Annuals.ToString();
}
catch (Exception y)
{
// Helper.Exceptions(y.Message, "on adding inventory auto fill the category list selected item");
}
if (!string.IsNullOrEmpty(test))
{
MessageBox.Show("Value inserted !");
return;
}
string ID = Guid.NewGuid().ToString();
Annual i = new Annual(ID, yearCbx.Text, Convert.ToDouble(annualTxt.Text), Convert.ToDouble(weeklyTxt.Text));
DBConnect.Insert(i);
MessageBox.Show("Information Saved");
annualTxt.Text = "";
weeklyTxt.Text = "";
}
public async Task <IActionResult> Edit(int id, Annual annual)
{
var user = await GetCurrentUserAsync();
annual.ApllicationUserId = user?.Id;
if (id != annual.AnnualId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(annual);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnnualExists(annual.AnnualId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ProgrameId"] = new SelectList(_context.Programes, "ProgrameId", "Name");
return(View(annual));
}
private string Worst(Annual data, int year, string ico, out KIndexParts?usedPart)
{
usedPart = data.OrderedValuesFromBestForInfofacts(ico)?.Reverse()?.FirstOrDefault();
if (usedPart != null)
{
return(KIndexData.KIndexCommentForPart(usedPart.Value, data));
}
return(null);
}
public void UpdateAnnual(Annual entity, Annual model)
{
// entity.ApplicationUser = model.UserId;
entity.ProgrameId = model.ProgrameId;
entity.Title = model.Title;
entity.Description = model.Description;
entity.Fees = model.Fees;
entity.IsActive = model.IsActive;
}
private string Best(Annual data, int year, string ico, out KIndexParts?usedPart)
{
Statistics stat = Statistics.GetStatistics(year);
usedPart = data.OrderedValuesFromBestForInfofacts(ico).FirstOrDefault();
if (usedPart != null)
{
return(KIndexData.KIndexCommentForPart(usedPart.Value, data));
}
return(null);
}
public static KIndexData Empty(string ico, string jmeno = null)
{
KIndexData kidx = new KIndexData();
kidx.Ico = ico;
kidx.Jmeno = jmeno ?? Lib.Data.Firmy.GetJmeno(ico);
kidx.roky = Consts.CalculationYears
.Select(rok => Annual.Empty(rok))
.ToList();
return(kidx);
}
public static Annual Empty(int rok)
{
Annual ann = new Annual(rok);
ann.KIndex = Consts.MinSmluvPerYearKIndexValue;
ann.KIndexReady = false;
ann.KIndexVypocet = new VypocetDetail()
{
Radky = new VypocetDetail.Radek[] { }
};
return(ann);
}
public async Task <IActionResult> Create(Annual annual)
{
var user = await GetCurrentUserAsync();
annual.ApllicationUserId = user?.Id;
if (ModelState.IsValid)
{
_context.Add(annual);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ProgrameId"] = new SelectList(_context.Programes, "ProgrameId", "Name");
return(View(annual));
}
public void Add(Annual tbl)
{
//var mylist = this.ListAnnual().ToList();
//if (mylist.Count == 0)
//{
// tbl.AnnualID = "000001";
//}
//else
//{
// string s = ((from x in mylist
// select new { x.AnnualID }).Last()).AnnualID.ToString();
// int lastid = Int32.Parse(s.Substring(0, 6)) + 1;
// string myid = String.Format("{0:000000}", lastid);
// string autoid = myid.ToString();
// tbl.AnnualID = autoid;
//}
db.Annuals.InsertOnSubmit(tbl);
}
public async Task <ActionResult <string> > SalvarPlanoAnual(Annual annual)
{
annual.NewID();
annual.CreatedAt = DateTime.Now;
annual.ModifiedAt = DateTime.Now;
Annual old =
(from current in _db.Annuals
where current.SchoolYear == annual.SchoolYear &&
current.Classroom == annual.Classroom &&
current.School == annual.School &&
current.UserId == annual.UserId
select current).SingleOrDefault();
if (old != null)
{
old.ModifiedAt = annual.ModifiedAt;
old.SelectedLearningObjectivesB1 = annual.SelectedLearningObjectivesB1;
old.DescriptionB1 = annual.DescriptionB1;
old.SelectedLearningObjectivesB2 = annual.SelectedLearningObjectivesB2;
old.DescriptionB2 = annual.DescriptionB2;
old.SelectedLearningObjectivesB3 = annual.SelectedLearningObjectivesB3;
old.DescriptionB3 = annual.DescriptionB3;
old.SelectedLearningObjectivesB4 = annual.SelectedLearningObjectivesB4;
old.DescriptionB4 = annual.DescriptionB4;
await _db.SaveChangesAsync();
}
else
{
try
{
await _db.Annuals.AddAsync(annual);
await _db.SaveChangesAsync();
}
catch
{
return(BadRequest());
}
}
return(Ok());
}
private void button11_Click(object sender, EventArgs e)
{
try
{
member stuObj = null;
bool result = false;
string gen = null;
if (rdoMale.Checked)
{
gen = "Male";
}
else if (rdoFemale.Checked)
{
gen = "Female";
}
if (rdoUG.Checked)
{
stuObj = new Annual(txtSid.Text, txtFname.Text, txtLname.Text, dtpDateOfBirth.Text,
Convert.ToInt32(txtAge.Text), txtTele.Text, txtAddress.Text, gen, name.Text,
Convert.ToInt32(txtduration.Text), comboBox1.Text, txtstatus.Text);
}
else if (rdoPG.Checked)
{
stuObj = new six_month(txtSid.Text, txtFname.Text, txtLname.Text, dtpDateOfBirth.Text,
Convert.ToInt32(txtAge.Text), txtTele.Text, txtAddress.Text, gen, txtsix.Text,
Convert.ToInt32(txtsixdu.Text), comboBox2.Text, txtsixsta.Text);
}
result = stuObj.register();
if (result)
{
MessageBox.Show("Member has been successfully entered");
}
else
{
MessageBox.Show("Insert Failed Try again...");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button17_Click(object sender, EventArgs e)
{
member stuObj = null;
bool result = false;
string gen = null;
if (rdoMale.Checked)
{
gen = "Male";
}
else if (rdoFemale.Checked)
{
gen = "Female";
}
if (rdoUG.Checked)
{
stuObj = new Annual(txtSid.Text, txtFname.Text, txtLname.Text, dtpDateOfBirth.Text,
Convert.ToInt32(txtAge.Text), txtTele.Text, txtAddress.Text, gen, name.Text,
Convert.ToInt32(txtduration.Text), comboBox1.Text, txtstatus.Text);
}
else if (rdoPG.Checked)
{
stuObj = new six_month(txtSid.Text, txtFname.Text, txtLname.Text, dtpDateOfBirth.Text,
Convert.ToInt32(txtAge.Text), txtTele.Text, txtAddress.Text, gen, txtsix.Text,
Convert.ToInt32(txtsixdu.Text), comboBox2.Text, txtsixsta.Text);
}
result = stuObj.updatemembers();
if (result)
{
MessageBox.Show(txtSid.Text + " has been updated");
}
else
{
MessageBox.Show("Error Encountered");
}
}
