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