public async Task <ActionResult <DZguba> > PostDZguba(DZguba dZguba) { dZguba.CreatedDate = DateTime.Now; dZguba.UpdatedDate = DateTime.Now; _context.Entry(dZguba.DUser).State = EntityState.Unchanged; _context.DZguby.Add(dZguba); String asd = Configuration.GetConnectionString("DevConnection"); using (var conn = new SqlConnection(asd)) using (var command = new SqlCommand("UserPointsAdd", conn) { CommandType = CommandType.StoredProcedure }) { command.Parameters.Add("@IdUser", SqlDbType.NVarChar); command.Parameters["@IdUser"].Value = dZguba.DUser.id; conn.Open(); int rowAffected = command.ExecuteNonQuery(); conn.Close(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetDZguba", new { id = dZguba.id }, dZguba)); }
public IEnumerable <DZguba> Get() { String asd = Configuration.GetConnectionString("DevConnection"); using (var conn = new SqlConnection(asd)) { SqlCommand cmd = new SqlCommand("GETINNEDZGUBY", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { DZguba obj = new DZguba(); obj.id = Int32.Parse(dr["id"].ToString()); obj.image = null; //Encoding.ASCII.GetBytes(dr["image"].ToString()); obj.imageB = dr["imageB"].ToString(); obj.location = dr["location"].ToString(); obj.name = dr["name"].ToString(); obj.status = dr["status"].ToString(); obj.user = dr["user"].ToString(); obj.freward = dr["freward"].ToString(); InneGet.Add(obj); } } return(InneGet);//new string[] { "value1", "value2" }; }
public async Task <IActionResult> PutDZguba(int id, DZguba dZguba) { dZguba.id = id; dZguba.UpdatedDate = DateTime.Now; _context.Entry(dZguba).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DZgubaExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IEnumerable <DZguba> Get(string byWhat, string regex, string Category) { if (regex == "pusty") { regex = " "; } String asd = Configuration.GetConnectionString("DevConnection"); using (var conn = new SqlConnection(asd)) { SqlCommand cmd = new SqlCommand("SearchByName", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Regex", SqlDbType.NVarChar); cmd.Parameters.Add("@ByWhat", SqlDbType.NVarChar); cmd.Parameters.Add("@Category", SqlDbType.NVarChar); cmd.Parameters["@Regex"].Value = regex; cmd.Parameters["@ByWhat"].Value = byWhat; cmd.Parameters["@Category"].Value = Category; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); if (Category == "Wszystkie") { foreach (DataRow dr in dt.Rows) { DZguba obj = new DZguba(); obj.id = Int32.Parse(dr["id"].ToString()); obj.image = null; //Encoding.ASCII.GetBytes(dr["image"].ToString()); obj.imageB = dr["imageB"].ToString(); obj.location = dr["location"].ToString(); obj.name = dr["name"].ToString(); obj.status = dr["status"].ToString(); obj.user = dr["user"].ToString(); obj.freward = dr["freward"].ToString(); InneGet.Add(obj); } } else if (Category == "Ubranie") { foreach (DataRow dr in dt.Rows) { DZguba_Ubranie obj = new DZguba_Ubranie(); obj.id = Int32.Parse(dr["id"].ToString()); obj.image = null; //Encoding.ASCII.GetBytes(dr["image"].ToString()); obj.imageB = dr["imageB"].ToString(); obj.location = dr["location"].ToString(); obj.name = dr["name"].ToString(); obj.status = dr["status"].ToString(); obj.user = dr["user"].ToString(); obj.RodzajUbranieId = Int32.Parse(dr["RodzajUbranieId"].ToString()); obj.MarkaUbranieId = Int32.Parse(dr["MarkaUbranieId"].ToString()); obj.Kolor = dr["Kolor"].ToString(); InneGet.Add(obj); } } else if (Category == "Zwierze") { foreach (DataRow dr in dt.Rows) { DZguba_Zwierze obj = new DZguba_Zwierze(); Gatunek gatunek = new Gatunek(); obj.id = Int32.Parse(dr["id"].ToString()); obj.image = null; //Encoding.ASCII.GetBytes(dr["image"].ToString()); obj.imageB = dr["imageB"].ToString(); obj.location = dr["location"].ToString(); obj.name = dr["name"].ToString(); obj.status = dr["status"].ToString(); obj.user = dr["user"].ToString(); obj.GatunekId = Int32.Parse(dr["GatunekId"].ToString()); obj.umaszczenie = dr["umaszczenie"].ToString(); obj.freward = dr["freward"].ToString(); InneGet.Add(obj); } } else if (Category == "Inne") { foreach (DataRow dr in dt.Rows) { DZguba obj = new DZguba(); obj.id = Int32.Parse(dr["id"].ToString()); obj.image = null; //Encoding.ASCII.GetBytes(dr["image"].ToString()); obj.imageB = dr["imageB"].ToString(); obj.location = dr["location"].ToString(); obj.name = dr["name"].ToString(); obj.status = dr["status"].ToString(); obj.user = dr["user"].ToString(); obj.freward = dr["freward"].ToString(); InneGet.Add(obj); } } else if (Category == "Elektronika") { foreach (DataRow dr in dt.Rows) { DZguba_Elektronika obj = new DZguba_Elektronika(); obj.id = Int32.Parse(dr["id"].ToString()); obj.image = null; //Encoding.ASCII.GetBytes(dr["image"].ToString()); obj.imageB = dr["imageB"].ToString(); obj.location = dr["location"].ToString(); obj.name = dr["name"].ToString(); obj.status = dr["status"].ToString(); obj.user = dr["user"].ToString(); obj.freward = dr["freward"].ToString(); obj.ProducentsId = Int32.Parse(dr["ProducentsId"].ToString()); obj.RodzajElektronikaId = Int32.Parse(dr["RodzajElektronikaId"].ToString()); InneGet.Add(obj); } } } String test = byWhat + " " + regex + " " + Category; return(InneGet); }