public async Task <IActionResult> PostServer_Info([FromBody] server Server_Info)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.servers.Add(Server_Info);
// await _context.SaveChangesAsync();
_context.SaveChanges();
return(CreatedAtAction("GetServer_Info", new { id = Server_Info.Server_ID }, Server_Info));
//return Ok(Server_Info);
}
public async Task <IActionResult> PostArchivalreq([FromBody] Archivalreq[] archivalreq)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
for (int i = 0; i < archivalreq.Length; i++)
{
_context.Archivalreqs.Add(archivalreq[i]);
}
//await _context.SaveChangesAsync();
_context.SaveChanges();
return(CreatedAtAction("GetArchivalreq", new { id = archivalreq[0].Request_ID }, archivalreq));
}
public ActionResult Edit(Osoba model)
{
if (model != null && ModelState.IsValid)
{
using (var db = new db_context())
{
Osoba o = db.Osoby.Find(model.ID);
if (o != null)
{
foreach (var p in o.GetType().GetProperties())
{
if (!o.HasPropertyAttribute(p.Name, typeof(KeyAttribute)))
{
p.SetValue(o, model.GetType().GetProperty(p.Name).GetValue(model));
}
}
}
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public void Start()
{
using (var db = new db_context())
{
db.Osoby.Add(new Osoba("Pawel", "Kajka", 25));
db.SaveChanges();
}
}
public ActionResult Add(Nieruchomosc model)
{
using (var db = new db_context())
{
db.Nieruchomosci.Add(model);
db.SaveChanges();
return(RedirectToAction("Index", "Osoby"));
}
}
public ActionResult Remove(MailAdress model)
{
using (var db = new db_context())
{
db.Adresy.Attach(model);
db.Adresy.Remove(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Import(HttpPostedFileBase file)
{
if (file != null)
{
string filename = file.FileName;
string targetpath = Server.MapPath("~/App_Data/");
file.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
string connectionString = "";
if (file.FileName.EndsWith(".xls"))
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (file.FileName.EndsWith(".xlsx"))
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);
}
else
{
return(RedirectToAction("Index"));
}
var adapter = new OleDbDataAdapter("Select * FROM [Arkusz1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
using (var db = new db_context())
{
foreach (DataRow dr in dtable.Rows)
{
Osoba o = new Osoba();
o.Imie = dr[0].ToString();
o.Nazwisko = dr[1].ToString();
o.Wiek = Int32.Parse(dr[2].ToString());
o.Zdjecie = dr[3].ToString();
db.Osoby.Add(o);
}
db.SaveChanges();
}
if ((System.IO.File.Exists(pathToExcelFile)))
{
System.IO.File.Delete(pathToExcelFile);
}
}
return(RedirectToAction("Index"));
}
protected void Application_BeginRequest()
{
using (var db = new db_context())
{
db.HistoriaTable.Add(new Historia()
{
Date = DateTime.Now,
Action = HttpContext.Current.Request.Url.OriginalString
});
db.SaveChanges();
}
}
public void AdicionaTransacao(TransacaoModel transacao)
{
try
{
using (var context = new db_context())
{
context.TransacaoModels.Add(transacao);
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> PostSAPPurgeTable([FromBody] SAPPurgeTable[] sAPPurgeTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
for (int i = 0; i < sAPPurgeTable.Length; i++)
{
_context.SAPPurgeTables.Add(sAPPurgeTable[i]);
}
//await _context.SaveChangesAsync();
_context.SaveChanges();
return(CreatedAtAction("GetSAPPurgeTable", new { id = sAPPurgeTable[0].TableID }, sAPPurgeTable));
}
public ActionResult Add(Osoba model)
{
if (ModelState.IsValid)
{
using (var db = new db_context())
{
db.Osoby.Add(model);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public PartialViewResult Mails(MailAdress model)
{
using (var db = new db_context())
{
if (model != null)
{
try
{
System.Net.Mail.MailAddress m = new System.Net.Mail.MailAddress(model.Adres);
db.Adresy.Add(model);
db.SaveChanges();
}
catch (FormatException)
{
}
}
var maile = db.Adresy.ToList();
return(PartialView(maile));
}
}
public async Task <IActionResult> PoststgSAPPurgeTableList([FromBody] stgSAPPurgeTableList[] stgSAPPurgeTableList)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
for (int i = 0; i < stgSAPPurgeTableList.Length; i++)
{
_context.stgSAPPurgeTableList.Add(stgSAPPurgeTableList[i]);
}
//await _context.SaveChangesAsync();
_context.SaveChanges();
CustomConnection obj = new CustomConnection(); //hard coded the server id
IEnumerable <JobInfo> result = obj.DeployAll();
return(CreatedAtAction("GetstgSAPPurgeTableList", new { id = stgSAPPurgeTableList[0].TableID }, stgSAPPurgeTableList));
}
public ActionResult Remove(Osoba model)
{
using (var db = new db_context())
{
if (model != null)
{
db.Osoby.Attach(model); //podlacz model do bazy na sile
db.Osoby.Remove(model);
var nieruchmosci = db.Nieruchomosci.Where(x => x.IDOsoby == model.ID);
foreach (var n in nieruchmosci)
{
db.Nieruchomosci.Remove(n);
}
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public void repo_test()
{
using (var db = new db_context())
{
db.Database.EnsureCreated();
Assert.IsTrue(db.UserTest == db.Set <UserTest>(), "error1");
var model = new UserTest()
{
Name = Lib.helper.Com.GetUUID()
};
Assert.IsTrue(db.Entry(model).State == EntityState.Detached);
db.Set <UserTest>().Attach(model);
Assert.IsTrue(db.Entry(model).State == EntityState.Added);
model.Name = "fa";
Assert.IsTrue(db.Entry(model).State == EntityState.Added);
db.Set <UserTest>().Remove(model);
Assert.IsTrue(db.Entry(model).State == EntityState.Detached);
db.UserTest.Add(model);
Assert.IsTrue(db.Entry(model).State == EntityState.Added);
db.SaveChanges();
Assert.IsTrue(db.Entry(model).State == EntityState.Unchanged);
model.Name = "xx";
Assert.IsTrue(db.Entry(model).State == EntityState.Modified);
db.SaveChanges();
Assert.IsTrue(db.Entry(model).State == EntityState.Unchanged);
db.UserTest.Remove(model);
Assert.IsTrue(db.Entry(model).State == EntityState.Deleted);
db.SaveChanges();
Assert.IsTrue(db.Entry(model).State == EntityState.Detached);
var new_user = db.Set <UserTest>().AsNoTrackingQueryable().FirstOrDefault(x => x.Name == "xx");
Assert.IsTrue(db.Entry(new_user).State == EntityState.Detached);
new_user = db.Set <UserTest>().AsTracking().FirstOrDefault(x => x.Name == "xx");
Assert.IsTrue(db.Entry(new_user).State == EntityState.Unchanged);
}
var collection = new ServiceCollection();
collection.AddTransient(typeof(IEFRepository <>), typeof(Repo <>));
var provider = collection.BuildServiceProvider().SetAsRootServiceProvider();
using (var user_repo = provider.Resolve_ <IEFRepository <UserTest> >())
{
user_repo.Insert(new UserTest()
{
Name = "xx"
});
user_repo.Insert(new UserTest()
{
Name = "xx"
});
user_repo.Insert(new UserTest()
{
Name = "xx"
});
user_repo.Insert(new UserTest()
{
Name = "xx"
});
var m = user_repo.QueryOne(x => x.Name == "xx");
m.Name += "-dd";
var effected = user_repo.Update(m);
Assert.IsTrue(effected > 0);
}
}
