public Boolean bookReturnedUpdate(Issue_Detail issue)
{
BookController bookController = new BookController();
int bookID = (int)issue.book_id;
Book_Detail book = bookController.findByBookID(bookID);
int noOfCopies = (int)book.no_of_copies;
book.no_of_copies = ++noOfCopies;
Console.WriteLine("Issue ID" + issue.issue_id);
Boolean status = false;
try
{
using (var db = new ModelDB())
{
bookController.updateBook(book);
var entry = db.Entry(issue);
entry.State = EntityState.Modified;
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Book return update error " + ex.InnerException);
}
return(status);
}
public List <Issue_Detail> loadIssuedBooks()
{
List <Issue_Detail> issues = new List <Issue_Detail>();
try
{
using (var db = new ModelDB())
{
var query = from issue in db.Issue_Detail select new { issue.book_id, issue.due_date };
var list = query.ToList();
foreach (var detail in list)
{
int? num = detail.book_id;
DateTime?datetime = detail.due_date;
Console.WriteLine("number ");
Issue_Detail issueD = new Issue_Detail();
issueD.due_date = datetime;
issueD.book_id = num;
issues.Add(issueD);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Load exception" + ex.InnerException);
}
return(issues);
}
public Boolean checkUserLogin(string username, string password)
{
Console.Write("username " + username + " password " + password);
string encrypted = EncryptionUtil.ToSHA256(password);
Console.Write("encrypted " + encrypted);
User_Detail userdetail = null;
Boolean user_status = false;
try
{
using (var db = new ModelDB())
{
Console.Write("user detail" + db.User_Detail.FirstOrDefault());
userdetail = db.User_Detail.Where(u => u.user_name == username && u.password == encrypted).FirstOrDefault();
Console.Write("user detail " + userdetail);
if (userdetail != null)
{
user_status = true;
}
}
}
catch (InvalidOperationException ex)
{
Console.Write(ex.StackTrace);
}
return(user_status);
}
protected void SpawnShieldVFX(Vector3 shotBackwards, Vector3 hitpos, ShipEntity target)
{
if (target.GetVital(VitalType.ShieldPoints).current > 0f)
{
Object.Destroy(Object.Instantiate(ModelDB.GetShieldDeflectionVFX(), hitpos, Quaternion.LookRotation(shotBackwards), null), 3f);
}
}
public ActionResult Ayarlar(FormCollection form)
{
string kullaniciadi = form["kullaniciadi"].ToString();
string sifre = form["sifre"].ToString();
string sifre2 = form["sifre2"].ToString();
if (string.Equals(sifre, sifre2))
{
using (ModelDB db = new ModelDB())
{
AdminLogin al = db.AdminLogin.SingleOrDefault();
al.kullaniciadi = kullaniciadi;
al.sifre = sifre;
int sonuc = db.SaveChanges();
if (sonuc > 0)
{
TempData["Result"] = "Kaydedildi";
TempData["Status"] = "success";
}
}
}
else
{
TempData["Result"] = "Şifreler birbiri ile aynı olmak zorundadır.";
TempData["Status"] = "danger";
}
using (ModelDB db = new ModelDB())
{
AllTables2 at = new AllTables2();
at.admin = db.AdminLogin.SingleOrDefault();
return(View(at));
}
}
public List <string> loadText()
{
List <string> books = null;
try
{
using (var db = new ModelDB())
{
var query = from bk in db.Book_Detail select new { bk.title };
books = (from Book_Detail b in books
select b.ToString()).ToList();
// books = query.ToList<string>();
}
}
catch (Exception ex)
{
Console.WriteLine("search exception book " + ex.InnerException);
}
foreach (var title in books)
{
Console.Write("book titles " + title);
}
return(books);
}
void Start()
{
//initialize settings
Settings.Load();
//load misc stuff
NameGenerator.Initialize();
ModelDB.Initialize();
EventDB.Initialize();
PaletteDB.Initialize();
//load saves first
SaveManager.Initialize();
_planet.GetComponent <PlanetEntity>().Initialize(
PaletteDB.Get(_planetType).Instantiate(),
Random.Range(0.2f, .9f),
true);
//hide stuff
_panels = new GameObject[] { _setupPanel, _savesPanel, _instructionsPanel, _optionsPanel, _creditsPanel };
for (int i = 0; i < _panels.Length; i++)
{
_panels[i].SetActive(false);
}
InitalizeMediaIcons();
InitializeMenues();
//start main ost
AudioManager.getInstance.PlayOST(OSTTheme.MainMenu);
}
public List <Book_Detail> searchAny(string searchText)
{
Boolean status = false;
List <Book_Detail> books = null;
try
{
using (var db = new ModelDB())
{
return(books = (from book in db.Book_Detail
let type = book.GetType()
let typesearch = searchText.GetType()
let properties = type.GetProperties()
where (from pro in properties
where pro.PropertyType == typesearch
select pro.GetValue(book, null)
into value
select value as string).Any(val => val != null && val == searchText)
select book).ToList());
}
}
catch (Exception ex)
{
Console.WriteLine("search exception book " + ex.InnerException);
}
return(books);
}
public bool SnimiPodatke()
{
ProveraOpseg.Service1 service = new ProveraOpseg.Service1();
bool uspeh = false;
if (this.DaLiSuPodaciIspravni())
{
if (service.ProveriOpseg(Int32.Parse(pMotor)))
{
ModelDB objModelDB = new ModelDB(pStringKonekcije);
Model objNoviModel = new Model();
// prerada ulaznih podataka
objNoviModel.IDModela = pIDModela;
objNoviModel.NazivModela = pNazivModela;
objNoviModel.Motor = pMotor;
objNoviModel.Godina = pGodina;
objNoviModel.SifraBoje = this.DajSifruBoje(this.pNazivBoje);
objNoviModel.SifraProizvodjaca = this.DajSifruProizvodjaca(this.pNazivProizvodjaca);
// snimanje putem DB klase
uspeh = objModelDB.SnimiNoviModel(objNoviModel);
}
}
return(uspeh);
}
public Boolean addUserDetail(User_Detail userDetail)
{
Boolean status = false;
try
{
using (var db = new ModelDB())
{
string passencripted = EncryptionUtil.ToSHA256(userDetail.password);
Console.WriteLine(passencripted);
userDetail.password = passencripted;
db.User_Detail.Add(userDetail);
db.SaveChanges();
status = true;
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Console.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
}
return(status);
}
public int SaveModelDetail(ModelDB objDB, SqlTransaction objTrans)
{
int MappingID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "Usp_SaveModelMapping";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Material", objDB.Material);
objCmd.Parameters.AddWithValue("@GroupID", objDB.GroupID);
objCmd.Parameters.AddWithValue("@ModelSpecialID", objDB.ModelSpecialID);
objCmd.Parameters.AddWithValue("@ClutchTypeID", objDB.ClutchTypeID);
objCmd.Parameters.AddWithValue("@ModelCategoryID", objDB.ModelCategoryID);
objCmd.Parameters.AddWithValue("@Description", objDB.Description);
objCmd.Parameters.AddWithValue("@MappingID", SqlDbType.Int);
objCmd.Parameters["@MappingID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
MappingID = Convert.ToInt32(objCmd.Parameters["@MappingID"].Value);
return MappingID;
}
catch (Exception ex)
{
throw ex;
}
}
public async Task SendToDBAsync()
{
context = new ModelDB();
switch (component.GetType().Name)
{
case "Processors":
context.ProcessorsTable.Add((Processors)component);
break;
case "GraphicCards":
context.GraphicCardsTable.Add((GraphicCards)component);
break;
case "MotherBoards":
context.MotherBoardsTable.Add((MotherBoards)component);
break;
case "Enclosures":
context.EnclosuresTable.Add((Enclosures)component);
break;
case "RAM":
context.RAMTable.Add((RAM)component);
break;
case "PowerSupplies":
context.PowerSuppliesTable.Add((PowerSupplies)component);
break;
case "HardDisks":
context.HardDisksTable.Add((HardDisks)component);
break;
}
await context.SaveChangesAsync();
}
public int CheckMaterial(ModelDB objDB, SqlTransaction objTrans)
{
int flag = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "Usp_CheckMaterial";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Material", objDB.Material);
objCmd.Parameters.AddWithValue("@flag", SqlDbType.Int);
objCmd.Parameters["@flag"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
flag = Convert.ToInt32(objCmd.Parameters["@flag"].Value);
return flag;
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ModelDB> GetData()
{
List <ModelDB> entries = new List <ModelDB>();
using (SqliteConnection db =
new SqliteConnection("Filename=sqliteSample.db"))
{
db.Open();
SqliteCommand selectCommand = new SqliteCommand
("SELECT * from MyTable", db);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
ModelDB modelDB = new ModelDB();
modelDB.IdDB = query.GetInt32(0);
modelDB.ContentDB = query.GetString(1);
entries.Add(modelDB);
}
db.Close();
}
return(entries);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="view"></param>
public Presenter(IView view)
{
model = new ModelDB();
this.view = view;
view.ListViewDep.ItemsSource = model.DbDepartment;
view.ListViewEmp.ItemsSource = model.DbEmployee;
}
public bool DaLiSuPodaciIspravni()
{
// BAZICNA PROVERA ISPRAVNOSTI PODATAKA
// osnovna validacija podataka
bool IspravniPodaci = true;
//- DA LI JE SVE POPUNJENO
if ((this.pIDModela.Equals("")) || (this.pMotor.Equals("")) || (this.pNazivModela.Equals("")) || (this.pNazivBoje.Equals("")) || (this.pNazivProizvodjaca == null))
{
IspravniPodaci = false;
}
else
{
//- DA LI ODGOVARA DUZINA UNETE VREDNOSTI
if (this.pIDModela.Length > 10)
{
IspravniPodaci = false;
}
else
{
ModelDB objModelDB = new ModelDB(this.pStringKonekcije);
DataSet dsPodaciModela = objModelDB.DajSveModelePoID(this.pIDModela);
bool NePostojiSifraUBazi = (dsPodaciModela.Tables[0].Rows.Count == 0);
IspravniPodaci = NePostojiSifraUBazi;
}
}
return(IspravniPodaci);
}
public List <Member_Detail> searchMember(string constraint, string term, DateTime dob)
{
List <Member_Detail> memberDetails = null;
try
{
using (var db = new ModelDB())
{
if (constraint == "first_name")
{
memberDetails = db.Member_Detail
.Where(b => b.first_name == term)
.ToList();
}
if (constraint == "last_name")
{
memberDetails = db.Member_Detail
.Where(b => b.last_name == term)
.ToList();
}
if (constraint == "dob")
{
memberDetails = db.Member_Detail
.Where(b => b.dob == dob)
.ToList();
}
if (constraint == "add_number")
{
memberDetails = db.Member_Detail
.Where(b => b.admission_number == term)
.ToList();
}
if (constraint == "email")
{
memberDetails = db.Member_Detail
.Where(b => b.email == term)
.ToList();
}
if (constraint == "address")
{
memberDetails = db.Member_Detail
.Where(b => b.address == term)
.ToList();
}
if (constraint == "phone_number")
{
memberDetails = db.Member_Detail
.Where(b => b.phone_number == term)
.ToList();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
}
return(memberDetails);
}
public ActionResult GetData()
{
using (ModelDB db = new ModelDB())
{
List <ASPMVCEmployee> employeeList = db.ASPMVCEmployees.ToList <ASPMVCEmployee>();
return(Json(new { data = employeeList }, JsonRequestBehavior.AllowGet));
}
}
private void id_tovar_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (ModelDB db = new ModelDB())
{
string tovarName = id_tovar.SelectedItem.ToString();
decimal price = db.Tovar.Where(p => p.name.Equals(tovarName)).FirstOrDefault().price;
Price.Text = price.ToString();
}
}
public ActionResult Blog(int id = 1)
{
ModelDB model = new ModelDB();
model.blogList = db.Blogs.ToList();
model.Index = id;
return(View(model));
}
public ActionResult News(int id = 1)
{
ModelDB model = new ModelDB();
model.news = db.Blogs.Where(w => w.id == id).FirstOrDefault();
model.Index = id;
model.blogList = db.Blogs.ToList();
return(View(model));
}
public ActionResult Index()
{
var model = new List <Myclass>();
//Random c1= new Random();
ModelDB DB = new ModelDB();
//for (var i = 1; i <= 200; i++)
//{
// var c2 = c1.Next(1, 3);
// string type = "";
// if (c2 == 1) { type = "支出"; } else { type = "收入"; };
// var a = new Random(Guid.NewGuid().GetHashCode());
// var b = a.Next();//錢的亂數
// Random gen = new Random(Guid.NewGuid().GetHashCode());
// DateTime time;//日期亂數
// DateTime start = new DateTime(2016, 1, 1);
// int range = (DateTime.Today - start).Days;
// time = start.AddDays(gen.Next(range));
// DateTime c = DateTime.Now;
// model.Add(new Myclass
// {
// num = i,
// category = type,
// money = b,
// date = time
// });
foreach (var item in DB.AccountBook)
{
string cate = string.Empty;
if (item.Categoryyy == 0)
{
cate = "支出";
}
else
{
cate = "收入";
}
model.Add(new Myclass
{
num = item.Id,
category = cate,
money = item.Amounttt,
date = item.Dateee,
remark = item.Remarkkk
});
}
return(View(model));
}
public Planet(string name, Vector3 location, Random random, PlanetType planetType) : base(name, location, random)
{
base.type = PointOfInterestType.Planet;
base.model = ModelDB.GetPlanet(planetType, random);
_waterLevel = random.Next(0, 100) * .01f;
_planetType = planetType;
_palette = PaletteDB.Get(_planetType).Instantiate();
}
public ActionResult Delete(int id)
{
using (ModelDB db = new ModelDB())
{
ASPMVCEmployee employee = db.ASPMVCEmployees.Where(x => x.EmployeeID == id).FirstOrDefault <ASPMVCEmployee>();
db.ASPMVCEmployees.Remove(employee);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public Officer()
{
_gender = (Gender)UnityEngine.Random.Range(0, Enum.GetNames(typeof(Gender)).Length);
_rank = Rank.Ensign;
_name = NameGenerator.GetOfficerName(_gender);
_homeplanet = NameGenerator.GetPOIName(PointOfInterestType.Planet);
_portrait = ModelDB.GetPortrait();
}
public ActionResult PrintPartialViewToPdf(int id)
{
using (ModelDB db = new ModelDB())
{
Request request = db.Requests.Include(e => e.Educations).Include(c => c.Countries).Include(cr => cr.CountryResidence).Include(p => p.Provinces).Include(m => m.Moneys).FirstOrDefault(c => c.ID == id);
var report = new PartialViewAsPdf("~/Views/Shared/DetailsPDF.cshtml", request);
return(report);
}
}
public PesqClientes()
{
InitializeComponent();
modelDB = new ModelDB();
clientesDAO = new ClientesDAO();
cidadesDAO = new CidadesDAO();
estadosDAO = new EstadosDAO();
observacoesDAO = new ObservacoesDAO();
check = false;
}
public PesqTrab()
{
InitializeComponent();
modelDB = new ModelDB();
trabalhadoresDAO = new TrabalhadoresDAO();
cidadesDAO = new CidadesDAO();
estadosDAO = new EstadosDAO();
observacoesDAO = new ObservacoesDAO();
check = false;
}
public PesqForn()
{
InitializeComponent();
modelDB = new ModelDB();
fornecedoresDAO = new FornecedoresDAO();
cidadesDAO = new CidadesDAO();
estadosDAO = new EstadosDAO();
observacoesDAO = new ObservacoesDAO();
check = false;
}
public string Post([FromBody] dynamic value)
{
string json = value.ToString();
Hero newHero = JsonConvert.DeserializeObject <Hero>(json);
ModelDB.AddHero(new Hero(newHero.name));
Console.WriteLine(newHero.name + " " + newHero.id);
Console.WriteLine($"heroes size {ModelDB.Heroes.Count} {Hero.HeroList.Count}");
ModelDB.LogHeroes();
return("Hero Created");
}
public ActionResult BackupDatabase()
{
using (var db = new ModelDB())
{
var cmd = String.Format
("BACKUP DATABASE ntcservice TO DISK='D:\\юніті срака\\MSSQL12.SQLEXPRESS\\MSSQL\\Backup\\" +
"ntcservice.bak' WITH FORMAT, MEDIANAME='Full Db backup', MEDIADESCRIPTION='Full Database Backup';");
db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd);
}
return(View());
}
public ActionResult RestoreDatabase()
{
using (var db = new ModelDB())
{
//var cmd = String.Format
// ("USE master restore DATABASE ntcservice from DISK='D:\\юніті срака\\MSSQL12.SQLEXPRESS\\MSSQL\\Backup\\" +
// "ntcservice.bak' WITH REPLACE;");
//db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd);
}
return(View());
}
public int SaveModelDetail(ModelUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int Flag = 0;
bool flagTransation = true;
ModelDB objDB = new ModelDB();
objDB.Material = objUI.Material;
objDB.GroupID = objUI.GroupID;
objDB.ModelCategoryID = objUI.ModelCategoryID;
objDB.ModelSpecialID = objUI.ModelSpecialID;
objDB.ClutchTypeID = objUI.ClutchTypeID;
objDB.Description = objUI.Description;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
ModelManager objManager = new ModelManager();
Flag = objManager.SaveModelDetail(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return Flag;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public int CheckMaterial(ModelUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int Flag = 0;
bool flagTransation = true;
ModelDB objDB = new ModelDB();
objDB.Material = objUI.Material;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
ModelManager objManager = new ModelManager();
Flag = objManager.CheckMaterial(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return Flag;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public int AddProduct(ModelDB objDB, SqlTransaction objTrans)
{
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
int Status = 0;
try
{
if (objDB.StatusID == 0)
{
objCmd.CommandText = "usp_AddProduct";
}
else
{
objCmd.CommandText = "usp_UpdateModel";
}
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Code", objDB.Code);
objCmd.Parameters.AddWithValue("@GroupID", objDB.GroupID);
objCmd.Parameters.AddWithValue("@Description", objDB.Description);
objCmd.Parameters.AddWithValue("@IsActive", objDB.IsActive);
objCmd.Parameters.AddWithValue("@InReport", objDB.InReport);
objCmd.Parameters.AddWithValue("@IsGroup", objDB.IsGroup);
objCmd.Parameters.AddWithValue("@EffectDate", objDB.EffectDate);
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
}
catch (Exception ex)
{
throw ex;
}
return Status;
}
public int SaveModel(ModelDB objDB,int TempID ,SqlTransaction objTrans)
{
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
int Status = 0;
try
{
objCmd.CommandText = "usp_UpdateModelException";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@ProductCode", Convert.ToInt32(objDB.Code));
objCmd.Parameters.AddWithValue("@ModelGroupName", objDB.ModelCode);
objCmd.Parameters.AddWithValue("@GroupID", objDB.GroupID);
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
}
catch (Exception ex)
{
throw ex;
}
return Status;
}
private void SaveReadNum(ModelDB.Blogs blogobj, string md5)
{
LogSave.TrackLogSave(GetUserDistinguish(Request, false), "ReadBlogLog");
var isup = true;
BLL.BlogsBLL blogbll = new BLL.BlogsBLL();
var blogtemp = blogbll.GetList(t => t.Id == blogobj.Id, isAsNoTracking: false).FirstOrDefault();
if (blogtemp.BlogReadNum == null)
blogtemp.BlogReadNum = 1;
else if (!IsRead(blogtemp, md5))
blogtemp.BlogReadNum++;
else
isup = false;
if (isup)
BLL.BlogCommentSetBLL.StaticSave();
}
