protected void Button1_Click1(object sender, EventArgs e)
{
if (lbllevelid.Text.Length > 0)
{
try
{
EduLevelsRepository elir = new EduLevelsRepository();
if (elir.FindBytitle(TextBox1.Text) != null)
{
PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errRepeatTitle, Color.Red);
return;
}
EduLevel editlevel = new EduLevel();
if ((TextBox1.Text.Length > 0) && (TextBox1.Text != lbltitle.Text))
{
editlevel.LevelTitle = TextBox1.Text;
}
editlevel.LevelID = lbllevelid.Text.ToInt();
elir.SaveEduLevel(editlevel);
ClearForm();
PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgUpdateSuccessfull, Color.Green);
}
catch
{
PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errUpdateFailed, Color.Red);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("EduLevelId,EduLevelName")] EduLevel eduLevel)
{
if (id != eduLevel.EduLevelId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(eduLevel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EduLevelExists(eduLevel.EduLevelId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(eduLevel));
}
public void LoadLevelData(string Levelid)
{
try
{
EduLevelsRepository elir = new EduLevelsRepository();
EduLevel level = elir.FindByid(Levelid.ToInt());
if (level != null)
{
lbltitle.Text = level.LevelTitle;
lbllevelid.Text = level.LevelID.ToString();
TextBox1.Text = level.LevelTitle;
}
else
{
Redirector.Goto(Redirector.PageName.errorpage);
}
}
catch
{
Redirector.Goto(Redirector.PageName.errorpage);
}
}
public async Task <IActionResult> Create([Bind("EduLevelId,EduLevelName")] EduLevel eduLevel)
{
if (ModelState.IsValid)
{
_context.Add(eduLevel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(eduLevel));
}
public EduLevel FindByid(int id)
{
EduLevel result = null;
using (PersonsDBEntities DC = conn.GetContext())
{
//-- SELECT * FROM vPhoneList WHERE PhobeID = phoneID
result = (from r in DC.EduLevels
where r.LevelID == id
select r).FirstOrDefault();
}
return(result);
}
public void SaveEduLevel(EduLevel edulevel)
{
using (PersonsDBEntities DC = conn.GetContext())
{
if (edulevel.LevelID > 0)
{
//==== UPDATE ====
DC.EduLevels.Attach(edulevel);
DC.Entry(edulevel).State = EntityState.Modified;
}
else
{
//==== INSERT ====
DC.EduLevels.Add(edulevel);
}
DC.SaveChanges();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
EduLevelsRepository level = new EduLevelsRepository();
if (level.FindBytitle(TextBox1.Text) != null)
{
PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errDuplicateUsername, Color.Red);
return;
}
bool successfullCreateAccount = true;
try
{
EduLevel newEduLevel = new EduLevel();
newEduLevel.LevelTitle = TextBox1.Text.Trim();
EduLevelsRepository elir = new EduLevelsRepository();
elir.SaveEduLevel(newEduLevel);
ClearForm();
}
catch (System.Exception err)
{
successfullCreateAccount = false;
PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errAddFailed, Color.Red);
}
if (successfullCreateAccount)
{
// ClearForm();
PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgAddSuccessfull, Color.Green);
}
}
/// <summary>
/// There are no comments for EduLevel in the schema.
/// </summary>
public void AddToEduLevel(EduLevel eduLevel)
{
base.AddObject("EduLevel", eduLevel);
}
/// <summary>
/// Create a new EduLevel object.
/// </summary>
/// <param name="eLId">Initial value of ELId.</param>
public static EduLevel CreateEduLevel(int eLId)
{
EduLevel eduLevel = new EduLevel();
eduLevel.ELId = eLId;
return eduLevel;
}
public void ParseCellOnce(ICell cell, string cellStrValue, CellRangeAddress cellRangeAddress, WorkbookParserContext context, out bool parseCellAgain, out bool skipRow)
{
parseCellAgain = false;
skipRow = false;
if (context.State == WorkbookParserState.Initial)
{
context.State = WorkbookParserState.Header;
parseCellAgain = true;
return;
}
if (context.State == WorkbookParserState.Header)
{
if (!cell.IsMergedCell)
{
if (cell.ColumnIndex == 0 && cellStrValue.Equals("№ п/п", StringComparison.CurrentCultureIgnoreCase))
{
context.State = WorkbookParserState.TableHeader;
return;
}
}
else if (cell.IsMergedCell && cellRangeAddress.NumberOfCells >= 10)
{
if (Regex.IsMatch(cellStrValue, "факультет|институт", RegexOptions.IgnoreCase))
{
var divisionTitle = cellStrValue.ToLower();
var division = divisions.FindOne(d => d.Title == divisionTitle);
if (division == null)
{
division = new Division {
Title = divisionTitle
};
var id = divisions.Insert(division);
db.Commit();
division.Id = id.AsInt32;
}
context.Division = division;
}
if (Regex.IsMatch(cellStrValue, "форма обучения", RegexOptions.IgnoreCase))
{
var eduForm = eduForms.FindOne(ef => ef.Title == cellStrValue);
if (eduForm == null)
{
eduForm = new EduForm {
Title = cellStrValue
};
var id = eduForms.Insert(eduForm);
db.Commit();
eduForm.Id = id.AsInt32;
}
context.EduForm = eduForm;
}
if (Regex.IsMatch(cellStrValue, "бюджет|договор", RegexOptions.IgnoreCase))
{
var financingTitle = cellStrValue.ToLower();
var financing = financings.FindOne(f => f.Title == financingTitle);
if (financing == null)
{
financing = new Financing {
Title = financingTitle
};
var id = financings.Insert(financing);
db.Commit();
financing.Id = id.AsInt32;
}
context.Financing = financing;
}
if (Regex.IsMatch(cellStrValue, "бакалавриат|специалитет|магистратур|подготовки кадров|основного общего|среднего общего", RegexOptions.IgnoreCase))
{
var eduLevelStrValue = GetEduLevelString(cellStrValue);
var eduLevel = eduLevels.FindOne(el => el.Title == eduLevelStrValue);
if (eduLevel == null)
{
eduLevel = new EduLevel {
Title = eduLevelStrValue
};
var id = eduLevels.Insert(eduLevel);
db.Commit();
eduLevel.Id = id.AsInt32;
}
context.EduLevel = eduLevel;
if (context.EduLevel.Title.StartsWith("специалитет СПО", StringComparison.CurrentCultureIgnoreCase))
{
context.IsCollegeList = true;
}
else
{
context.IsCollegeList = false;
}
var eduProgramTitle = Regex.Match(cellStrValue, @"«[^»]+»", RegexOptions.Singleline | RegexOptions.IgnoreCase).Value;
var eduProfileTitle = Regex.Match(cellStrValue, @"Профиль:(.*)", RegexOptions.Singleline | RegexOptions.IgnoreCase).Groups [1].Value;
if (string.IsNullOrEmpty(eduProfileTitle))
{
eduProfileTitle = Regex.Match(cellStrValue, @"на базе .* общего образования", RegexOptions.Singleline | RegexOptions.IgnoreCase).Value;
}
eduProgramTitle = FormatEduProgramTitle(eduProgramTitle);
eduProfileTitle = FormatEduProgramTitle(eduProfileTitle);
if (context.EduProgram == null)
{
context.EduProgram = new EduProgram();
}
context.EduProgram.Title = eduProgramTitle;
context.EduProgram.ProfileTitle = eduProfileTitle;
context.EduProgram.EduLevelId = context.EduLevel.Id;
context.EduProgram.DivisionId = context.Division.Id;
}
}
return;
}
if (context.State == WorkbookParserState.TableHeader && context.IsCollegeList)
{
if (cell.ColumnIndex == 5)
{
context.EduProgram.Exam1Title = cellStrValue;
}
else if (cell.ColumnIndex == 7)
{
context.EduProgram.Exam2Title = cellStrValue;
}
else if (cell.ColumnIndex > 7)
{
context.State = WorkbookParserState.List;
context.Order = 0;
skipRow = true;
InsertEduProgram(context);
}
return;
}
if (context.State == WorkbookParserState.TableHeader && !context.IsCollegeList)
{
if (cell.ColumnIndex == 4)
{
context.EduProgram.Exam1Title = cellStrValue;
}
else if (cell.ColumnIndex == 5)
{
context.EduProgram.Exam2Title = cellStrValue;
}
else if (cell.ColumnIndex == 6)
{
context.EduProgram.Exam3Title = cellStrValue;
}
else if (cell.ColumnIndex > 6)
{
context.State = WorkbookParserState.List;
context.Order = 0;
skipRow = true;
InsertEduProgram(context);
}
return;
}
if (context.State == WorkbookParserState.List)
{
if (cell.IsMergedCell && cellRangeAddress.NumberOfCells >= 10)
{
context.State = WorkbookParserState.Header;
parseCellAgain = true;
return;
}
if (cell.ColumnIndex == 0)
{
context.Applicant = new Applicant();
context.Applicant.Order = ++context.Order;
if (int.TryParse(cellStrValue, out int rankedOrder))
{
context.Applicant.RankedOrder = rankedOrder;
}
}
else if (cell.ColumnIndex == 1)
{
context.Applicant.Name = cellStrValue;
}
}
if (context.State == WorkbookParserState.List && context.IsCollegeList)
{
if (cell.ColumnIndex == 3)
{
context.Applicant.HasOriginal = cellStrValue.Equals("Оригинал", StringComparison.CurrentCultureIgnoreCase);
}
else if (cell.ColumnIndex == 5)
{
if (decimal.TryParse(cellStrValue, out decimal exam1Rate))
{
context.Applicant.Exam1Rate = exam1Rate;
}
}
else if (cell.ColumnIndex == 7)
{
context.Applicant.Exam2Mark = cellStrValue;
}
else if (cell.ColumnIndex == 9)
{
if (decimal.TryParse(cellStrValue, out decimal totalRate))
{
context.Applicant.TotalRate = totalRate;
}
}
else if (cell.ColumnIndex == 10)
{
context.Applicant.Status = cellStrValue;
}
else if (cell.ColumnIndex == 11)
{
context.Applicant.RejectReason = cellStrValue;
}
else if (cell.ColumnIndex > 11)
{
context.Applicant.EduProgramId = context.EduProgram.Id;
context.Applicant.EduFormId = context.EduForm.Id;
context.Applicant.FinancingId = context.Financing.Id;
applicants.Insert(context.Applicant);
skipRow = true;
}
return;
}
if (context.State == WorkbookParserState.List && !context.IsCollegeList)
{
if (cell.ColumnIndex == 2)
{
context.Applicant.HasOriginal = cellStrValue.Equals("Оригинал", StringComparison.CurrentCultureIgnoreCase);
}
else if (cell.ColumnIndex == 3)
{
context.Applicant.HasAgreement = cellStrValue.Equals("Да", StringComparison.CurrentCultureIgnoreCase);
}
if (cell.ColumnIndex == 4)
{
if (decimal.TryParse(cellStrValue, out decimal exam1Rate))
{
context.Applicant.Exam1Rate = exam1Rate;
}
}
else if (cell.ColumnIndex == 5)
{
if (decimal.TryParse(cellStrValue, out decimal exam2Rate))
{
context.Applicant.Exam2Rate = exam2Rate;
}
}
else if (cell.ColumnIndex == 6)
{
if (decimal.TryParse(cellStrValue, out decimal exam3Rate))
{
context.Applicant.Exam3Rate = exam3Rate;
}
}
else if (cell.ColumnIndex == 7)
{
if (decimal.TryParse(cellStrValue, out decimal achRate))
{
context.Applicant.AchRate = achRate;
}
}
else if (cell.ColumnIndex == 8)
{
if (decimal.TryParse(cellStrValue, out decimal totalRate))
{
context.Applicant.TotalRate = totalRate;
}
}
else if (cell.ColumnIndex == 9)
{
context.Applicant.Category = cellStrValue;
}
else if (cell.ColumnIndex == 10)
{
if (cellStrValue.Equals("Да", StringComparison.CurrentCultureIgnoreCase))
{
context.Applicant.HasPreemptiveRight = true;
}
}
else if (cell.ColumnIndex == 11)
{
context.Applicant.Status = cellStrValue;
}
else if (cell.ColumnIndex == 12)
{
context.Applicant.RejectReason = cellStrValue;
}
else if (cell.ColumnIndex > 12)
{
context.Applicant.EduProgramId = context.EduProgram.Id;
context.Applicant.EduFormId = context.EduForm.Id;
context.Applicant.FinancingId = context.Financing.Id;
applicants.Insert(context.Applicant);
skipRow = true;
}
return;
}
}
