public async Task <IActionResult> PutDZguba_Elektronika(int id, DZguba_Elektronika dZguba_Elektronika)
{
dZguba_Elektronika.id = id;
dZguba_Elektronika.UpdatedDate = DateTime.Now;
_context.Entry(dZguba_Elektronika).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DZguba_ElektronikaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <DZguba_Elektronika> > PostDZguba_Elektronika(DZguba_Elektronika dZguba_Elektronika)
{
dZguba_Elektronika.CreatedDate = DateTime.Now;
dZguba_Elektronika.UpdatedDate = DateTime.Now;
_context.Entry(dZguba_Elektronika.DUser).State = EntityState.Unchanged;
_context.DZguba_Elektronika.Add(dZguba_Elektronika);
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_Elektronika.DUser.id;
conn.Open();
int rowAffected = command.ExecuteNonQuery();
conn.Close();
}
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDZguba_Elektronika", new { id = dZguba_Elektronika.id }, dZguba_Elektronika));
}
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);
}
