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); }