public async Task getPosition() { using (var client = new HttpClient()) { client.DefaultRequestHeaders.Add("X-SFAPI-UserName", sunfishConfig.username); client.DefaultRequestHeaders.Add("X-SFAPI-AppName", sunfishConfig.appname); client.DefaultRequestHeaders.Add("X-SFAPI-RSAKey", sunfishConfig.RSAkey); client.DefaultRequestHeaders.Add("X-SFAPI-Account", sunfishConfig.account); // Make your request... try { HttpResponseMessage message = client.GetAsync(sunfishConfig.Uri + "index.cfm?endpoint=/biensi_SFFULL_EO_getmasterstoreposition").Result; if (message.IsSuccessStatusCode) { var serializer = new DataContractJsonSerializer(typeof(SunfishPosition)); var result = message.Content.ReadAsStringAsync().Result; byte[] byteArray = Encoding.UTF8.GetBytes(result); MemoryStream stream = new MemoryStream(byteArray); SunfishPosition resultData = serializer.ReadObject(stream) as SunfishPosition; for (int i = 0; i < resultData.RESULT.Count; i++) { try { bool isPossitionex = _context.EmployeePossition.Any(c => c.PossitionId == resultData.RESULT[i].POSITION_CODE); if (isPossitionex == false) { EmployeePossition employee = new EmployeePossition(); employee.PossitionId = resultData.RESULT[i].POSITION_CODE; employee.Name = resultData.RESULT[i].POSITION_NAME; _context.EmployeePossition.Add(employee); _context.SaveChanges(); } else { EmployeePossition employee = _context.EmployeePossition.Where(x => x.PossitionId == resultData.RESULT[i].POSITION_CODE).First(); employee.PossitionId = resultData.RESULT[i].POSITION_CODE; employee.Name = resultData.RESULT[i].POSITION_NAME; _context.EmployeePossition.Update(employee); _context.SaveChanges(); } } catch { } } } else { String data = message.Headers.ToString(); } } catch (Exception ex) { } } }
//private List<BankMaster> masterBanks(int storeID) //{ // List<BankMaster> masterBankList = new List<BankMaster>(); // try // { // List<StorePaymentMethod> bankDb = _context.StorePaymentMethod.Where(c => c.StoreId == storeID).ToList(); // foreach (StorePaymentMethod b in bankDb) // { // Bank bankMaster = _context.Bank.Where(c => c.BankId == b.BankCode).First(); // BankMaster bank = new BankMaster(); // bank.bankId = bankMaster.BankId; // bank.bankName = bankMaster.Name; // masterBankList.Add(bank); // } // } // catch // { // } // return masterBankList; //} private List<EmployeeMaster> masterEmployeepost(int storeID) { List<EmployeeMaster> masterEmployeeList = new List<EmployeeMaster>(); try { List<Employee> dbEmployee = _context.Employee.Where(c => c.StoreId == storeID).ToList(); foreach (Employee b in dbEmployee) { EmployeePossition employeePossition = _context.EmployeePossition.Where(c => c.Id == b.PossitionId).First(); Store store = _context.Store.Where(c => c.Id == b.StoreId).First(); EmployeeMaster employee = new EmployeeMaster { employeeId = b.EmployeeCode, id = b.Id, name = b.EmployeeName, storeId = store.Id, storeCode = store.Code, storeName = store.Name, possition = new Possition { id = employeePossition.Id, possitionName = employeePossition.Name, possitionId = employeePossition.PossitionId } }; masterEmployeeList.Add(employee); } } catch { } return masterEmployeeList; }
//private List<EmployeeMaster> masterEmployee(int storeID) //{ // List<EmployeeMaster> masterEmployeeList = new List<EmployeeMaster>(); // try // { // List<Employee> dbEmployee = _context.Employee.Where(c => c.StoreId == storeID).ToList(); // foreach (Employee b in dbEmployee) // { // EmployeePossition employeePossition = _context.EmployeePossition.Where(c => c.Id == b.PossitionId).First(); // EmployeeMaster employee = new EmployeeMaster // { // employeeId = b.EmployeeCode, // id = b.Id, // name = b.EmployeeName, // possition = new Possition // { // id = employeePossition.Id, // possitionName = employeePossition.Name, // possitionId = employeePossition.PossitionId // } // }; // try // { // employee.passwordHash = _context.UserLogin.Where(x => x.UserId == b.Id).FirstOrDefault().PasswordHash; // employee.passwordSalt = _context.UserLogin.Where(x => x.UserId == b.Id).FirstOrDefault().PasswordSalt; // employee.passwordaja = _context.UserLogin.Where(x => x.UserId == b.Id).FirstOrDefault().OldPassword; // } // catch // { // employee.passwordHash = null; // employee.passwordSalt = null; // employee.passwordaja = ""; // } // masterEmployeeList.Add(employee); // } // } // catch // { // } // return masterEmployeeList; //} private List<EmployeeMaster> masterEmployee(int storeID) { List<EmployeeMaster> masterEmployeeList = new List<EmployeeMaster>(); try { string city = _context.Store.Where(x => x.Id == storeID).First().City; List<Store> dbStores = _context.Store.ToList(); // List<Store> dbStores = _context.Store.Where(x => x.City == city).ToList(); for (int i = 0; i < dbStores.Count; i++) { List<Employee> dbEmployee = _context.Employee.Where(c => c.StoreId == dbStores[i].Id && c.Status == true).ToList(); foreach (Employee b in dbEmployee) { EmployeePossition employeePossition = _context.EmployeePossition.Where(c => c.Id == b.PossitionId).First(); EmployeeMaster employee = new EmployeeMaster { employeeId = b.EmployeeCode, storeId = dbStores[i].Id, storeCode = dbStores[i].Code, storeName = dbStores[i].Name, id = b.Id, name = b.EmployeeName, possition = new Possition { id = employeePossition.Id, possitionName = employeePossition.Name, possitionId = employeePossition.PossitionId } }; if (b.StoreId == storeID) { try { employee.passwordHash = _context.UserLogin.Where(x => x.UserId == b.Id).FirstOrDefault().PasswordHash; employee.passwordSalt = _context.UserLogin.Where(x => x.UserId == b.Id).FirstOrDefault().PasswordSalt; employee.passwordaja = _context.UserLogin.Where(x => x.UserId == b.Id).FirstOrDefault().OldPassword; } catch { employee.passwordHash = null; employee.passwordSalt = null; employee.passwordaja = ""; } } else { employee.passwordHash = null; employee.passwordSalt = null; employee.passwordaja = "GABOLEHLOGINASDASDASDA"; } masterEmployeeList.Add(employee); } } } catch { } return masterEmployeeList; }