private static void UpdateCityLefvel(CommonDbContext dbContext)
{
var province = dbContext.CityInfos.Where(x => x.ParentCode == null || x.ParentCode == string.Empty).ToList();
foreach (var pinfo in province)
{
var cities = dbContext.CityInfos.Where(x => x.ParentCode == pinfo.Code);
foreach (var cityInfo in cities)
{
var districts = dbContext.CityInfos.Where(x => x.ParentCode == cityInfo.Code);
cityInfo.Level = 1;
dbContext.Update(cityInfo);
foreach (var dinfo in districts)
{
dinfo.Level = 2;
dbContext.Update(dinfo);
}
dbContext.SaveChanges();
}
}
}
public int UpdateStudent(Student student)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", student.Id),
new MySqlParameter("@account_number", student.AccountNumber != null?student.AccountNumber:null),
new MySqlParameter("@first_name", student.FirstName),
new MySqlParameter("@last_name", student.LastName),
new MySqlParameter("@address_id", student.Address.Id),
new MySqlParameter("@bank_id", student.Bank.Id),
new MySqlParameter("@born_date", student.BornDate),
new MySqlParameter("@cellphone_number", student.CellphoneNumber != null?student.CellphoneNumber:null),
new MySqlParameter("@children_number", student.ChildrenNumber != null?student.ChildrenNumber:null),
new MySqlParameter("@fax_number", student.FaxNumber != null?student.FaxNumber:null),
new MySqlParameter("@id_card", student.IdCard),
new MySqlParameter("@identity_number", student.IdentityNumber),
new MySqlParameter("@image", student.Image),
new MySqlParameter("@job_wife", student.JobWife != null?student.JobWife:null),
new MySqlParameter("@married_children_number", student.MarriedChildrenNumber != null?student.MarriedChildrenNumber:null),
new MySqlParameter("@monthly_income", student.MonthlyIncome != null?student.MonthlyIncome:null),
new MySqlParameter("@travel_expenses", student.TravelExpenses != null?student.TravelExpenses:null),
new MySqlParameter("@wife_name", student.WifeName != null?student.WifeName:null),
new MySqlParameter("@phone_number", student.PhoneNumber),
new MySqlParameter("@is_active", student.IsActive),
new MySqlParameter("@travel_expenses_currency", student.TravelExpensesCurrency != null?student.TravelExpensesCurrency:null),
new MySqlParameter("@monthly_income_currency", student.MonthlyIncomeCurrency != null?student.MonthlyIncomeCurrency:null),
};
return(_dbContext.Update(Tables.Students.UpdateTable, parameters));
}
public int UpdateExamRules(ExamRules examRules)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", examRules.Id),
new MySqlParameter("@branch_id", examRules.Branch.Id),
new MySqlParameter("@is_required_exams", examRules.IsRequiredExams),
new MySqlParameter("@exams_per_period", examRules.ExamsPerPeriod),
new MySqlParameter("@exams_period", examRules.ExamsPeriod),
};
return(_dbContext.Update(Tables.ExamsRules.UpdateTable, parameters));
}
public int SetPasswordValidity(TUser user, int expired)
{
DateTime passwordCreated = DateTime.UtcNow;
DateTime passwordExpired = DateTime.UtcNow.AddDays(expired);
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", (user as User).Id),
new MySqlParameter("@PasswordCreated", passwordCreated),
new MySqlParameter("@PasswordExpired", passwordExpired)
};
string query = $"UPDATE {Users.TableName} SET {Users.PasswordCreated.Name}=@PasswordCreated, {Users.PasswordExpired.Name}=@PasswordExpired WHERE {Users.Id.Name} = @UserId";
return(db.Update(query, parameters));
}
public IActionResult Put(int id, ProductionData productionData)
{
if (id != productionData.Id)
{
return(BadRequest());
}
_context.Update(productionData);
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductionDataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//public int RequestRegistrationBranchStudent(BranchStudent branchStudent)
//{
// IList<DbParameter> parameters = new List<DbParameter>()
// {
// new MySqlParameter("@student_id",branchStudent.Student.Id),
// new MySqlParameter("@branch_id",branchStudent.Branch.Id),
// new MySqlParameter("@branch_study_track_id",branchStudent.studyTrack.Id),
// new MySqlParameter("@status","pending"),
// new MySqlParameter("@is_active",false)
// };
// string sql = $"INSERT INTO {Tables.BranchStudents.TableName} (student_id,branch_id,status,is_active) VALUES (@student_id,@branch_id,@status,@is_active)";
// return _dbContext.Insert(sql, true, parameters);
//}
//מקורי
//public int RequestRegistrationBranchStudent(int studentId, int branchId, int? studyPathId)
//{
// IList<DbParameter> parameters = new List<DbParameter>()
// {
// new MySqlParameter("@student_id",studentId),
// new MySqlParameter("@branch_id",branchId),
// new MySqlParameter("@branch_study_path_id",studyPathId),
// new MySqlParameter("@entry_gregorian_date",null),
// new MySqlParameter("@entry_hebrew_date",null),
// new MySqlParameter("@release_hebrew_date",null),
// new MySqlParameter("@release_gregorian_date",null),
// new MySqlParameter("@status",StatusInBranch.Pending.ToString()),
// new MySqlParameter("@is_active",false)
// };
// return _dbContext.Insert(Tables.BranchStudents.InsertTable, true, parameters);
//}
//שלי
public int SetStudentInactiveInBranch(int studentId, int branchId, string releaseHebrewDate)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@student_id", studentId),
new MySqlParameter("@branch_id", branchId),
new MySqlParameter("@release_gregorian_date", DateTime.UtcNow),
new MySqlParameter("@releaseHebrewDate", releaseHebrewDate),
new MySqlParameter("@is_active", false)
};
string sql = $"UPDATE {Tables.BranchStudents.TableName} SET {Tables.BranchStudents.IsActive.Name}=@is_active,{Tables.BranchStudents.ReleaseGregorianDate.Name}=@release_gregorian_date, " +
$" {Tables.BranchStudents.ReleaseHebrewDate.Name}=@releaseHebrewDate WHERE {Tables.BranchStudents.StudentId.Name}=@student_id " +
$"AND {Tables.BranchStudents.BranchId.Name}=@branch_id AND {Tables.BranchStudents.IsActive.Name}!=@is_active";
return(_dbContext.Update(sql, parameters));
}
public int UpdateBranch(Branch branch)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", branch.Id),
new MySqlParameter("@type_id", branch.Type.Id),
new MySqlParameter("@head_id", branch.Head.UserId),
new MySqlParameter("@address_id", branch.Address.Id),
new MySqlParameter("@name", branch.Name),
new MySqlParameter("@opening_date", branch.OpeningDate),
new MySqlParameter("@students_number", branch.StudentsNumber),
new MySqlParameter("@study_subjects", branch.StudySubjects),
new MySqlParameter("@is_active", branch.IsActive),
new MySqlParameter("@image", branch.Image),
new MySqlParameter("@institution_id", branch.Institution.Id)
};
return(_dbContext.Update(Tables.Branches.UpdateTable, parameters));
}
public int UpdateScolarship(Scolarship scolarship)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", scolarship.Id),
new MySqlParameter("@amount", scolarship.Amount),
};
return(_dbContext.Update(Tables.Scolarships.UpdateTable, parameters));
}
public int Update(TRole Role)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@roleId", Role.Id),
new MySqlParameter("@roleName", Role.Name)
};
string query = $"update {Roles.TableName} set {Roles.Name.Name} = @roleName where {Roles.Id.Name} = @roleId ";
return(db.Update(query, parameters));
}
public int UpdateBank(Bank bank)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", bank.Id),
new MySqlParameter("@bank_number", bank.BankNumber),
new MySqlParameter("@name", bank.Name),
new MySqlParameter("@branch_number", bank.BranchNumber),
new MySqlParameter("@address_id", bank.Address != null? bank.Address.Id:1),
};
return(_dbContext.Update(Tables.Banks.UpdateTable, parameters));
}
public int UpdateBranchActivityHours(BranchActivityHours branchActivityHours)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", branchActivityHours.Id),
new MySqlParameter("@late_hour", branchActivityHours.LateHour),
new MySqlParameter("@start_study_hours", branchActivityHours.StartStudyHours),
new MySqlParameter("@end_study_hours", branchActivityHours.EndStudyHours),
new MySqlParameter("@branch_id", branchActivityHours.Branch.Id)
};
return(_dbContext.Update(Tables.BranchActivityHours.UpdateTable, parameters));
}
public int UpdateUser(TUser user)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", !string.IsNullOrEmpty(user.Id) ? user.Id :null),
new MySqlParameter("@UserName", !string.IsNullOrEmpty(user.UserName) ? user.UserName :null),
new MySqlParameter("@AccessFailedCount", user.AccessFailedCount),
new MySqlParameter("@EmailConfirmed", user.EmailConfirmed),
new MySqlParameter("@LockoutEnabled", user.LockoutEnabled),
new MySqlParameter("@LockoutEndDateUtc", user.LockoutEndDateUtc),
new MySqlParameter("@PasswordHash", !string.IsNullOrEmpty(user.PasswordHash) ? user.PasswordHash :null),
new MySqlParameter("@SecurityStamp", !string.IsNullOrEmpty(user.SecurityStamp) ? user.SecurityStamp :null),
new MySqlParameter("@Email", !string.IsNullOrEmpty(user.Email) ? user.Email :null),
new MySqlParameter("@TwoFactorEnabled", user.TwoFactorEnabled),
new MySqlParameter("@PhoneNumber", !string.IsNullOrEmpty(user.PhoneNumber) ? user.PhoneNumber :null),
new MySqlParameter("@PhoneNumberConfirmed", user.PhoneNumberConfirmed)
};
string query = $"UPDATE {Users.TableName} SET {Users.UserName.Name} = @UserName, {Users.AccessFailedCount.Name} = @AccessFailedCount," +
$"{Users.EmailConfirmed.Name} = @EmailConfirmed, {Users.LockoutEnabled.Name} = @LockoutEnabled, {Users.LockoutEndDateUtc.Name} = @LockoutEndDateUtc, {Users.PasswordHash.Name} = @PasswordHash," +
$"{Users.SecurityStamp.Name} = @SecurityStamp, {Users.Email.Name} = @Email, {Users.TwoFactorEnabled.Name} = @TwoFactorEnabled, {Users.PhoneNumber.Name} = @PhoneNumber, {Users.PhoneNumberConfirmed.Name} = @PhoneNumberConfirmed WHERE {Users.Id.Name} = @UserId";
return(db.Update(query, parameters));
}
public async Task <bool> AddQuestionToMyLib(string ques_id)
{
var qa = await _context.User.FirstAsync(x => x.UserName == User.Identity.Name);
ques_id = ques_id.Substring(1);
if (string.IsNullOrEmpty(qa.QuestionSet))
{
qa.QuestionSet = "";
}
if (qa.QuestionSet.Contains(ques_id))
{
return(false);
}
else
{
qa.QuestionSet = string.IsNullOrEmpty(qa.QuestionSet) ? ques_id + ";" : qa.QuestionSet + ques_id + ";";
_context.Update(qa);
await _context.SaveChangesAsync();
return(true);
}
}
public int UpdateStudentChildren(StudentChildren studentChildren)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", studentChildren.Id),
new MySqlParameter("@student_id", studentChildren.Student.Id),
new MySqlParameter("@first_name", studentChildren.FirstName),
new MySqlParameter("@last_name", studentChildren.LastName),
new MySqlParameter("@gender", studentChildren.Gender),
new MySqlParameter("@age", studentChildren.Age),
new MySqlParameter("@status", studentChildren.Status),
};
return(_dbContext.Update(Tables.StudentsChildren.UpdateTable, parameters));
}
public OperacaoDTO Sacar(ContaDTO conta, decimal valorSacar)
{
OperacaoDTO operacao = new OperacaoDTO();
var caixaEletronico = _commonDbContext.Caixas.FirstOrDefault();
var contaUsuario = _commonDbContext.Contas.Where(x => x.Banco == conta.BancoContaCli && x.Agencia == conta.AgenciaContaCli && x.NumeroContaCli == conta.NumeroContaCli && x.CpfCliente == conta.CpfCli).FirstOrDefault();
if (_caixaEletronicoDAO.ValidarSaque(valorSacar, contaUsuario, caixaEletronico))
{
var notasParaSaque = _caixaEletronicoDAO.RetornarNotasNecessarias(valorSacar);
caixaEletronico.NotasCem -= notasParaSaque[0];
caixaEletronico.NotasCinquenta -= notasParaSaque[1];
caixaEletronico.NotasVinte -= notasParaSaque[2];
caixaEletronico.NotasDez -= notasParaSaque[3];
caixaEletronico.Valor_Disponivel -= valorSacar;
contaUsuario.SaldoConta -= valorSacar;
conta.SaldoConta = contaUsuario.SaldoConta.ToString().Length < 12 ? Convert.ToDecimal(contaUsuario.SaldoConta.ToString().PadRight(12, '0')) : contaUsuario.SaldoConta;
_commonDbContext.Update(contaUsuario);
_commonDbContext.Update(caixaEletronico);
_commonDbContext.SaveChanges();
operacao.NotasUtilizadas = new int[4] {
notasParaSaque[0], notasParaSaque[1], notasParaSaque[2], notasParaSaque[3]
};
operacao.ValorSacado = valorSacar;
operacao.Conta = conta;
operacao.Realizada = true;
return(operacao);
}
return(operacao);
}
public int UpdateBranchExam(BranchExam branchExam)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", branchExam.Id),
new MySqlParameter("@branch_id", branchExam.Branch.Id),
new MySqlParameter("@failing_sumbit_exam_scholarship_addition", branchExam.SumbitExamScholarshipAddition),
new MySqlParameter("@failing_sumbit_exam_scholarship_reducing", branchExam.FailingSumbitExamScholarshipReducing),
new MySqlParameter("@not_passed_exam_scholarship_addition", branchExam.PassedExamScholarshipAddition),
new MySqlParameter("@not_passed_exam_scholarship_reducing", branchExam.NotPassedExamScholarshipReducing),
new MySqlParameter("@pass_grade", branchExam.PassGrade),
new MySqlParameter("@subject", branchExam.Subject),
};
return(_dbContext.Update(Tables.BranchExams.UpdateTable, parameters));
}
public int UpdateAddress(Address address)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", address.Id),
new MySqlParameter("@country_id", address.Country.Id),
new MySqlParameter("@city_id", address.City.Id),
new MySqlParameter("@neighborhood_name", address.NeighborhoodName != null? address.NeighborhoodName:null),
new MySqlParameter("@street_id", address.Street.Id),
new MySqlParameter("@house_number", address.HouseNumber),
new MySqlParameter("@apartment_number", address.ApartmentNumber != null? address.ApartmentNumber:null),
new MySqlParameter("@zip_code", address.ZipCode != null? address.ZipCode:null)
};
return(_dbContext.Update(Tables.Address.UpdateTable, parameters));
}
public int UpdateUserExtraDetails(UserExtraDetails userExtraDetails)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@user_id", userExtraDetails.UserId),
new MySqlParameter("@identity_number", userExtraDetails.Identitynumber),
new MySqlParameter("@phone_number", userExtraDetails.PhoneNumber),
new MySqlParameter("@cellphone_number", userExtraDetails.CellphoneNumber),
new MySqlParameter("@image", userExtraDetails.Image),
new MySqlParameter("@address_id", userExtraDetails.Address.Id),
new MySqlParameter("@first_name", userExtraDetails.FirstName),
new MySqlParameter("@last_name", userExtraDetails.LastName),
new MySqlParameter("@email", userExtraDetails.Email)
};
return(_dbContext.Update(Tables.UserExtraDetails.UpdateTable, parameters));
}
public OperacaoDTO Sacar(ContaDTO conta, decimal valorSacar)
{
var caixaEletronico = _commonDbContext.Caixas.FirstOrDefault();
var contaUsuario = _commonDbContext.Contas.Where(x => x.NumeroContaCli == conta.NumeroContaCli).FirstOrDefault();
OperacaoDTO operacao = new OperacaoDTO();
if (_caixaEletronicoDAO.ValidarSaque(valorSacar, contaUsuario, caixaEletronico))
{
contaUsuario.SaldoConta -= valorSacar;
conta.SaldoConta = contaUsuario.SaldoConta;
_commonDbContext.Update(contaUsuario);
_commonDbContext.Update(caixaEletronico);
_commonDbContext.SaveChanges();
operacao.Conta = conta;
operacao.Realizada = true;
var notasParaSaque = _caixaEletronicoDAO.RetornarNotasNecessarias(valorSacar);
caixaEletronico.NotasCem -= notasParaSaque[0];
caixaEletronico.NotasCinquenta -= notasParaSaque[1];
caixaEletronico.NotasVinte -= notasParaSaque[2];
caixaEletronico.NotasCem -= notasParaSaque[3];
caixaEletronico.Valor_Disponivel -= valorSacar;
contaUsuario.SaldoConta -= valorSacar;
conta.SaldoConta = contaUsuario.SaldoConta;
_commonDbContext.Update(contaUsuario);
_commonDbContext.Update(caixaEletronico);
_commonDbContext.SaveChanges();
operacao.NotasUtilizadas = new int[4] {
notasParaSaque[0], notasParaSaque[1], notasParaSaque[2], notasParaSaque[3]
};
operacao.ValorSacado = valorSacar;
operacao.Conta = conta;
operacao.Realizada = true;
return(operacao);
}
return(operacao);
}
public async Task <IActionResult> QCreate(ClassForQuestionCreatingModel ob)
{
if (ModelState.IsValid)
{
var tags = ob.tags.Where(x => x.IsSelected).Select(x => x.Id);
/* Пока разрешим создание без тегов
* if (tags.Count() == 0)
* ModelState.AddModelError(string.Empty, "вы должны указать как минимум один тег");
*/
Question obj = new Question();
var StringTags = string.Join(";", tags);
var qa = await _context.User.FirstAsync(x => x.UserName == User.Identity.Name);
obj.CreationDate = DateTime.Now;
obj.UpdateDate = DateTime.Now;
obj.Author = User.Identity.Name;
obj.TagIds = StringTags;
obj.IsPrivate = true;
obj.Definition = ob.Definition;
obj.Proof = ob.Proof;
obj.Title = ob.Title;
_context.Add(obj);
await _context.SaveChangesAsync();
qa.QuestionSet = string.IsNullOrEmpty(qa.QuestionSet) ? obj.Id + ";" : qa.QuestionSet + obj.Id + ";";
_context.Update(qa);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(ob));
}