public IPLBidder getUserByUserName(string userName)
{
IPLBidder user = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader reader;
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_GetUserByUserName", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserName", userName));
reader = command.ExecuteReader();
while (reader.Read())
{
user = new IPLBidder();
user.firstName = reader["FirstName"].ToString();
user.lastName = reader["LastName"].ToString();
user.email = reader["EmailId"].ToString();
user.password = reader["password"].ToString();
user.userName = reader["userName"].ToString();
}
}
catch (Exception ex)
{
}
}
return(user);
}
public int createUser(IPLBidder bidder, int createBy, bool isActive = true)
{
int success = -1;
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_CreateUser", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@firstName", bidder.firstName));
command.Parameters.Add(new SqlParameter("@lastName", bidder.lastName));
command.Parameters.Add(new SqlParameter("@mobileNumber", bidder.mobileNumber));
command.Parameters.Add(new SqlParameter("@email", bidder.email));
command.Parameters.Add(new SqlParameter("@points", bidder.points));
command.Parameters.Add(new SqlParameter("@roleID", bidder.roleID));
command.Parameters.Add(new SqlParameter("@isActive", isActive));
command.Parameters.Add(new SqlParameter("@ADMINID", createBy));
command.Parameters.Add(new SqlParameter("@userName", bidder.userName));
command.Parameters.Add(new SqlParameter("@password", bidder.userName));
success = (int)command.ExecuteScalar();
}
catch (Exception ex)
{
}
}
return(success);
}
public ActionResult AddPoints(int userId)
{
IPLBidder user = new IPLBidder();
user.userId = userId;
return(PartialView("_AddPoints", user));
}
public static void createUser()
{
DBUser user = new DBUser();
IPLBidder bidder = new IPLBidder();
bidder.firstName = "";
bidder.lastName = "";
bidder.email = "";
bidder.points = 100;
bidder.roleID = 1;
bidder.mobileNumber = "123123";
bidder.userName = Guid.NewGuid().ToString();
bidder.password = "";
user.createUser(bidder, 1, true);
}
public ActionResult AddPoints(IPLBidder iplBidder)
{
int success = userDB.addBidPoints(iplBidder);
if (success == 1)
{
return(Json(new { data = new Result {
Status = ResultStatus.Success, Message = "Points added successfully."
} }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { data = new Result {
Status = ResultStatus.Error, Message = "Error occurred while adding points."
} }, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> ForgotPassword(string Username)
{
IPLBidder user = userDB.getUserByUserName(Username);
if (user == null)
{
return(Json(new { data = new Result {
Status = ResultStatus.Error, Message = "User not found"
} }, JsonRequestBehavior.AllowGet));
}
else
{
Task.Run(async() => SendEmail(user));
return(Json(new { data = new Result {
Status = ResultStatus.Success, Message = "Password is sent on you email id, please check you inbox."
} }, JsonRequestBehavior.AllowGet));
}
}
public void SendEmail(IPLBidder iplBidder)
{
MailHelper mailHelper = new MailHelper();
EmailMessage mailMessage = new EmailMessage();
mailMessage.From = Constants.FromAddress;
mailMessage.TemplatePath = Constants.TemplatePath;
mailMessage.TemplateLogo = Constants.TemplateLogo;
MailHelper helper = new MailHelper();
mailMessage.Subject = "Forgot password on cricmoolah.com";
mailMessage.To = iplBidder.email;
mailMessage.Body = "";
mailMessage.MarkerList.Add("{$loginId}", iplBidder.userName);
mailMessage.MarkerList.Add("{$password}", iplBidder.password);
mailMessage.MarkerList.Add("{$firstname}", iplBidder.firstName + " " + iplBidder.lastName);
mailMessage.IsBodyHtml = true;
mailMessage.Template = "ForgotPassword";
string message = helper.DraftMail(mailMessage);
}
public async Task <ActionResult> CreateUser(IPLBidder iplBidder)
{
iplBidder.password = GeneratePassword.CreateRandomPassword(8);
iplBidder.roleID = (int)UserRoles.Bidder;
int success = userDB.createUser(iplBidder, 1);
if (success == 1)
{
// Task.Run(async () => SendEmail(iplBidder));
return(Json(new { data = new Result {
Status = ResultStatus.Success, Message = "User registered successfully."
} }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { data = new Result {
Status = ResultStatus.Error, Message = "Error occurred while registering user."
} }, JsonRequestBehavior.AllowGet));
}
}
public int addBidPoints(IPLBidder bidder)
{
int success = -1;
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_UpdateBidPonits", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@points", bidder.points));
command.Parameters.Add(new SqlParameter("@userid", bidder.userId));
success = (int)command.ExecuteScalar();
}
catch (Exception ex)
{
}
}
return(success);
}
public List <IPLBidder> getUser(sortPaging sortPage)
{
List <IPLBidder> users = new List <IPLBidder>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader reader;
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_GetUser", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@PageNo", sortPage.pageNumber));
command.Parameters.Add(new SqlParameter("@PageSize", sortPage.pageSize));
command.Parameters.Add(new SqlParameter("@SortColumn", sortPage.sortColumn));
command.Parameters.Add(new SqlParameter("@SortOrder", sortPage.sortDirection));
reader = command.ExecuteReader();
while (reader.Read())
{
IPLBidder bidder = new IPLBidder();
bidder.firstName = reader["firstName"].ToString();
bidder.lastName = reader["lastName"].ToString();
bidder.userName = reader["userName"].ToString();
bidder.mobileNumber = reader["MobileNumber"].ToString();
bidder.email = reader["EmailId"].ToString();
bidder.points = Convert.ToDecimal(reader["Point"].ToString());
bidder.userId = Convert.ToInt32(reader["Id"]);
users.Add(bidder);
}
}
catch (Exception ex)
{
}
return(users);
}
}
public ActionResult CreateUser()
{
IPLBidder user = new IPLBidder();
return(PartialView("_CreateUser", user));
}
