public Data_return UserLogin(string User_Name, string Password, string Device_Imei, string Device_Token, string Device_Type)
{
Data_return dr = new Data_return();
SqlCommand cmd = new SqlCommand();
try
{
if (User_Name != "")
{
if (Password != "")
{
//DataTable dt = new DataTable();
//SqlDataAdapter adap = new SqlDataAdapter();
//string sql = @"SELECT User_Profile.*, State_Master.ShortName, State_Master.Name
// FROM User_Profile LEFT OUTER JOIN
// State_Master ON User_Profile.StateID = State_Master.ID
// Where User_Profile.EmailAddress=@User_Name and User_Profile.password=@Password";
//cmd.CommandType = CommandType.Text;
//cmd.Parameters.AddWithValue("@User_Name", User_Name);
//cmd.Parameters.AddWithValue("@Password", Password);
//cmd.CommandText = sql;
//cmd.Connection = con;
//dt.Clear();
//adap.SelectCommand = cmd;
//if (con.State == System.Data.ConnectionState.Closed)
//{
// con.Open();
//}
//adap.Fill(dt);
var userProfile = db.User_Profile.Include(u => u.Role_Master).Include(u => u.State_Master1).Where(a => a.UserName == User_Name && a.Password == Password &&
a.IsDeleted != "Deleted").ToList();
if (userProfile.Count > 0)
{
if (userProfile[0].Role_Master.Name == "Admin")
{
dr.Status = "FAILURE";
dr.Message = "Admin login not allowed";
dr.Requestkey = "UserLogin";
return(dr);
}
if (userProfile[0].AccountConfirmed == "No")
{
dr.Status = "FAILURE";
dr.Message = "Account not activated. Check your email for activation link.";
dr.Requestkey = "UserLogin";
SendMail(userProfile[0].FirstName, userProfile[0].LastName, userProfile[0].EmailAddress,
"https://www.lexnarro.com.au/User/ConfirmAccount/" + userProfile[0].ActivationCode,
"~/EmailTemplate/SignupConfirmation.html");
}
else
{
cmd.Parameters.Clear();
string update = @"update User_Profile set Device_Imei=@Device_Imei, Device_Token=@Device_Token, Device_Type=@Device_Type where EmailAddress=@User_Name AND Password=@Password";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Device_Imei", Device_Imei);
cmd.Parameters.AddWithValue("@Device_Token", Device_Token);
cmd.Parameters.AddWithValue("@Device_Type", Device_Type);
cmd.Parameters.AddWithValue("@User_Name", User_Name);
cmd.Parameters.AddWithValue("@Password", Password);
cmd.CommandText = update;
cmd.Connection = con;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
UserProfile uf = new UserProfile();
uf.ID = userProfile[0].ID;
uf.FirstName = userProfile[0].FirstName;
uf.LastName = userProfile[0].LastName;
uf.OtherName = userProfile[0].OtherName;
uf.StreetName = userProfile[0].StreetName;
uf.StreetNumber = userProfile[0].StreetNumber;
uf.PostCode = userProfile[0].PostCode;
uf.Suburb = userProfile[0].Suburb;
uf.StateID = userProfile[0].StateID;
uf.StateName = userProfile[0].State_Master.Name;
uf.CountryID = userProfile[0].CountryID;
uf.CountryName = userProfile[0].Country_Master.Name;
uf.StateEnrolled = userProfile[0].StateEnrolled;
uf.StateEnrolledName = userProfile[0].State_Master1.Name;
uf.StateEnrolledShortName = userProfile[0].State_Master1.ShortName;
uf.LawSocietyNumber = userProfile[0].LawSocietyNumber;
uf.EmailAddress = userProfile[0].EmailAddress;
uf.PhoneNumber = userProfile[0].PhoneNumber;
uf.Date = userProfile[0].Date;
uf.Address = userProfile[0].Address;
uf.Device_Imei = userProfile[0].Device_Imei;
uf.Device_Token = userProfile[0].Device_Token;
uf.Device_Type = userProfile[0].Device_Type;
uf.IsDeleted = userProfile[0].IsDeleted;
uf.AccountConfirmed = userProfile[0].AccountConfirmed;
uf.ActivationCode = userProfile[0].ActivationCode;
uf.MailUnsubscribed = userProfile[0].MailUnsubscribed;
uf.Firm = userProfile[0].Firm;
dr.Profile = uf;
dr.Status = "SUCCESS";
dr.Message = "Login Success.";
dr.Requestkey = "UserLogin";
dr.Token = GenerateString(15);
}
else
{
dr.Status = "FAILURE";
dr.Message = "Server Error";
dr.Requestkey = "UserLogin";
}
}
}
else
{
dr.Status = "FAILURE";
dr.Message = "User ID is not valid.";
dr.Requestkey = "UserLogin";
}
}
else
{
dr.Status = "FAILURE";
dr.Message = "Password is not valid.";
dr.Requestkey = "UserLogin";
}
}
else
{
dr.Status = "FAILURE";
dr.Message = "User ID is required.";
dr.Requestkey = "UserLogin";
}
}
catch (Exception)
{
dr.Status = "FAILURE";
dr.Message = "Something went wrong..";
dr.Requestkey = "UserLogin";
}
return(dr);
}
//[ScriptMethod(ResponseFormat = ResponseFormat.Xml)]
public Data_return UserRegistration(string FirstName, string LastName, string OtherName,
string StreetNumber, string StreetName, string PostCode, string Suburb,
string stateName, string countryName, string StateEnrolledName, string Firm,
string LawSocietyNumber, string EmailAddress, string PhoneNumber,
string Password, string Address, string Device_Imei, string Device_Token, string Device_Type)
{
Data_return dr = new Data_return();
SqlTransaction tran = null;
try
{
if (FirstName == "")
{
dr.Message = "Please Enter Your First Name";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (LastName == "")
{
dr.Message = "Please Enter Your Last Name";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (StreetNumber == "")
{
dr.Message = "Please Enter Your Street Number";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (StreetName == "")
{
dr.Message = "Please Enter Your Street Name";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (PostCode.ToString() == "")
{
dr.Message = "Please Enter Your Post Code";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
else
{
if (PostCode.ToString().Length <= 0 || PostCode.ToString().Length > 4)
{
dr.Message = "Post Code Should be 4 Digits long";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (NewClass.ContainsAny(PostCode.ToString(), specialCharacterList))
{
dr.Message = "Invalid Post Code";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
}
if (stateName == "")
{
dr.Message = "Please Enter Your State";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (countryName == "")
{
dr.Message = "Please Enter Your Country";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (StateEnrolledName == "")
{
dr.Message = "Please Enter Your State Enrolled";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (LawSocietyNumber.ToString() == "")
{
dr.Message = "Please Enter Your LawSociety Number";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
else
{
if (LawSocietyNumber.ToString().Length < 5 || LawSocietyNumber.ToString().Length > 10)
{
dr.Message = "LawSociety Number Should be 5 to 10 Digits long";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (NewClass.ContainsAny(LawSocietyNumber.ToString(), specialCharacterList))
{
dr.Message = "Invalid LawSociety Number";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
}
if (PhoneNumber.ToString() == "")
{
dr.Message = "Please Enter Your Phone Number";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
else
{
if (PhoneNumber.ToString().Length < 10 || PhoneNumber.ToString().Length > 10)
{
dr.Message = "Phone Number Should be 10 Digits Long And Must Start With Zero(0).";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
else
{
Regex regex = new Regex(@"^0\d{9}$");
Match match = regex.Match(PhoneNumber);
if (match.Success)
{
//dr.Message = "Please Enter Your Phone Number";
//dr.Status = "Failure";
//dr.Requestkey = "UserRegistration";
//return dr;
}
else
{
dr.Message = "Phone Number Should be 10 Digits Long And Must Start With Zero(0).";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
}
}
if (Password == "")
{
dr.Message = "Please Enter Your Password";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (Device_Imei == "")
{
dr.Message = "Please Enter Your Device_Imei";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (Device_Token == "")
{
dr.Message = "Please Enter Your Device_Token";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (Device_Type == "")
{
dr.Message = "Please Enter Your Device_Type";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (EmailAddress == "")
{
dr.Message = "Please Enter Your Email Address";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
else
{
Regex regex = new Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
Match match = regex.Match(EmailAddress);
if (match.Success)
{
//dr.Message = "Please Enter Your Phone Number";
//dr.Status = "Failure";
//dr.Requestkey = "UserRegistration";
//return dr;
}
else
{
dr.Message = "Please Enter Valid Email Address";
dr.Status = "Failure";
dr.Requestkey = "UserRegistration";
return(dr);
}
string[] emailCode = CheckExistingEmail(EmailAddress).Split('-');
if (emailCode[0] == "RegisteredAndActivated")
{
dr.Message = "Email already registered. Check your email for Id and password.";
dr.Status = "Success";
dr.Requestkey = "UserRegistration";
return(dr);
}
if (emailCode[0] == "RegisteredNotActivated")
{
dr.Message = "Email already registered. Account not activated, Please check your email for activation link.";
dr.Status = "Success";
dr.Requestkey = "UserRegistration";
return(dr);
}
}
//if (Date == "")
//{
// dr.Message = "Please Enter Your Date";
// dr.Status = "Failure";
// dr.Requestkey = "UserRegistration";
// return dr;
//}
//if (Role_id.ToString() == "")
//{
// dr.Message = "Please Enter Your Role_id";
// dr.Status = "Failure";
// dr.Requestkey = "UserRegistration";
// return dr;
//}
decimal countryID = Convert.ToDecimal(findCountry(countryName));
decimal stateID = Convert.ToDecimal(findState(stateName));
decimal stateEnrolledID = Convert.ToDecimal(findState(StateEnrolledName));
if (con.State == ConnectionState.Closed)
{
con.Open();
}
tran = con.BeginTransaction(IsolationLevel.ReadCommitted);
using (tran)
{
cmd.Connection = con;
cmd.CommandText = "usp_insert";
cmd.Transaction = tran;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@FirstName", FirstName);
cmd.Parameters.AddWithValue("@LastName", LastName);
cmd.Parameters.AddWithValue("@OtherName", OtherName);
cmd.Parameters.AddWithValue("@StreetNumber", StreetNumber);
cmd.Parameters.AddWithValue("@StreetName", StreetName);
cmd.Parameters.AddWithValue("@PostCode", Convert.ToDecimal(PostCode));
cmd.Parameters.AddWithValue("@Suburb", Suburb);
cmd.Parameters.AddWithValue("@StateID", stateID);
cmd.Parameters.AddWithValue("@CountryID", countryID);
cmd.Parameters.AddWithValue("@StateEnrolled", stateEnrolledID);
cmd.Parameters.AddWithValue("@LawSocietyNumber", Convert.ToDecimal(LawSocietyNumber));
cmd.Parameters.AddWithValue("@EmailAddress", EmailAddress);
cmd.Parameters.AddWithValue("@PhoneNumber", PhoneNumber);
cmd.Parameters.AddWithValue("@UserName", EmailAddress);
cmd.Parameters.AddWithValue("@Password", Password);
cmd.Parameters.AddWithValue("@Date", DateTime.Today);
cmd.Parameters.AddWithValue("@Firm", !string.IsNullOrEmpty(Firm) ? Firm : (object)DBNull.Value);
cmd.Parameters.AddWithValue("@Role_id", 1);
cmd.Parameters.AddWithValue("@Address", Address);
cmd.Parameters.AddWithValue("@Device_Imei", Device_Imei);
cmd.Parameters.AddWithValue("@Device_Token", Device_Token);
cmd.Parameters.AddWithValue("@Device_Type", Device_Type);
cmd.Parameters.AddWithValue("@IsDeleted", DBNull.Value);
cmd.Parameters.AddWithValue("@AccountConfirmed", "No");
Guid activationCode = Guid.NewGuid();
cmd.Parameters.AddWithValue("@ActivationCode", activationCode);
cmd.Parameters.Add("@id", SqlDbType.Decimal).Direction = ParameterDirection.Output;
int r = cmd.ExecuteNonQuery();
decimal userId = Convert.ToDecimal(cmd.Parameters["@id"].Value);
if (r > 0)
{
DataTable dst = GetRateCard();
if (dst.Rows.Count > 0)
{
string insertIntoTransactionTable = @"insert into User_Transaction_Master values
(@Rate_ID, @User_ID, @Plan_ID, @Amount, @Start_Date, @End_Date, 'N/A',
0, 'Active', @Payment_Date, 0, 'N/A', NULL, NULL)";
cmd.Parameters.Clear();
cmd.Connection = con;
cmd.CommandText = insertIntoTransactionTable;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Rate_ID", Convert.ToDecimal(dst.Rows[0]["Rate_Id"]));
cmd.Parameters.AddWithValue("@User_ID", userId);
cmd.Parameters.AddWithValue("@Plan_ID", Convert.ToDecimal(dst.Rows[0]["Plan_ID"]));
cmd.Parameters.AddWithValue("@Amount", Convert.ToDecimal(dst.Rows[0]["Amount"]));
cmd.Parameters.AddWithValue("@Start_Date", DateTime.Today);
cmd.Parameters.AddWithValue("@End_Date", DateTime.Today.AddMonths(3));
cmd.Parameters.AddWithValue("@Payment_Date", Convert.ToDateTime("01/01/1990"));
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
string setMailReminderDates = @"insert into MailLog values
(@UserID, @ReminderOne, @ReminderTwo, @ReminderThree, @ReminderFour,
@ReminderFive, @ReminderSix, @LastReminderStatus)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@UserID", userId);
cmd.Parameters.AddWithValue("@ReminderOne", DateTime.Today.AddDays(2));
cmd.Parameters.AddWithValue("@ReminderTwo", DateTime.Today.AddDays(7));
cmd.Parameters.AddWithValue("@ReminderThree", DateTime.Today.AddDays(14));
cmd.Parameters.AddWithValue("@ReminderFour", DateTime.Today.AddDays(30));
cmd.Parameters.AddWithValue("@ReminderFive", DateTime.Today.AddDays(60));
cmd.Parameters.AddWithValue("@ReminderSix", DateTime.Today.AddDays(90));
cmd.Parameters.AddWithValue("@LastReminderStatus", DBNull.Value);
cmd.Connection = con;
cmd.CommandText = setMailReminderDates;
cmd.CommandType = CommandType.Text;
int res = cmd.ExecuteNonQuery();
if (res > 0)
{
tran.Commit();
string activationLink = "https://www.lexnarro.com.au/User/ConfirmAccount/" + activationCode;
string mailStatus = SendMail(FirstName, LastName, EmailAddress,
activationLink, "~/EmailTemplate/SignupConfirmation.html");
if (mailStatus == "success")
{
dr.Status = "Success";
dr.mailStatus = "Email sent.";
dr.Message = "Registration Successfull, check email for account activation.";
dr.Requestkey = "UserRegistration";
dr.Token = GenerateString(15);
}
else
{
dr.Status = "Success";
dr.mailStatus = "Email sending failed.";
dr.Message = "Registration Successfull.";
dr.Requestkey = "UserRegistration";
dr.Token = GenerateString(15);
}
}
else
{
tran.Rollback();
dr.Status = "Failure";
dr.Message = "Registration Failure";
dr.Requestkey = "UserRegistration";
}
}
else
{
tran.Rollback();
dr.Status = "Failure";
dr.Message = "Registration Failure";
dr.Requestkey = "UserRegistration";
}
}
else
{
tran.Rollback();
dr.Status = "Failure";
dr.Message = "Registration Failure";
dr.Requestkey = "UserRegistration";
}
}
else
{
tran.Rollback();
dr.Status = "Failure";
dr.Message = "Registration Failure";
dr.Requestkey = "UserRegistration";
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
catch (System.Web.Services.Protocols.SoapException ex)
{
tran.Rollback();
dr.Status = "Failure";
dr.Message = "Registration Failure" + ex.ToString();
dr.Requestkey = "UserRegistration";
}
catch (Exception ex)
{
tran.Rollback();
dr.Status = "Failure" + ex.ToString();
dr.Message = "Registration Failure" + ex.ToString();
dr.Requestkey = "UserRegistration";
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(dr);
}
public Data_return mailPassword(string emailId)
{
SqlDataAdapter adap = new SqlDataAdapter();
DataTable data = new DataTable();
Data_return dr = new Data_return();
try
{
if (emailId == null || emailId == "")
{
dr.Status = "Failure";
dr.Message = "Email Id is Required.";
dr.Requestkey = "mailPassword";
return(dr);
}
cmd = new SqlCommand();
string query = @"SELECT EmailAddress,Password,FirstName,LastName FROM User_Profile WHERE EmailAddress=@email";
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
cmd.Connection = con;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@email", emailId);
adap.SelectCommand = cmd;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
adap.Fill(data);
if (data.Rows.Count > 0)
{
string email = data.Rows[0]["EmailAddress"].ToString();
string password = data.Rows[0]["Password"].ToString();
string fname = data.Rows[0]["FirstName"].ToString();
string lname = data.Rows[0]["LastName"].ToString();
string subject = "Password Recovery";
string body = "Hello " + fname + " " + lname + ", <br /><br />Your Email Id : '" + emailId + "'<br />Your Password : '******'<br />Thanks.";
bool result = SendEmail(email, subject, body);
if (result == true)
{
dr.Status = "SUCCESS";
dr.Message = "Password is sent to the Registered Email Id.";
dr.Requestkey = "mailPassword";
}
else
{
dr.Status = "FAILURE";
dr.Message = "SERVER ERROR";
dr.Requestkey = "mailPassword";
}
}
else
{
dr.Status = "Failure";
dr.Message = "Email Id is does not Exist.";
dr.Requestkey = "mailPassword";
}
}
catch (SoapException ex)
{
dr.Status = "FAILURE";
dr.Message = "SERVER ERROR";
dr.Requestkey = "mailPassword";
}
catch (Exception ex)
{
dr.Status = "FAILURE";
dr.Message = "SERVER ERROR";
dr.Requestkey = "mailPassword";
}
finally
{
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
}
return(dr);
}
