public User(int id, string fName, string mName, string lName, string imgPath, string degree, string email, string summery, bool administrator) { db = new DBServices(); this.id = id; this.fName = fName; this.mName = mName; this.lName = lName; this.imgPath = imgPath; this.degree = degree; this.email = email; this.summery = summery; this.administrator = administrator; }
// GET: Inventory public ActionResult Inventory() { var inventory = new List <InventoryModel>(); var invData = DBServices.GetTblView("exce sampleprocedure"); if (invData.Count > 0) { inventory = DBServices.ToList <InventoryModel>(invData); } return(View(inventory)); }
public static int DeleteItem(int userid, int itemid) { int check = DBServices.DeleteItem(userid, itemid); if (check == 0) { } else { } return(check); }
private void buttonGuardar_Click(object sender, EventArgs e) { DBServices = new DBServices(); Models.Person p = new Models.Person(); p.Born = fborn.Value; p.Cuit = textBoxCuit.Text; p.Dni = textBoxDNI.Text; p.Genre = genre.Text; p.Name = textBoxNombre.Text; p.Tipo = ype.Text; DBServices.AddPersona(p); this.Close(); }
public static int UpdateItem(string itemid, string userId, string userName, string userPhone, string itemType, string itemName, string city, string region, string itemAbout, string itemImg) { int check = DBServices.UpdateItem(itemid, userId, userName, userPhone, itemType, itemName, city, region, itemAbout, itemImg); if (check == 1) { } else { } return(check); }
public static string GetPlacesFromFavorite(int userid) { List <Place> p = DBServices.GetPlacesFromFavorite(userid); if (p != null) { return(new JavaScriptSerializer().Serialize(p)); } else { return(new JavaScriptSerializer().Serialize("No Places")); } }
public static string GetPlacesHouses(string rb) { List <Place> p = DBServices.GetPlacesHouses(rb); if (p != null) { return(new JavaScriptSerializer().Serialize(p)); } else { return(new JavaScriptSerializer().Serialize("No Places")); } }
public static String RegisterWithGoogle(string firstName, string lastName, string email, string password) { User u = DBServices.RegisterWithGoogle(firstName, lastName, email, password); if (u != null) { } else { } return(new JavaScriptSerializer().Serialize(u)); }
public static string EditProfile(string id, string firstName, string lastName, string email, string password) { User u = DBServices.EditProfile(id, firstName, lastName, email, password); if (u != null) { } else { } return(new JavaScriptSerializer().Serialize(u)); }
public static String Register(string firstName, string lastName, string email, string password, string gender, string birthday) { User u = DBServices.Register(firstName, lastName, email, password, gender, birthday); if (u != null) { } else { } return(new JavaScriptSerializer().Serialize(u)); }
public List <Product> getProducts() { DBServices datab = new DBServices(); List <Product> pl = datab.getList(); List <Product> pl1 = new List <Product>(); foreach (Product p in pl) { pl1.Add(p); } return(pl1); }
public ActionResult GetQueryResults(QueryResults model) { var inventory = new List <InventoryModel>(); var invData = DBServices.GetTblView("exce sampleprocedure"); if (invData.Count > 0) { inventory = DBServices.ToList <InventoryModel>(invData); } return(PartialView("_QueryResults", inventory)); }
public static int AddReminder(string itemName, int userid, string token) { int check = DBServices.AddReminder(itemName, userid, token); if (check == 1) { } else { } return(check); }
public static string GetItemTypes() { List <ItemTypes> itemTypes = DBServices.GetItemTypes(); if (itemTypes != null) { return(new JavaScriptSerializer().Serialize(itemTypes)); } else { return(new JavaScriptSerializer().Serialize("No itemType")); } }
public static int InsertFavorite(int userid, int itemid) { int check = DBServices.InsertFavorite(userid, itemid); if (check == 1) { } else { } return(check); }
public static string GetAssociationTypes() { List <AssociationType> associationTypes = DBServices.GetAssociationTypes(); if (associationTypes != null) { return(new JavaScriptSerializer().Serialize(associationTypes)); } else { return(new JavaScriptSerializer().Serialize("No AssociationTypes")); } }
public static string Login(string email, string password) { User u = DBServices.Login(email, password); if (u != null) { } else { } return(new JavaScriptSerializer().Serialize(u)); }
public static string UploadImage(string base64, string imageName, int userid) { string check = DBServices.UploadImage(base64, imageName, userid); if (check != null) { } else { } return(new JavaScriptSerializer().Serialize(check)); }
public static string GetReminders(int userid) { List <Reminder> p = DBServices.GetReminders(userid); if (p != null) { return(new JavaScriptSerializer().Serialize(p)); } else { return(new JavaScriptSerializer().Serialize("No reminder")); } }
public static string GetItemsByID(int userid) { List <Item> p = DBServices.GetItemsByID(userid); if (p != null) { return(new JavaScriptSerializer().Serialize(p)); } else { return(new JavaScriptSerializer().Serialize("No Items")); } }
public static int DeleteReminder(int userid, string itemName) { int check = DBServices.DeleteReminder(userid, itemName); if (check == 0) { } else { } return(check); }
public ActionResult Delete() { RemoveAllRoom(Request["id"]); SqlConnection con = new SqlConnection(); SqlCommand command = new SqlCommand(); con = DBServices.openConnection(); command.Connection = con; command.CommandText = @"Delete from Motel where ID=@Id "; command.Parameters.Add("@Id", SqlDbType.VarChar, 10).Value = Request["id"]; command.ExecuteNonQuery(); con.Close(); return(RedirectToAction("ViewMotel", "Motel")); }
public Manager readSpecificUserManager(double username_id, string password) { DBServices dbs = new DBServices(); Manager DBuser = dbs.readSpecificUserManagerDB(username_id, password, "studentDBConnectionString", "Manager"); if (DBuser == null) { return(null); } else { return(DBuser); } }
public ActionResult Update() { SqlConnection con = new SqlConnection(); SqlCommand command = new SqlCommand(); con = DBServices.openConnection(); command.Connection = con; command.CommandText = @"Update Motel set Information =@Info where ID=@Id"; command.Parameters.Add("@Info", SqlDbType.NVarChar, 500).Value = (string)Request["UpdateInformation"]; command.Parameters.Add("@Id", SqlDbType.VarChar, 10).Value = Request["id"]; command.ExecuteNonQuery(); con.Close(); return(RedirectToAction("ViewMotel", "Motel")); }
public List <List <OrderData> > Get([FromBody] int[] spaces) { List <List <OrderData> > orderdata = new List <List <OrderData> >(); DBServices dbs = new DBServices(); string today = DateTime.Today.ToString("dd/MM/yyyy"); foreach (int item in spaces) { List <OrderData> o = dbs.readOrdersDataBySpaceId(item); orderdata.Add(o); } return(orderdata); }
public List <string> readfromyDS(string tablNeame) { DBServices dbs = new DBServices(); dbs = dbs.ReadFromDataBase("DBConnectionString", tablNeame); List <string> readfromyDS = new List <string>(); foreach (DataRow dr in dbs.dt.Rows) { string drdbs = (string)dr[tablNeame + "_Name"]; readfromyDS.Add(drdbs.ToString()); } return(readfromyDS); }
public List <Student> getStuListCAL(string id, string date) { DBServices dbs = new DBServices(); List <Student> stuList = dbs.getStuListCAL(id, date); if (stuList == null) { return(null); } else { return(stuList); } }
public ActualLesson readSpecificActualLesson(int actl_num) { DBServices dbs = new DBServices(); ActualLesson DBuser = dbs.readSpecificActualLesson(actl_num, "studentDBConnectionString", "ActualLesson"); if (DBuser == null) { return(null); } else { return(DBuser); } }
public ActionResult Edit(int recipeid) { Recipe recipe = DBServices.GetRecipe(recipeid); if (recipe.Owner.Equals(this.User?.Identity.GetUserId())) { ViewBag.Recipe = recipe; return(View()); } else { return(RedirectToAction("Index", "Home")); } }
public Tigburim getTigburById(string tigID) { int TigID = Convert.ToInt16(tigID); DBServices dbs = new DBServices(); Tigburim DBTigbur = dbs.getTigburById(TigID, "studentDBConnectionString", "Lesson"); if (DBTigbur == null) { return(null); } else { return(DBTigbur); } }