public void postWork(Models.WorkListModel value) { var db = new MyDBModels.DB(); MyDBModels.WorkList workList = new MyDBModels.WorkList(); workList.DriverId = value.DriverId; workList.BusId = value.BusId; workList.SecondNameDispatcher = value.SecondNameDispatcher; workList.DateAction = value.DateAction; db.workList.Add(workList); MyDBModels.Bus busModel = db.bus.Where(b => b.BusId == value.BusId).FirstOrDefault(); string title = "Bus: " + busModel.BusNumber.ToString() + "/" + busModel.Model; string info = "Date: " + value.DateAction + "\nDispatcher: " + value.SecondNameDispatcher; string number = EncryptClass.DESEncrypt(db.driver.Where(b => b.DriverId == value.DriverId).FirstOrDefault().DriverNumber.ToString()); MyDBModels.Account accountModel = db.account.Where(b => b.NumberWorker == number).FirstOrDefault(); string token = accountModel.Token; sendRequestToFirebase("\"" + title + "\"", "\"" + info + "\"", "\"" + token + "\""); db.SaveChanges(); }
public List <string> postSignIn(Models.AccountModel accountModel) { var db = new MyDBModels.DB(); string cryptName = EncryptClass.DESEncrypt(accountModel.Secondname); string cryptPassword = EncryptClass.MD5Hash(accountModel.Password); List <string> result = new List <string>(); result.Clear(); MyDBModels.Account accountFinal = db.account.Where(b => b.LoginId == cryptName && b.PasswordWorker == cryptPassword).FirstOrDefault(); if (accountFinal != null) { result.Add(EncryptClass.DESDecrypt(accountFinal.LoginId)); result.Add(EncryptClass.DESDecrypt(accountFinal.RoleWorker)); result.Add(EncryptClass.DESDecrypt(accountFinal.NumberWorker)); int number = int.Parse(EncryptClass.DESDecrypt(accountFinal.NumberWorker)); if (number > 100) { MyDBModels.Dispatcher dispatcher = db.dispatcher.Where(b => b.DispatcherNumber == number).FirstOrDefault(); result.Add(dispatcher.Image); } else { MyDBModels.Driver driver = db.driver.Where(b => b.DriverNumber == number).FirstOrDefault(); result.Add(driver.Image); } } else { result.Add("NOT OK"); } return(result); }
public void postDispatcher(Models.DispatcherAccountModel postDispatcher) { var db = new MyDBModels.DB(); MyDBModels.Account account = new MyDBModels.Account(); account.LoginId = postDispatcher.AccountModel.Secondname; account.PasswordWorker = postDispatcher.AccountModel.Password; account.RoleWorker = postDispatcher.AccountModel.Role; account.NumberWorker = postDispatcher.AccountModel.Number; db.account.Add(account); db.SaveChanges(); }
public int postDriver(Models.DriverAccountModel postDriver) { var db = new MyDBModels.DB(); MyDBModels.Account account = new MyDBModels.Account(); MyDBModels.Driver driver = new MyDBModels.Driver(); List <MyDBModels.Driver> listData = db.driver.ToList(); List <int> num = new List <int>(); int number; if (num.Count > 0) { for (int i = 0; i < listData.Count; i++) { num.Add(listData[i].DriverNumber); } number = EncryptClass.GenerateUnikalNumber(num, 1, 100); } else { Random rund = new Random(); number = rund.Next(1, 100); } account.LoginId = postDriver.AccountModel.Secondname; account.PasswordWorker = postDriver.AccountModel.Password; account.RoleWorker = postDriver.AccountModel.Role; account.NumberWorker = EncryptClass.DESEncrypt(number.ToString()); account.Token = postDriver.AccountModel.Token; db.account.Add(account); postDriver.DriverModel.DriverNumber = number; DriverModel value = postDriver.DriverModel; driver.Secondname = value.Secondname; driver.Qualification = value.Qualification; driver.Experience = value.Experience; driver.DriverNumber = value.DriverNumber; driver.Salary = value.Salary; driver.Image = null; db.driver.Add(driver); db.SaveChanges(); return(number); }
public int postDispatcher(Models.DispatcherAccountModel postDispatcher) { var db = new MyDBModels.DB(); MyDBModels.Account account = new MyDBModels.Account(); MyDBModels.Dispatcher dispatcher = new MyDBModels.Dispatcher(); List <MyDBModels.Dispatcher> listData = db.dispatcher.ToList(); List <int> num = new List <int>(); int number; if (num.Count > 0) { for (int i = 0; i < listData.Count; i++) { num.Add(listData[i].DispatcherNumber); } number = EncryptClass.GenerateUnikalNumber(num, 101, 200); } else { Random rund = new Random(); number = rund.Next(101, 200); } account.LoginId = postDispatcher.AccountModel.Secondname; account.PasswordWorker = postDispatcher.AccountModel.Password; account.RoleWorker = postDispatcher.AccountModel.Role; account.NumberWorker = EncryptClass.DESEncrypt(number.ToString()); account.Token = postDispatcher.AccountModel.Token; db.account.Add(account); dispatcher.DispatcherNumber = number; dispatcher.Secondname = EncryptClass.DESDecrypt(postDispatcher.AccountModel.Secondname); dispatcher.Image = null; db.dispatcher.Add(dispatcher); db.SaveChanges(); return(number); }
public List <string> postSignIn(Models.AccountModel accountModel) { var db = new MyDBModels.DB(); string cryptName = EncryptClass.DESEncrypt(accountModel.Secondname); string cryptPassword = EncryptClass.MD5Hash(accountModel.Password); List <string> result = new List <string>(); MyDBModels.Account accountFinal = db.account.Where(b => b.LoginId == cryptName && b.PasswordWorker == cryptPassword).FirstOrDefault(); if (accountFinal != null) { result.Add(EncryptClass.DESDecrypt(accountFinal.RoleWorker)); result.Add(EncryptClass.DESDecrypt(accountFinal.NumberWorker)); } else { result.Add("NOT OK"); } return(result); }