public bool CreateDoctors(ZayavkiModels ZayavkiModel)
{
//ZayavkiModels zayavki = db.FIO.Find();
bool result = true;
string connectionString = @"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-WebApplication1-20201104082923.mdf;Initial Catalog=aspnet-WebApplication1-20201104082923;Integrated Security=True";
string sqlExpression = "INSERT INTO Zayavki ([Date], [Doctor], [FIOp], [EmailZ]) VALUES (@Date, @Doctor, @FIOp, @EmailZ) Select Patient.Email FROM Patient WHERE Patient.Email=@EmailZ";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand sql = new SqlCommand(sqlExpression, connection);
sql.Parameters.Add("@Date", SqlDbType.DateTime);
sql.Parameters["@Date"].Value = ZayavkiModel.Date;
sql.Parameters.Add("@Doctor", SqlDbType.NVarChar);
sql.Parameters["@Doctor"].Value = ZayavkiModel.Doctor;
sql.Parameters.Add("@FIOp", SqlDbType.NVarChar);
sql.Parameters["@FIOp"].Value = ZayavkiModel.FIO;
sql.Parameters.Add("@EmailZ", SqlDbType.NVarChar);
sql.Parameters["@EmailZ"].Value = ZayavkiModel.EmailZ;
try
{
connection.Open();
Int32 rowsAffected = sql.ExecuteNonQuery();
Console.WriteLine("RowsAffected: {0}", rowsAffected);
}
catch (Exception)
{
result = false;
}
return(result);
}
}
public bool Edit(ZayavkiModels ZayavkiModel)
{
bool result = true;
string connectionString = @"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-WebApplication1-20201104082923.mdf;Initial Catalog=aspnet-WebApplication1-20201104082923;Integrated Security=True";
string sqlExpression = "UPDATE Zayavki SET Recept=@Recept, Disease=@Disease WHERE Zayavki.EmailZ=Zayavki.EmailZ and Zayavki.Doctor=Zayavki.Doctor";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand sql = new SqlCommand(sqlExpression, connection);
sql.Parameters.Add("@Recept", SqlDbType.NVarChar);
sql.Parameters["@Recept"].Value = ZayavkiModel.Recept;
sql.Parameters.Add("@Disease", SqlDbType.NVarChar);
sql.Parameters["@Disease"].Value = ZayavkiModel.Disease;
try
{
connection.Open();
Int32 rowsAffected = sql.ExecuteNonQuery();
Console.WriteLine("RowsAffected: {0}", rowsAffected);
}
catch (Exception)
{
result = false;
}
return(result);
}
}
public ActionResult Delete(ZayavkiModels ZayavkiModel)
{
using (var context = new ApplicationDbContext())
{
var copy = @"INSERT Disease ([Date], [Doctor], [Recept], [FIOp], [EmailZ],[EmailQ], [Disease]) SELECT [Date], [Doctor], [Recept], [FIOp], [EmailZ],[EmailQ], [Disease] FROM Zayavki where Zayavki.Date IN(SELECT TOP (1) Date FROM Zayavki ORDER BY Date ASC)"; /*WHERE Zayavki.EmailZ='" + User.Identity.Name + "'"*/
var resultcopy = context.Database.SqlQuery <ZayavkiModels>(copy).ToList();
var sqldelete = @"Delete from Zayavki where Zayavki.Date IN(SELECT TOP (1) Date FROM Zayavki ORDER BY Date ASC)";
var result = context.Database.SqlQuery <ZayavkiModels>(sqldelete).ToList();
}
return(Redirect("/Zayavki/Index"));
}
public ActionResult CreateDoctors([Bind(Exclude = "")] ZayavkiModels ZayavkiModel)
{
try
{
if (Zayavki.CreateDoctors(ZayavkiModel))
{
return(RedirectToAction("Index"));
}
else
{
return(View("CreateDoctors"));
}
}
catch
{
return(View("CreateDoctors"));
}
}
public ActionResult Edit([Bind(Exclude = "")] ZayavkiModels ZayavkiModel)
{
try
{
if (Zayavki.Edit(ZayavkiModel))
{
return(RedirectToAction("Index"));
}
else
{
return(View("Edit"));
}
}
catch
{
return(View("Edit"));
}
}
