public int validateOTP(UserAccounts ua)
{
UserAccounts uad = new UserAccounts();
int result = 0;
using (db = new iGratifyEntities()) {
var data = db.spg_ValidateOTP1(ua.UserID, ua.Email, ua.MobileNo);
foreach (var items in data)
{
result = Convert.ToInt32(items.OTP);
}
return(result);
}
}
public List <GetDDL> GetEducationList()
{
List <GetDDL> educationList = new List <GetDDL>();
using (db = new iGratifyEntities())
{
var data = db.MasterDatas.Where(a => a.Id_Type == "Industry");
foreach (var items in data)
{
GetDDL user = new GetDDL();
user.code = items.Code;
user.description = items.Description;
educationList.Add(user);
}
}
return(educationList);
}
public void saveUserDetails(UserAccounts item)
{
using (db = new iGratifyEntities())
{
UserDetail tab = new UserDetail();
tab.UserId = item.UserID;
tab.Password = item.password;
tab.FirstName = item.FullName;
tab.Email = item.Email;
tab.Gender = item.Gender;
tab.MobileNo = item.MobileNo;
tab.Profession = item.Profession;
tab.Domain = item.Domain;
tab.Industry = item.Industry;
tab.Country = item.Country;
db.UserDetails.Add(tab);
db.SaveChanges();
}
}
public List <UserAccounts> checkUser(UserAccounts uad)
{
List <UserAccounts> uaList = new List <UserAccounts>();
using (db = new iGratifyEntities())
{
var data = db.Spc_CheckUser(uad.UserID, uad.password);
foreach (var items in data)
{
UserAccounts ua = new UserAccounts();
ua.UserID = items.UserId;
ua.FullName = items.FirstName;
ua.Email = items.Email;
ua.MobileNo = items.MobileNo;
ua.Gender = items.Gender;
uaList.Add(ua);
}
}
return(uaList);
}
public int saveOTP(UserAccounts ua)
{
int result = 0;
using (db = new iGratifyEntities())
{
try
{
OTPMaster otp = new OTPMaster();
otp.UserId = ua.UserID;
otp.Email = ua.Email;
otp.Mobile = ua.MobileNo;
otp.OTP = ua.OTP;
db.OTPMasters.Add(otp);
db.SaveChanges();
return(result = 1);
}
catch (Exception e)
{
return(result = -1);
}
}
}
