public static RegInfo SearchSingleRecord(String uid) { SqlConnection con = null; RegInfo regobj = new RegInfo(); try { con = DBLogic.GetConnection(); con.Open(); String query = "select * from reg where userid = '" + uid + "'"; SqlCommand com = new SqlCommand(query, con); SqlDataReader dr = com.ExecuteReader(); dr.Read(); regobj.UserId = dr[0].ToString(); regobj.Pass = dr[1].ToString(); regobj.EmailId = dr[2].ToString(); } catch (Exception err) { //Label1.Text = err.Message; } finally { if (con != null) { con.Close(); } } return(regobj); }
public static bool InsertCompConfig(Models.BLModel.CompConfig model, out string message) { message = null; if (model.CPU == 0) { message = "Comp Config is empty"; return(false); } Models.DBModel.CompConfig config = new Models.DBModel.CompConfig { CPU = model.CPU, RAM = model.RAM, VideoCard = model.VideoCard, OS = model.OS }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertCompConfig(config); if (!result) { message = "Comp Config is not added"; } return(true); }
public void PostInsert([FromBody] WebUser wu) { if (wu != null) { DBLogic.WebUserRegister(wu); } }
public static bool InsertGameCatalog(Models.BLModel.GameCatalog model, out string message) { message = null; if (string.IsNullOrEmpty(model.Name)) { message = "Game Catalog is empty"; return(false); } Models.DBModel.GameCatalog video = new Models.DBModel.GameCatalog { Name = model.Name, Price = model.Price, DescribeGame = model.DescribeGame, TypeGame = model.TypeGame, Url = model.Url, Key = model.Key }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertGameCatalog(video); if (!result) { message = " Game Catalog is not added"; } return(true); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); DBLogic.InsertWalletToNewUser(user.Id); DBLogic.InsertBasketToNewUser(user.Id); // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("Index", "Home")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = null; try { con = DBLogic.GetConnection(); con.Open(); //build a query String query = "update reg set password = '******' ,emailid='" + txtemail.Text + "' where userid = '" + txtuserid.Text + "'"; SqlCommand com = new SqlCommand(query, con); //call the method of command object int result = com.ExecuteNonQuery(); if (result > 0) { Label4.Text = "Record is UPDATED successfully"; } } catch (Exception err) { Label4.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
private void Window_Loaded(object sender, RoutedEventArgs e) {//Default list of 5 last requests on load var lcslist = DBLogic.DBGetter(); var border = new BorderCreate(); for (int i = 0; i < lcslist.Count(); i++) { borders.Add(border.createUpperBorder(i, $"Strings: \"{lcslist[i].FirstString}\" + \"{lcslist[i].SecondString}\"", MainGrid)); borders.Add(border.createBottomBorder(i, $"Answer: \"{lcslist[i].AnswerString}\"", MainGrid)); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = DBLogic.FetchAllRecord(); DropDownList1.DataSource = dt; DropDownList1.DataTextField = "userid"; DropDownList1.DataValueField = "userid"; DropDownList1.DataBind(); } }
public IActionResult Index(string id) { if (id == null) { ClaimsPrincipal currentUser = this.User; id = currentUser.FindFirst(ClaimTypes.NameIdentifier).Value; } using (DBLogic db = new DBLogic(context)) { return(View(db.LoadCompany(id))); } }
protected void Button1_Click(object sender, EventArgs e) { DataTable dt = DBLogic.FetchAllRecord(); GridView1.DataSource = dt; GridView1.DataBind(); /* SqlConnection con = null; * try * { * con = DBLogic.GetConnection(); * * String query = "select * from reg "; * * //create the SqlDataAdapter object * SqlDataAdapter da = new SqlDataAdapter(query, con); * * //create the object Dataset * DataSet ds = new DataSet(); * * //Call the fill Method and pass the * //DataSet object * da.Fill(ds); * * //get the no of tables dataset contains * DataTable dt = ds.Tables[0]; * * //bind the dataset table with the GridView * GridView1.DataSource = dt; * GridView1.DataBind(); * } * catch (Exception err) * { * Label1.Text = err.Message; * } * finally * { * if (con != null) * { * con.Close(); * } * }*/ }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String uid = (String)Session["uid"]; RegInfo regobj = DBLogic.SearchSingleRecord(uid); txtuserid.Text = regobj.UserId; txtpass.Text = regobj.Pass; txtemail.Text = regobj.EmailId; } else { txtuserid.Text = ""; txtpass.Text = ""; txtemail.Text = ""; } }
public IActionResult Index(int page = 1) { using (var db = new DBLogic(context)) { int pageSize = 5; // количество элементов на странице IEnumerable <Company> source = db.LoadCompany(); var count = source.Count(); var items = source.Skip((page - 1) * pageSize).Take(pageSize); PageViewModel pageViewModel = new PageViewModel(count, page, pageSize); CompanyViewModel viewModel = new CompanyViewModel { PageViewModel = pageViewModel, Company = items }; return(View(viewModel)); } }
private List <Border> borders = new List <Border>();//List of dynamic created borderboxes private void Accept_Button_Click(object sender, RoutedEventArgs e) { if (DesktopLogic.checkAcception(Str1TextBox, Str2TextBox))//if we typed smth { var border = new BorderCreate(); DesktopLogic.clearBorders(borders, MainGrid); DBLogic.DBSetter(Str1TextBox.Text, Str2TextBox.Text); var lcslist = DBLogic.DBGetter();//Sending data to DB and making answer Borderbox visible AnswerBox.Visibility = Visibility.Visible; AnswerText.Text = $"Answer: \"{lcslist.FirstOrDefault().AnswerString}\" "; for (int i = 0; i < lcslist.Count(); i++) { borders.Add(border.createUpperBorder(i, $"Strings: \"{lcslist[i].FirstString}\" + \"{lcslist[i].SecondString}\"", MainGrid)); borders.Add(border.createBottomBorder(i, $"Answer: \"{lcslist[i].AnswerString}\"", MainGrid)); } } else { MessageBox.Show("Please enter correct values", "Error");//If we don't enter anything } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = null; Label1.Text = DropDownList1.SelectedValue; try { con = DBLogic.GetConnection(); String query = "select * from reg where userid = '" + DropDownList1.SelectedValue + "'"; //create the SqlDataAdapter object SqlDataAdapter da = new SqlDataAdapter(query, con); //create the object Dataset DataSet ds = new DataSet(); //Call the fill Method and pass the //DataSet object da.Fill(ds); //get the no of tables dataset contains DataTable dt = ds.Tables[0]; //bind the dataset table with the GridView GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception err) { Label1.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
public static bool InsertRam(Models.BLModel.Ram model, out string message) { message = null; if (model.SizeRam == 0) { message = "Ram is empty"; return(false); } Models.DBModel.Ram ram = new Models.DBModel.Ram { SizeRam = model.SizeRam }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertRam(ram); if (!result) { message = "Ram is not added"; } return(true); }
public static bool InsertTypeGame(Models.BLModel.TypeGame model, out string message) { message = null; if (string.IsNullOrEmpty(model.NameJanr)) { message = "Type game is empty"; return(false); } Models.DBModel.TypeGame typeGameDB = new Models.DBModel.TypeGame { NameJanr = model.NameJanr }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertTypeGame(typeGameDB); if (!result) { message = "Type game is not added"; } return(true); }
public static bool InsertCpu(Models.BLModel.Cpu model, out string message) { message = null; if (string.IsNullOrEmpty(model.Model)) { message = "Cpu is empty"; return(false); } Models.DBModel.Cpu cpu = new Models.DBModel.Cpu { Model = model.Model }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertCpu(cpu); if (!result) { message = "Cpu is not added"; } return(true); }
public static bool InsertVideoCard(Models.BLModel.VideoCard model, out string message) { message = null; if (string.IsNullOrEmpty(model.Model)) { message = "Video Card is empty"; return(false); } Models.DBModel.VideoCard video = new Models.DBModel.VideoCard { Model = model.Model, SizeVC = model.SizeVC }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertVideoCard(video); if (!result) { message = "Video Card is not added"; } return(true); }
public static bool InsertOS(Models.BLModel.OS model, out string message) { message = null; if (string.IsNullOrEmpty(model.Name)) { message = "Operation system is empty"; return(false); } Models.DBModel.OS oS = new Models.DBModel.OS { Name = model.Name, VersionOS = model.VersionOS }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.InsertOs(oS); if (!result) { message = "Operation system is not added"; } return(true); }
public static DataTable FetchAllRecord() { SqlConnection con = null; DataTable dt = null; try { con = DBLogic.GetConnection(); String query = "select * from reg "; //create the SqlDataAdapter object SqlDataAdapter da = new SqlDataAdapter(query, con); //create the object Dataset DataSet ds = new DataSet(); //Call the fill Method and pass the //DataSet object da.Fill(ds); //get the no of tables dataset contains dt = ds.Tables[0]; } catch (Exception err) { //Label1.Text = err.Message; } finally { if (con != null) { con.Close(); } } return(dt); }
protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = null; try { con = DBLogic.FetchAllRecord(); con.Open(); //build a query String query = "delete from reg where userid ='" + txtuserid.Text + "'"; SqlCommand com = new SqlCommand(query, con); //call the method of command object int result = com.ExecuteNonQuery(); if (result > 0) { Label2.Text = "Record DELETED successfully"; } else { Label2.Text = "NO Record FOUND"; } } catch (Exception err) { Label2.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
public static bool DeleteTypeGame(Models.BLModel.TypeGame model, out string message) { message = null; if (model.Id == 0) { message = "Choose record"; return(false); } Models.DBModel.TypeGame typeGame = new Models.DBModel.TypeGame { NameJanr = model.NameJanr, Id = model.Id }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.DeleteTypeGame(typeGame); if (!result) { message = "Delete 0 rows"; return(false); } return(true); }
protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = null; try { con = DBLogic.GetConnection(); con.Open(); String query = "select * from reg where userid = '" + txtuserid.Text + "' and password = '******'"; SqlCommand com = new SqlCommand(query, con); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { Session["uid"] = txtuserid.Text; Response.Redirect("AfterLogin.aspx"); } else { Label4.Text = "INVALID UID OR PASS"; } } catch (Exception err) { Label4.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
public static bool DeleteOs(Models.BLModel.OS model, out string message) { message = null; if (model.Id == 0) { message = "Choose record"; return(false); } Models.DBModel.OS os = new Models.DBModel.OS { Name = model.Name, Id = model.Id }; DBLogic dBLogic = new DBLogic(connectionString); var result = dBLogic.DeleteOs(os); if (!result) { message = "Delete 0 rows"; return(false); } return(true); }
public void PostInsert([FromBody] RestaurantOwner ro) { DBLogic.InsertRestaurantOwner(ro); }
public RestaurantOwner PostLogin([FromBody] Login loginObject) { return(DBLogic.GetRestaurantOwner(loginObject)); }
public void Post([FromBody] DataModell data) { DBLogic.CreateUser(data.UserId, data.FirstName, data.LastName, data.EmailAddress, data.Age); }
public ActionResult <IEnumerable <DataModell> > Get() { return(DBLogic.LoadUsers()); }
public RestaurantsUserCombo Grade([FromBody] RestaurantUserCombo restaurantUserCombo) { return(DBLogic.GradeRestaurant(restaurantUserCombo)); }
public GradeSpread GetGrade(string restaurantName) { return(DBLogic.ListOfGradeForRestaurant(restaurantName)); }