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;
}
}
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;
}
}
//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;
}
}