public static bool ChangePassword(string username, string newPassword) { try { User existingUser = new User(); using (var context = new CardIssuanceKIOSKEntities()) { existingUser = context.Users .Where(t => t.UserName == username) .FirstOrDefault(); } if (existingUser != null) { existingUser.Password = newPassword; using (var context = new CardIssuanceKIOSKEntities()) { context.Entry(existingUser).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static PANDetail RetrievePanDetailByAccountNumber(string accountNumber) { try { using (var context = new CardIssuanceKIOSKEntities()) { var panDetails = context.PANDetails .Where(f => f.account_number == accountNumber); return panDetails != null ? panDetails.FirstOrDefault() : null; } } catch (Exception ex) { throw ex; } }
public static bool PanExists(PANDetail panDetail) { try { var existingPanDetail = new PANDetail(); using (var context = new CardIssuanceKIOSKEntities()) { existingPanDetail = context.PANDetails .Where(t => t.pan.Equals(panDetail.pan) || t.account_number.Equals(panDetail.account_number)) .FirstOrDefault(); } if (existingPanDetail == null) return false; else return true; } catch (Exception ex) { throw ex; } }
public static PANDetail RetrievePanDetailByPan(string pan) { try { using (var context = new CardIssuanceKIOSKEntities()) { var panDetails = context.PANDetails .Where(f => f.pan == pan); return panDetails != null ? panDetails.FirstOrDefault() : null; } } catch (Exception ex) { throw ex; } }
public static bool UserExists(User user) { try { var existingUser = new User(); using (var context = new CardIssuanceKIOSKEntities()) { existingUser = context.Users .Where(t => t.UserName.Equals(user.UserName)) .FirstOrDefault(); } if (existingUser == null) return false; else return true; } catch (Exception ex) { throw ex; } }
public static bool UpdatePan(string pan) { try { PANDetail existingPanDetail = new PANDetail(); using (var context = new CardIssuanceKIOSKEntities()) { existingPanDetail = context.PANDetails .Where(t => t.pan == pan) .FirstOrDefault(); } if (existingPanDetail != null) { existingPanDetail.Status = 1; using (var context = new CardIssuanceKIOSKEntities()) { context.Entry(existingPanDetail).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
//Save Card Account Request public static bool SaveCar(CardAccountRequest car) { try { using (var context = new CardIssuanceKIOSKEntities()) { context.CardAccountRequests.Add(car); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
//User Methods public static bool Save(User user) { try { using (var context = new CardIssuanceKIOSKEntities()) { context.Users.Add(user); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
//Pan Methods public static bool Save(PANDetail panDetail) { try { using (var context = new CardIssuanceKIOSKEntities()) { context.PANDetails.Add(panDetail); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static User RetrieveUserByUsername(string username) { try { using (var context = new CardIssuanceKIOSKEntities()) { var existingUser = context.Users.Where(t => t.UserName.Equals(username)); return existingUser != null ? existingUser.FirstOrDefault() : null; } } catch (Exception ex) { throw ex; } }
public static List<PANDetail> RetrieveUnUsedPanDetails() { try { using (var context = new CardIssuanceKIOSKEntities()) { var panDetails = context.PANDetails .Where(x => x.Status == 0) .ToList(); return panDetails; } } catch (Exception ex) { throw ex; } }