private void postDGV_FirstReload()
{
postDGV.Rows.Clear();
serveList = Serve.Get();
postList = Post.Get();
comboBoxServe.Items.Clear();
foreach (Post post in postList)
{
foreach (Serve serve in serveList)
{
if (GetPostServe(post, serve) != "0")
{
postDGV.Rows.Add(post.idpost, post.title, post.salary, serve.name);
}
}
}
for (int i = 0; i < postDGV.RowCount; ++i)
{
postDGV.Rows[i].Selected = false;
}
foreach (Serve serve in serveList)
{
comboBoxServe.Items.Add(serve.name);
}
comboBoxServe.SelectedIndex = -1;
textBoxPost.Text = "";
textBoxSalary.Text = "";
comboBoxServe.Text = null;
choosenIndexPost = -1;
}
public async Task <IActionResult> Edit(int id, [Bind("ServeID,MealID,MealName,DishID,DishName")] Serve serve)
{
if (id != serve.ServeID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(serve);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ServeExists(serve.ServeID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DishID"] = new SelectList(_context.Dishes, "DishID", "DishID", serve.DishID);
ViewData["MealID"] = new SelectList(_context.Meal, "MealID", "MealID", serve.MealID);
return(View(serve));
}
//---------------------------------------------SERVE TABLE--------------------------------------------------------------
private string GetCafeServe(Cafe cafe, Serve serve)
{
if (cafe.idcafe == serve.cafe.idcafe)
{
return(cafe.address);
}
return("0");
}
private string GetPostServe(Post post, Serve serve)
{
if (post.serve.idserve == serve.idserve)
{
return(serve.name);
}
return("0");
}
public ServeViewModel(INavigationService navigator, RallyViewModel rallyViewModel, Team team)
{
_navigator = navigator;
RallyViewModel = rallyViewModel;
Serve = new Serve();
Serve.Team = team;
Team = team;
SaveCommand = new Command(Save);
}
public static short GetServeBit(Serve serve)
{
switch (serve) {
case Serve.Serve1Player:
return default(short);
case Serve.Serve2Player:
var number = (1 << 15);
return (short)number;
default:
return default(short);
}
}
private Serve serveGetFromForm()
{
int i = 0;
Serve newServe = new Serve();
if (string.IsNullOrWhiteSpace(textBoxName.Text) || string.IsNullOrEmpty(textBoxName.Text))
{
ErrorlabelServe.Text = "Ошибка:\r\nПоле \"ФИО сотрудника\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
newServe.name = textBoxName.Text;
}
if (string.IsNullOrWhiteSpace(textBoxPassport.Text) || string.IsNullOrEmpty(textBoxPassport.Text))
{
ErrorlabelServe.Text = "Ошибка:\r\nПоле \"Паспортные данные\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
newServe.passport = Convert.ToInt32(textBoxPassport.Text);
}
newServe.education = textBoxEducation.Text;
if (string.IsNullOrWhiteSpace(textBoxExperience.Text) || string.IsNullOrEmpty(textBoxExperience.Text))
{
ErrorlabelServe.Text = "Ошибка:\r\nПоле \"Опыт работы\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
newServe.experience = Convert.ToInt32(textBoxExperience.Text);
}
if (string.IsNullOrWhiteSpace(comboBoxServeCafe.Text) || string.IsNullOrEmpty(comboBoxServeCafe.Text))
{
ErrorlabelServe.Text = "Ошибка:\r\nПоле \"Адрес кофейни\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
while (comboBoxServeCafe.Text != cafeList[i].address)
{
++i;
}
newServe.cafe = Cafe.Get(cafeList[i].idcafe);
}
return(newServe);
}
public async Task <IActionResult> Create([Bind("ServeID,MealID,MealName,DishID,DishName")] Serve serve)
{
if (ModelState.IsValid)
{
_context.Add(serve);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DishID"] = new SelectList(_context.Dishes, "DishID", "DishID", serve.DishID);
ViewData["MealID"] = new SelectList(_context.Meal, "MealID", "MealID", serve.MealID);
return(View(serve));
}
public static void Main(string[] args)
{
Console.WriteLine("Welcome to the soda machine");
Console.WriteLine("Type 0 for Soda and 1 for exit");
int userSelect = int.Parse(Console.ReadLine());
if (userSelect == 0)
{
Console.WriteLine("Which type of soda do you want?");
Console.WriteLine("You can choose \n 1 for Cola \n 2 for Urge \n 3 for sprite \n 4 for Fanta \n 5 for Dr Pepper \n 6 for Monster ");
int sodaselect = int.Parse(Console.ReadLine());
Serve sodaCstr1 = new Serve();
sodaCstr1.Validate(sodaselect);
}
}
private void servAddButton_Click(object sender, EventArgs e)
{
ErrorlabelServe.Text = "";
try
{
Serve.Insert(serveGetFromForm());
}
catch (System.ArgumentNullException)
{
return;
}
catch (System.Data.SqlClient.SqlException)
{
ErrorlabelServe.Text = "Невозможно добавить запись с таким же именем.";
return;
}
servDGV_Reload();
}
private void servChangeButton_Click(object sender, EventArgs e)
{
if (choosenIndexServe == -1)
{
ErrorlabelServe.Text = "Ошибка:\r\nНе выбрано ни одной действительной записи.";
return;
}
ErrorlabelServe.Text = "";
try
{
Serve.Update(serveList[choosenIndexServe].idserve, serveGetFromForm());
}
catch (System.ArgumentNullException)
{
return;
}
servDGV_Reload();
}
private bool GetCafeServ(Cafe cafe)
{
serveList = Serve.Get();
postList = Post.Get();
foreach (Serve serve in serveList)
{
if (cafe.idcafe == serve.cafe.idcafe)//смотрим есть ли в этом кафе сотрудники
{
foreach (Post post in postList)
{
if (serve.idserve == post.serve.idserve)//смотрим есть ли должность у сотрудника
{
return(true);
}
}
}
}
return(false);
}
private Post postGetFromForm()
{
int i = 0;
Post newPost = new Post();
if (string.IsNullOrWhiteSpace(textBoxPost.Text) || string.IsNullOrEmpty(textBoxPost.Text))
{
ErrorlabelPost.Text = "Ошибка:\r\nПоле \"Должность\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
newPost.title = textBoxPost.Text;
}
if (string.IsNullOrWhiteSpace(textBoxSalary.Text) || string.IsNullOrEmpty(textBoxSalary.Text))
{
ErrorlabelPost.Text = "Ошибка:\r\nПоле \"Зарплата\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
newPost.salary = Convert.ToInt32(textBoxSalary.Text);
}
if (string.IsNullOrWhiteSpace(comboBoxServe.Text) || string.IsNullOrEmpty(comboBoxServe.Text))
{
ErrorlabelPost.Text = "Ошибка:\r\nПоле \"Сотрудник\" должно быть обязательно заполнено.";
throw new System.ArgumentNullException();
}
else
{
while (comboBoxServe.Text != serveList[i].name)
{
++i;
}
newPost.serve = Serve.Get(serveList[i].idserve);
}
return(newPost);
}
private void servDeleteButton_Click(object sender, EventArgs e)
{
ErrorlabelServe.Text = "";
bool changed = false;
for (int i = 0; i < servDGV.Rows.Count; ++i)
{
if (servDGV.Rows[i].Selected)
{
DialogResult dialogResult = MessageBox.Show("Вы действительно хотите удалить сотрудника " + servDGV[1, i].Value.ToString() + " ?", "Предупреждение!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
Serve.Delete(serveList[i].idserve);
}
catch (System.Data.SqlClient.SqlException)
{
ErrorlabelServe.Text = "Ошибка:\r\nУдаление данной записи невозможно, поскольку на неё ссылаются другие записи.";
}
changed = true;
}
else
{
return;
}
}
}
if (changed)
{
servDGV_Reload();
}
else
{
ErrorlabelServe.Text = "Ошибка:\r\nНе выбрано ни одной действительной записи.";
}
}
private void servDGV_FirstReload()
{
servDGV.Rows.Clear();
cafeList = Cafe.Get();
serveList = Serve.Get();
comboBoxServeCafe.Items.Clear();
foreach (Serve serve in serveList)
{
foreach (Cafe cafe in cafeList)
{
if (GetCafeServe(cafe, serve) != "0")
{
servDGV.Rows.Add(serve.idserve, serve.name, serve.passport, serve.education, serve.experience, cafe.address);
}
}
}
for (int i = 0; i < servDGV.RowCount; ++i)
{
servDGV.Rows[i].Selected = false;
}
foreach (Cafe cafe in cafeList)
{
comboBoxServeCafe.Items.Add(cafe.address);
}
comboBoxServeCafe.SelectedIndex = -1;
textBoxName.Text = "";
textBoxPassport.Text = "";
textBoxEducation.Text = "";
textBoxExperience.Text = "";
comboBoxServeCafe.Text = null;
choosenIndexServe = -1;
}
public static string update_list_serve(int id_mov, List <Serve> list_serve, int type, int id_user)
{
MySqlConnection conn = new MySqlConnection(ConnnectData.connectionString);
conn.Open();
try
{
string sql = "";
sql = " select t0.id,t0.id_movie from t_mov_serve t0 where t0.id_movie = " + id_mov + " ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
List <Serve> list_temp = new List <Serve>();
foreach (DataRow r in ds.Tables[0].Rows)
{
Serve t = new Serve();
t.id = Convert.ToInt32(r["id"].ToString());
list_temp.Add(t);
}
HashSet <int> writerIds = new HashSet <int>(list_temp.Select(x => x.id));
List <Serve> temp1 = list_serve.Where(x => !writerIds.Contains(x.id)).ToList();
foreach (Serve t in temp1)
{
sql = "INSERT INTO t_mov_serve (id, id_movie,url,id_serve, creattime, user_creat) " +
"VALUES ('" + t.id + "', '" + id_mov + "',N'" + t.url + "', '" + t.id_serve + "' , CURRENT_DATE(), '" + id_user + "');";
cmd = new MySqlCommand(sql, conn);
int i = cmd.ExecuteNonQuery();
foreach (Quality q in t.list_quality)
{
sql = "INSERT INTO t_mov_quality (id, id_serve, id_movie, name, url, width, height, type_file, size_MB, creattime, creat_user)" +
" VALUES ('" + q.id + "', '" + t.id + "', '" + id_mov + "', '" + q.name + "', ' ', '" + q.width + "', '" + q.height + "', N'" + MySqlHelper.EscapeString(q.type_file) + "' , " +
"'" + q.size_MB + "', CURRENT_TIME(), '" + id_user + "');";
cmd = new MySqlCommand(sql, conn);
i = cmd.ExecuteNonQuery();
}
}
writerIds = new HashSet <int>(list_serve.Select(x => x.id));
temp1 = list_temp.Where(x => !writerIds.Contains(x.id)).ToList();
foreach (Serve t in temp1)
{
sql = "delete from t_mov_serve where id='" + t.id + "' and id_movie='" + id_mov + "'";
cmd = new MySqlCommand(sql, conn);
int i = cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Clone();
}
}
return("");
}
public HttpResponseMessage Get_id(int idmovie)
{
string json = "";
var res = Request.CreateResponse(HttpStatusCode.OK);
MySqlConnection conn = new MySqlConnection(ConnnectData.connectionString);
conn.Open();
try
{
string sql = "";
sql += "SELECT ";
sql += " t0.id id, ";
sql += " t0.name name, ";
sql += " t0.n_view n_view, ";
sql += " t0.n_like n_like, ";
sql += " t0.year_movie year, ";
sql += " t0.warning warning, ";
sql += " t0.content content, ";
sql += " t0.urlavatar urlavatar, ";
sql += " t0.content_re content_re, ";
sql += " t0.time_thoiluong time, ";
sql += " t0.creattime creattime, ";
sql += " t0.user_creat user_creat, ";
sql += " t5.name user_creat_name, ";
sql += " t2.name company, ";
sql += " t0.type_mov type_mov, ";
sql += " t0.is_series is_series, ";
sql += " t3.n_movie part_num, ";
sql += " t4.count_movie part_total, ";
sql += " t4.name series_name ";
sql += " FROM t_movie t0 ";
sql += " left join t_company t2 on t0.id_company = t2.id ";
sql += " left join t_mov_series t3 on t0.id = t3.id ";
sql += " left join t_series t4 on t3.id_series = t4.id";
sql += " left join t_user t5 on t5.id = t0.user_creat";
sql += " where t0.id=" + idmovie + "";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.Connection = conn;
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
res = Request.CreateResponse(HttpStatusCode.NotFound);
res.Content = new StringContent("No data found", Encoding.UTF8, "application/json");
return(res);
}
Movie mov = new Movie();
foreach (DataRow r in ds.Tables[0].Rows)
{
mov = new Movie();
mov.id = Convert.ToInt32(r["id"]);
mov.name = r["name"].ToString();
mov.name_re = "";
mov.name_en = "";
mov.n_view = Convert.ToInt32(r["n_view"]);
mov.n_like = Convert.ToInt32(r["n_like"]);
mov.year_movie = Convert.ToInt32(r["year"]);
mov.time_thoiluong = Convert.ToInt32(r["time"]);
mov.warning = Convert.ToInt32(r["warning"]);
mov.content = r["content"].ToString();
mov.content_re = r["content_re"].ToString();
mov.urlavatar = r["urlavatar"].ToString();
Company company = new Company();
company.name = r["company"].ToString();
mov.company = company;
//---------------------------------------user_creat-------------------------------------------------
User user = new User();
user.id = Convert.ToInt32(r["user_creat"]);
user.name = r["user_creat_name"].ToString();
mov.user_creat = user;
mov.createtime = Convert.ToDateTime(r["creattime"].ToString());
//---------------------------------------series_name-------------------------------------------------
if (Convert.ToInt32(r["is_series"].ToString()) == 1)
{
Series series = new Series();
series.name = r["series_name"].ToString();
series.content = "Part " + r["part_num"].ToString() + "/" + r["part_total"].ToString();
mov.series = series;
}
mov.type_mov = Convert.ToInt32(r["type_mov"]);
//---------------------------------------Actor-------------------------------------------------
sql = "";
sql += "select name from t_mov_actor t0 left join t_actor t1 on t0.id_actor=t1.id where t0.id_mov=" + idmovie;
cmd = new MySqlCommand(sql, conn);
MySqlDataAdapter adap2 = new MySqlDataAdapter(cmd);
DataSet ds2 = new DataSet();
adap2.Fill(ds2);
List <Actor> lst_actor = new List <Actor>();
foreach (DataRow r2 in ds2.Tables[0].Rows)
{
Actor actor = new Actor();
actor.name = r2["name"].ToString();
lst_actor.Add(actor);
}
mov.actor = lst_actor.ToArray();
//---------------------------------------Tag-------------------------------------------------
sql = "";
sql += "select t1.id,t1.name from t_tag1 t0 left join t_tag t1 on t0.id_tag=t1.id where t0.id_movie=" + idmovie;
cmd = new MySqlCommand(sql, conn);
adap2 = new MySqlDataAdapter(cmd);
ds2 = new DataSet();
adap2.Fill(ds2);
List <Tag> lst_tagr = new List <Tag>();
foreach (DataRow r2 in ds2.Tables[0].Rows)
{
Tag tag = new Tag();
tag.id = Convert.ToInt32(r2["id"]);
tag.name = r2["name"].ToString();
lst_tagr.Add(tag);
}
mov.tag = lst_tagr.ToArray();
//---------------------------------------Catalog -------------------------------------------------
sql = "";
sql += "select t1.id,t1.name from t_mov_cata t0 left join t_catalog t1 on t0.id_catalog=t1.id where t0.id_mov=" + idmovie;
cmd = new MySqlCommand(sql, conn);
adap2 = new MySqlDataAdapter(cmd);
ds2 = new DataSet();
adap2.Fill(ds2);
List <Catalog> lst_catalog = new List <Catalog>();
foreach (DataRow r2 in ds2.Tables[0].Rows)
{
Catalog cata = new Catalog();
cata.id = Convert.ToInt32(r2["id"]);
cata.name = r2["id"].ToString();
lst_catalog.Add(cata);
}
mov.catalog = lst_catalog.ToArray();
//---------------------------------------URL-------------------------------------------------
sql = "";
sql += "select url from t_mov_serve where id=" + idmovie;
cmd = new MySqlCommand(sql, conn);
adap2 = new MySqlDataAdapter(cmd);
ds2 = new DataSet();
adap2.Fill(ds2);
List <Serve> lst_serve = new List <Serve>();
foreach (DataRow r2 in ds2.Tables[0].Rows)
{
Serve ser = new Serve();
ser.url = r2["url"].ToString();
lst_serve.Add(ser);
}
mov.serve = lst_serve.ToArray();
}
json = JsonConvert.SerializeObject(mov);
}
catch (Exception)
{
throw;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Clone();
}
}
res.Content = new StringContent(json.ToString(), Encoding.UTF8, "application/json");
return(res);
}
