public ActionResult Register(tbl_User user)
{
user.EmailVerification = false;
var isExists = IsEmailExists(user.Email);
if (isExists)
{
ModelState.AddModelError("EmailExists", "Email Already Exists");
return(View());
}
user.ActivationCode = Guid.NewGuid();
user.Password = EncryptPassword.Encrypt(user.Password);
db.tbl_User.Add(user);
db.SaveChanges();
SendEmailToUser(user.Email, user.ActivationCode.ToString());
var Message = "Registration Completed. Please Check your Mail : " + user.Email;
ViewBag.Message = Message;
return(View("RegistrationConfirm"));
}
public async Task <Owner> InsertOwner(OwnerRequest ownerRequest)
{
Owner owner = JsonConvert.DeserializeObject <Owner>(ownerRequest.Owner, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
owner.Passord = EncryptPassword.Encrypt(owner.Passord);
if (ownerRequest.PhotoFile != null)
{
using MemoryStream stream = new();
ownerRequest.PhotoFile.CopyTo(stream);
byte[] bytes = stream.ToArray();
owner.Photo = Convert.ToBase64String(bytes);
}
else
{
owner.Photo = string.Empty;
}
owner = await this.Repositoty.InsertOwner(owner);
owner.Passord = string.Empty;
return(owner);
}
public void Login(string username, string password)
{
var req = new LoginWithPlayFabRequest
{
Username = username,
Password = EncryptPassword.Encrypt(password)
};
PlayFabClientAPI.LoginWithPlayFab(request: req, resultCallback: OnLoginRequestSuccess, errorCallback: OnLoginRequestFailure);
}
public void Register(string username, string email, string password)
{
var req = new RegisterPlayFabUserRequest
{
Username = username,
Email = email,
Password = EncryptPassword.Encrypt(password)
};
PlayFabClientAPI.RegisterPlayFabUser(request: req, resultCallback: OnRegisterRequestSuccess, errorCallback: OnRegisterRequestFailure);
}
public ActionResult Login(tbl_User user)
{
var EncryptpassWord = EncryptPassword.Encrypt(user.Password);
var obj = db.tbl_User.Where(a => a.Email.Equals(user.Email) && a.Password.Equals(EncryptpassWord) && a.EmailVerification == true).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.id.ToString();
Session["UserName"] = obj.FirstName.ToString();
return(RedirectToAction("ProductList", "Product"));
}
return(View(user));
}
private UserDTO FillDTO(object parameter = null)
{
var pass = parameter as PasswordBox;
return(new UserDTO
{
Id = Id,
FirstName = FirstName,
LastName = LastName,
Password = EncryptPassword.Encrypt(pass.Password),
Username = UserName,
Address = Address,
Email = Email,
PhoneNumber = PhoneNumber,
DateOfBirth = DateOfBirth,
AnnualWage = AnnualWage,
});
}
public string update_password([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
try
{
string pwd = parameter["password"].ToString();
pwd = pwd.Trim();
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(pwd.ToString().Trim());
string member_code = parameter["member_code"].ToString();
DataTable dt = new DataTable();
dt = objmasters.getuserinfo(member_code);
DataRow dr = dt.Rows[0];
dr["password"] = encrpt_password;
objDS_MemberTables.member_master.ImportRow(dr);
objBLReturnObject = objmasters.saveLinkData(objDS_MemberTables, true);
if (objBLReturnObject.ExecutionStatus == 1)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass");
return("pass");
}
else
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail");
return("fail");
}
}
catch (Exception ex)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return("fail");
}
}
private void CheckCredentials(object parameter)
{
if (parameter == null)
{
return;
}
var passwordBox = (PasswordBox)parameter;
_password = passwordBox.Password;
var isUserCredentialsCorrect = GetRepository().CheckUserCredentials(_username, EncryptPassword.Encrypt(_password));
if (isUserCredentialsCorrect != null && isUserCredentialsCorrect.GetEnumerator().MoveNext())
{
var returnedUser = isUserCredentialsCorrect.FirstOrDefault <User>();
MainViewModel.LoggedUser = returnedUser;
var mainView = new Views.MainView();
var mainVM = new MainViewModel();
mainView.DataContext = mainVM;
mainView.Show();
CloseAction();
}
else
{
MessageBox.Show("Incorrect Credentials");
}
}
public string save_registrationquantina([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
bool flag = false;
Random rand = new Random();
int randomNo = rand.Next(1, 1000000);
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "call");
if (parameter["university"] == null || parameter["university"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "university not found"));
}
else if (parameter["email_id"] == null || parameter["email_id"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Email id not found"));
}
else if (parameter["password"] == null || parameter["password"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "password not found"));
}
else if (parameter["app_name"] == null || parameter["app_name"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "app name not found"));
}
//check if exites user
DataTable user = objmasters.ismemberexits(parameter["email_id"].ToString().ToLower());
if (user != null && user.Rows.Count > 0)
{
return(BLGeneralUtil.return_ajax_string("0", "this email Id is already registered "));
}
try
{
DS_General.member_masterRow objmember_maste = objgeneral.member_master.Newmember_masterRow();
objmember_maste.member_code = "1";
objmember_maste.app_name = parameter["app_name"].ToString();
objmember_maste.university = parameter["university"].ToString();
objmember_maste.first_name = parameter["name"].ToString();
objmember_maste.email_id = parameter["email_id"].ToString().ToLower();
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(parameter["password"].ToString());
objmember_maste.email_rand_no = randomNo;
objmember_maste.password = encrpt_password;
objmember_maste.is_active = "N";
objmember_maste.is_quantina = "Y";
objmember_maste.created_by = parameter["email_id"].ToString();
objmember_maste.created_date = System.DateTime.Now;
objmember_maste.created_host = HttpContext.Current.Request.UserHostName;
string BlobId = DoUserRegistrationQuickBlox(parameter["name"].ToString(), parameter["email_id"].ToString(), "admin@123");
if (BlobId == null || BlobId == "")
{
return(BLGeneralUtil.return_ajax_string("0", "some thing went wrong"));
}
else
{
objmember_maste.BlobId = BlobId;
objgeneral.member_master.Addmember_masterRow(objmember_maste);
}
DS_Transtration.fn_token_balanceRow token_bal_row = objDs_trastration.fn_token_balance.Newfn_token_balanceRow();
token_bal_row.doc_no = "1";
token_bal_row.member_id = parameter["email_id"].ToString().ToLower();
token_bal_row.total_debit = Convert.ToInt16(0.0);
token_bal_row.total_credit = Convert.ToInt16(0.0);
token_bal_row.balance_token = Convert.ToInt16(0.0);
token_bal_row.balance_amount = Convert.ToInt16(0.0);
token_bal_row.is_active = "Y";
token_bal_row.created_by = parameter["email_id"].ToString().ToLower();
token_bal_row.created_date = System.DateTime.Now;
token_bal_row.created_host = HttpContext.Current.Request.UserHostName;
objDs_trastration.fn_token_balance.Addfn_token_balanceRow(token_bal_row);
objBLReturnObject = objmasters.save_regstration(objgeneral, objDs_trastration);
if (objBLReturnObject.ExecutionStatus == 1)
{
try
{
// bool resultSendEmail = false;
bool resultSendEmail = profliecreationsendEmail(parameter["email_id"].ToString(), parameter["name"].ToString(), randomNo, parameter["university"].ToString(), "");
if (resultSendEmail == true)
{
flag = true;
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", ex.ToString()));
}
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", ex.ToString()));
}
if (flag == true)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "1");
return(BLGeneralUtil.return_ajax_string("1", "Thanks for signing up! Please click on the link sent to your email to confirm your account"));
}
else
{
return(BLGeneralUtil.return_ajax_string("0", "some things goes to wrong"));
}
}
public string logincheck([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
bool flag = false;
Random rand = new Random();
int randomNo = rand.Next(1, 1000000);
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "call");
if (parameter["email_id"] == null || parameter["email_id"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Email id not found"));
}
else if (parameter["password"] == null || parameter["password"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "password not found"));
}
else if (parameter["app_name"] == null || parameter["app_name"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "app name not found"));
}
try
{
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(parameter["password"].ToString());
//check
DataTable user = objmasters.ismemberexits(parameter["email_id"].ToString().ToLower());
if (user == null || user.Rows.Count < 0)
{
return(BLGeneralUtil.return_ajax_string("0", "this email Id is not registered "));
}
if (user.Rows[0]["email_rand_no"].ToString() != "0")
{
return(BLGeneralUtil.return_ajax_string("0", "This email ID has not yet been confirmed "));
}
else if (user.Rows[0]["is_quantina"].ToString() == null || user.Rows[0]["is_quantina"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "this email Id is not allowed in this app "));
}
else if (user.Rows[0]["BlobId"].ToString() == null || user.Rows[0]["BlobId"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Blob ID not Found "));
}
else if (user.Rows[0]["password"].ToString() != encrpt_password)
{
return(BLGeneralUtil.return_ajax_string("0", " password is wrong"));
}
else if (user.Rows[0]["password"].ToString() == encrpt_password)
{
if (user.Rows[0]["is_quantina"].ToString() == "Y")
{
return(BLGeneralUtil.return_ajax_data("1", GetJson1(user)));
}
}
else
{
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", ex.ToString()));
}
if (flag == true)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "1");
return(BLGeneralUtil.return_ajax_string("1", "saved successfully"));
}
else
{
return(BLGeneralUtil.return_ajax_string("0", "some things goes to wrong"));
}
}
public string saveUserLinkData([FromBody] EmailLink emailLinkData)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
string flag = "";
bool resultSendEmail = false;
Random rand = new Random();
int randomNo = rand.Next(1, 1000000);
//pooja bhadania on 18/4/16
DataTable dtAlreadyExistsEmailId = objmasters.LoginCheck(emailLinkData.email_id); //LoginCheck method has same parameter that we need.So directly use it but name is differ
if (dtAlreadyExistsEmailId != null && dtAlreadyExistsEmailId.Rows.Count == 1)
{
flag = "EmailExists";
return(flag);
}
emailLinkData.password = emailLinkData.password.Trim();
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(emailLinkData.password.ToString().Trim());
try
{
DataTable dtAlreadyExistsButNotVerified = objmasters.GetMemberDataFromEmailId(emailLinkData.email_id);
if (dtAlreadyExistsButNotVerified != null && dtAlreadyExistsButNotVerified.Rows.Count == 1)
{
DataRow dr = dtAlreadyExistsButNotVerified.Rows[0];
dr["first_name"] = emailLinkData.userName;
dr["university"] = emailLinkData.university;
dr["password"] = encrpt_password;
dr["email_rand_no"] = randomNo;
dr["created_date"] = System.DateTime.Now;
dr["created_host"] = HttpContext.Current.Request.UserHostName;
objDS_MemberTables.member_master.ImportRow(dr);
objBLReturnObject = objmasters.saveLinkData(objDS_MemberTables, true); //update flag true
}
else
{
DS_MemberTables.member_masterRow memMstRow = objDS_MemberTables.member_master.Newmember_masterRow();
memMstRow.member_code = randomNo.ToString(); //It is just passing the primary which will not store in db.
memMstRow.first_name = emailLinkData.userName;
memMstRow.university = emailLinkData.university;
memMstRow.email_id = emailLinkData.email_id;
memMstRow.password = encrpt_password;
memMstRow.email_rand_no = randomNo; //randomly generated number
memMstRow.is_active = "N";
memMstRow.created_by = emailLinkData.email_id;
memMstRow.created_date = System.DateTime.Now;
memMstRow.created_host = HttpContext.Current.Request.UserHostName;
objDS_MemberTables.member_master.Addmember_masterRow(memMstRow);
objBLReturnObject = objmasters.saveLinkData(objDS_MemberTables, false);
}
if (objBLReturnObject.ExecutionStatus == 1)
{
//resultSendEmail = sendEmail(emailLinkData.email_id, emailLinkData.userName, randomNo, emailLinkData.university, emailLinkData.university_icon);
//try
//{
// DS_Transtration.fn_token_balanceRow book_row = objDs_transtration.fn_token_balance.Newfn_token_balanceRow();
// book_row.doc_no = "1";
// book_row.member_id = emailLinkData.email_id;
// book_row.total_credit = 0;
// book_row.total_debit = 0;
// book_row.balance_amount = 0;
// book_row.is_active = "Y";
// book_row.created_by = emailLinkData.email_id;
// book_row.created_date = System.DateTime.Now;
// book_row.created_host = HttpContext.Current.Request.UserHostName;
// objDs_transtration.fn_token_balance.Addfn_token_balanceRow(book_row);
// objBLReturnObject = objmasters.savetokenbooking(objDs_transtration, false);
//}
//catch (Exception e)
//{
//}
}
else
{
flag = "Fail";
return(flag);
}
}
catch (Exception ex)
{
flag = "Fail";
return(flag);
}
if (resultSendEmail == true)
{
flag = "Pass";
}
else
{
flag = "Fail";
}
return(flag);
}
public string LoginCheckprofile([FromBody] LoginData loginData)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
DataTable dtMemberDetails = new DataTable();
string result = "";
string encrpt_password = "";
dtMemberDetails = objmasters.LoginCheckProfilecreation(loginData.userName);
if (dtMemberDetails == null || dtMemberDetails.Rows.Count == 0)
{
return("NotExists");
}
else
{
if (loginData.pass_encrpted_flag != "true")
{
loginData.password = loginData.password.Trim();
EncryptPassword encrpt = new EncryptPassword();
encrpt_password = encrpt.Encrypt(loginData.password.ToString().Trim());
}
else
{
encrpt_password = loginData.password;
}
if (dtMemberDetails.Rows[0]["password"].ToString() != encrpt_password)
{
return("WrongPass");
}
else
{
Random rand = new Random();
int tokenId = rand.Next(1, 100000);
DataRow dr = dtMemberDetails.Rows[0];
//dr["token_id"] = tokenId.ToString();
objDS_MemberTables.member_master.ImportRow(dr);
objBLReturnObject = objmasters.saveLinkData(objDS_MemberTables, true);
if (objBLReturnObject.ExecutionStatus == 1)
{
//var session = HttpContext.Current.Session;
//if (session != null)
//{
// if (session["token_id"] == null)
// {
// session["token_id"] = dtMemberDetails.Rows[0]["token_id"].ToString();
// }
//}
//string str = HttpContext.Current.Session["token_id"].ToString();
//result = str;
result = GetJson1(dtMemberDetails);
}
else
{
return("TokenIssue");
}
}
}
return(result);
}
public string LoginCheck([FromBody] LoginData loginData)
{
int flg = 0;
BLReturnObject objBLReturnObject = new BLReturnObject();
DataTable dtMemberDetails = new DataTable();
string result = "";
string encrpt_password = "";
dtMemberDetails = objmasters.LoginCheck(loginData.userName);
try
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.dives + " " + loginData.password + " " + loginData.userName + "status" + "pass");
if (dtMemberDetails == null || dtMemberDetails.Rows.Count == 0)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "NotExists");
return("NotExists");
}
if (dtMemberDetails.Rows[0]["university"].ToString() != loginData.university_id)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "Wronguniversity");
return("Wronguniversity");
}
else
{
if (loginData.pass_encrpted_flag != "true")
{
loginData.password = loginData.password.Trim();
EncryptPassword encrpt = new EncryptPassword();
encrpt_password = encrpt.Encrypt(loginData.password.ToString().Trim());
}
else
{
encrpt_password = loginData.password;
}
if (dtMemberDetails.Rows[0]["password"].ToString() != encrpt_password)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "WrongPass");
return("WrongPass");
}
if (dtMemberDetails.Rows[0]["default_role"].ToString() == "TT")
{
DataTable dtrole = objmasters.checkmemberrole(loginData.userName);
for (int i = 0; i < dtrole.Rows.Count; i++)
{
if (dtrole.Rows[i]["role_id"].ToString() == "ST")
{
break;
}
else if (dtrole.Rows[i]["role_id"].ToString() == "TT")
{
if (dtrole.Rows[i]["is_approved"].ToString() == "Y" && dtrole.Rows[i]["approved_by_whome"].ToString() != "" && dtrole.Rows[i]["approved_by_whome"].ToString() != null)
{
break;
}
else
{
flg++;
}
}
}
if (dtrole.Rows.Count == flg)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "notApproved");
return("notApproved");
}
}
//Random rand = new Random();
//int tokenId = rand.Next(1, 100000);
Guid tokenId = Guid.NewGuid();
DataRow dr = dtMemberDetails.Rows[0];
//dr["token_id"] = tokenId.ToString();
objDS_MemberTables.member_master.ImportRow(dr);
DS_MemberTables.login_tokenRow rowtoken = objDS_MemberTables.login_token.Newlogin_tokenRow();
rowtoken.member_id = loginData.userName;
rowtoken.device_id = loginData.dives;
rowtoken.token_id = tokenId.ToString();
if (rowtoken.device_id.Trim().Length == 0)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "Device not null");
return("Device not null");
}
else
{
objDS_MemberTables.login_token.Addlogin_tokenRow(rowtoken);
objBLReturnObject = objmasters.saveLinkData_login(objDS_MemberTables, true);
if (objBLReturnObject.ExecutionStatus == 1)
{
dtMemberDetails.Columns.Add("token_id");
dtMemberDetails.Rows[0]["token_id"] = tokenId.ToString();;
result = GetJson1(dtMemberDetails);
}
else
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "TokenIssue");
return("TokenIssue");
}
}
}
}
catch (Exception e)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + e.StackTrace);
return(result);
}
return(result);
}
