public WebServiceResponse InsertTicketInfo(string TicketNo, int TicketPrice, int PriceAmount, DateTime DisplayDate, DateTime CloseDate, DateTime DrawDate, string Status)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("INSERT into TicketInfo(TicketNo,TicketPrice,PriceAmount,DisplayDate,CloseDate,DrawDate,Status) values('" + TicketNo + "','" + TicketPrice + "','" + PriceAmount + "','" + Convert.ToDateTime(DisplayDate).ToString("yyy/MM/dd HH:mm:ss") + "','" + Convert.ToDateTime(CloseDate).ToString("yyy/MM/dd HH:mm:ss") + "','" + Convert.ToDateTime(DrawDate).ToString("yyy/MM/dd HH:mm:ss") + "','" + Status + "')", SqlCon))
{
SqlCon.Open();
int res = SqlCmd.ExecuteNonQuery();
if (res == 1)
{
wsr.Status = "1";
}
}
SqlCon.Close();
return(wsr);
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
try
{
lws = new LotteryWebService.DBService();
wsr = new LotteryWebService.WebServiceResponse();
wsr = lws.VerifyUserLogin(UserId.Value.Trim(), Password.Value.Trim());
if (wsr.Status != "")
{
Session["UserId"] = wsr.Status;
Response.Redirect("UserHome.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
else if (wsr.Status == "0")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + wsr.Error + "')", true);
}
else
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('UserName Or Password Incorrect');", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message + "');", true);
}
}
protected void BtnAddTicket_Click(object sender, EventArgs e)
{
LotteryWebService.DBService lws = new LotteryWebService.DBService();
LotteryWebService.WebServiceResponse wsr = new LotteryWebService.WebServiceResponse();
try
{
wsr = lws.InsertTicketInfo(TicketNo.Value.Trim(), int.Parse(TicketPrice.Value.Trim()), int.Parse(PriceAmount.Value.Trim()), DateTime.Parse(DateTime.Now.ToString("yyy-MM-dd")), DateTime.Parse(CloseDate.Value), DateTime.Parse(DrawDate.Value), Status.SelectedItem.Text);
if (wsr.Status == "1")
{
Response.Redirect("Admin.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
else if (wsr.Status == "0")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + wsr.Error + "');", true);
}
}
catch (Exception ex)
{
//string message = string.Format("Message: {0}", ex.Message);
// int st = message.IndexOf("System.Exception:");
// int en = message.IndexOf(".\n");
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true);
}
}
public WebServiceResponse GetTicketCount()
{
try
{
wsr = new WebServiceResponse();
SqlCon.Open();
using (SqlCmd = new SqlCommand("SELECT COUNT(*) AS TicketCount FROM TicketInfo ", SqlCon))
{
string Count = SqlCmd.ExecuteScalar().ToString();
if (Count != "")
{
wsr.Status = Count;
}
SqlCon.Close();
return(wsr);
}
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
public WebServiceResponse VerifyUserLogin(string UserId, string Password)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("Select UserId From UserLoginInfo where Userid='" + UserId + "' and Password='******' and Status=1 ", SqlCon))
{
SqlCon.Open();
var name = SqlCmd.ExecuteScalar();
if (name != null)
{
wsr.Status = name.ToString();
}
}
SqlCon.Close();
return(wsr);
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
public WebServiceResponse UpdateUserInfo(string FirstName, string LastName, string PhoneNumber, string Email, string DOB, string Country, string IdType, string IdNo, string Address, string State, string City, string Code)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("UPDATE UserInfo SET FirstName='" + FirstName + "',LastName='" + LastName + "',PhoneNumber='" + PhoneNumber + "',Email='" + Email + "',DateOfBirth='" + DOB + "',Nationality='" + Country + "',IDType='" + IdType + "',IdNo='" + IdNo + "',Address='" + Address + "',State='" + State + "',City='" + City + "',Code='" + Code + "' WHERE PhoneNumber='" + PhoneNumber + "'", SqlCon))
{
SqlCon.Open();
int res = SqlCmd.ExecuteNonQuery();
if (res == 1)
{
wsr.Status = "1";
}
SqlCon.Close();
return(wsr);
}
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
public WebServiceResponse UpdateTicketInfo(string TicketNo, string Status)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("UPDATE TicketInfo SET Status='" + Status + "' WHERE TicketNo='" + TicketNo + "' ", SqlCon))
{
SqlCon.Open();
int res = SqlCmd.ExecuteNonQuery();
if (res == 1)
{
wsr.Status = "1";
}
}
SqlCon.Close();
return(wsr);
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
public WebServiceResponse InsertUserInfo(string FirstName, string LastName, string PhoneNumber, string Email, string Password, string DOB, string Country, string IdType, string IdNo, string Address, string State, string City, string Code)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("INSERT INTO UserInfo(FirstName,LastName,PhoneNumber,Email,Password,DateOfBirth,Nationality,IDType,IdNo,Address,State,City,Code) VAULES('" + FirstName + "','" + LastName + "','" + PhoneNumber + "','" + Email + "','" + Password + "','" + DOB + "','" + Country + "','" + IdType + "','" + IdNo + "','" + Address + "','" + State + "','" + City + "','" + Code + "')", SqlCon))
{
SqlCon.Open();
int res = SqlCmd.ExecuteNonQuery();
if (res == 1)
{
wsr.Status = "1";
}
SqlCon.Close();
return(wsr);
}
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
public WebServiceResponse InsertStoreInfo(string Store, string Address, string Timing)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("insert into StoreInfo values('" + Store + "','" + Address + "','" + Timing + "')", SqlCon))
{
SqlCon.Open();
int res = SqlCmd.ExecuteNonQuery();
if (res == 1)
{
wsr.Status = "1";
}
}
SqlCon.Close();
return(wsr);
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
public WebServiceResponse InsertTractionInfo()
{
try
{
wsr = new WebServiceResponse();
//using (SqlCmd = new SqlCommand("insert into UserInfo values('" + FirstName + "','" + LastName + "','" + PhoneNumber + "','" + Email + "','" + Password + "','" + DOB + "','" + Country + "','" + IdType + "','" + IdNo + "','" + Address + "','" + State + "','" + City + "','" + Code + "')", SqlCon))
//{
// SqlCon.Open();
// int res = SqlCmd.ExecuteNonQuery();
// if (res == 1)
// {
// wsr.Status = "1";
// }
//
//}
SqlCon.Close();
return(wsr);
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
wsr.Error = ex.Message;
}
return(wsr);
}
}
public WebServiceResponse IsExistingUser(string UserId)
{
try
{
wsr = new WebServiceResponse();
using (SqlCmd = new SqlCommand("Select UserId From UserLoginInfo where UserId='" + UserId + "' ", SqlCon))
{
SqlCon.Open();
var name = SqlCmd.ExecuteScalar();
if (name != null)
{
wsr.Status = "1";
}
}
SqlCon.Close();
return(wsr);
}
catch (Exception ex)
{
wsr.Status = "0";
wsr.Error = ex.Message;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(wsr);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Session["UserId"] as string))
{
//Response.Redirect("UserHome.aspx", false);
// Context.ApplicationInstance.CompleteRequest();
}
else
{
db = new LotteryWebService.DBService();
wsr = db.GetUserCount();
if (wsr.Status != "0")
{
userCount.InnerText = wsr.Status + "+";
ActiveCount.InnerText = Application["TotalOnlineUsers"].ToString();
}
else if (wsr.Status == "0")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + wsr.Error + "');", true);
}
}
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session["UserId"] != null)
{
//Log.InnerHtml = "Logout";
btnLogin.Text = "Signout";
lws = new LotteryWebService.DBService();
wsr = new LotteryWebService.WebServiceResponse();
}
else
{
Response.Redirect("Login.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
lws = new LotteryWebService.DBService();
ms = new MailService.Mail();
wsr = new MailService.WebServiceResponse();
wsr1 = new LotteryWebService.WebServiceResponse();
wsr2 = new LotteryWebService.WebServiceResponse();
}
public WebServiceResponse SendForgetEmail(string EmailId, string url, DateTime dt)
{
try
{
wsr = new WebServiceResponse();
string PasswordResetCode = Guid.NewGuid().ToString();
using (MailMessage mm = new MailMessage("*****@*****.**", EmailId))
{
string body;
string newurl = url.Replace("Rest.aspx", "Reset.aspx?ResetCode=" + PasswordResetCode);
mm.Subject = "Password Reset";
// string body = "Hello " + Name + ",";
body = "<br /><br />Please click the following link to Reset your account Password";
body += "<br /><a href = '" + newurl + "'>Click here to activate your account.</a>";
body += "<br /><br />Thanks";
mm.Body = body;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "(Sakilove2ani)");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
using (SqlCmd = new SqlCommand("INSERT INTO ForgetPassword VALUES('" + PasswordResetCode + "','" + EmailId + "','" + dt + "')", SqlCon))
{
SqlCon.Open();
int res = SqlCmd.ExecuteNonQuery();
if (res == 1)
{
wsr.Status = "1";
}
else
{
wsr.Status = "0";
}
SqlCon.Close();
}
return(wsr);
}
catch (Exception ex)
{
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
wsr.Error = ex.Message;
}
else
{
wsr.Error = ex.Message;
}
return(wsr);
}
}
public WebServiceResponse VerifyActivationEmail(string activationCode)
{
try
{
wsr = new WebServiceResponse();
using (SqlCommand cmd = new SqlCommand("SELECT ActivationCode FROM UserLoginInfo WHERE ActivationCode = '" + activationCode + "' and Status='0' ", SqlCon))
{
SqlCon.Open();
Sqldr = cmd.ExecuteReader();
if (Sqldr.Read())
{
Sqldr.Close();
using (SqlCmd = new SqlCommand("UPDATE UserLoginInfo SET Status='1' WHERE ActivationCode='" + activationCode + "'", SqlCon))
{
int rel = SqlCmd.ExecuteNonQuery();
if (rel == 1)
{
SqlCon.Close();
wsr.Status = "1";
}
else
{
SqlCon.Close();
wsr.Status = "0";
}
}
}
else
{
Sqldr.Close();
wsr.Status = "0";
}
return(wsr);
}
}
catch (Exception ex)
{
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
wsr.Error = ex.Message;
}
else
{
wsr.Error = ex.Message;
}
return(wsr);
}
}
protected void BtnSignup_Click(object sender, EventArgs e)
{
try
{
wsr1 = lws.IsExistingUser(Email.Value.Trim());
if (wsr1.Status == "0")
{
wsr2 = lws.InsertUserInfo(FirstName.Value.Trim(), LastName.Value.Trim(), PhoneNumber.Value, Email.Value.Trim(), Password.Value.Trim(), DOB.Value.Trim(), Country.SelectedItem.Value.Trim(), IDType.Items[IDType.SelectedIndex].Text.Trim(), IDNo.Value.Trim(), Address.Value.Trim(), State.Value.Trim(), City.Value.Trim(), Code.Value.Trim());
if (wsr2.Status == "1")
{
wsr = ms.SendActivationEmail(Email.Value.Trim(), FirstName.Value.Trim(), HttpContext.Current.Request.Url.AbsoluteUri, Password.Value.Trim());
if (wsr.Status == "1")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Registration Success. Activation Link sent to your Registered Email ');", true);
Response.Redirect("Home.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
else
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + wsr.Error + "');", true);
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + wsr2.Error + "');", true);
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert(' Mail id is Already register with another account ');", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true);
}
}
protected void BtnAddStore_Click(object sender, EventArgs e)
{
LotteryWebService.DBService lws = new LotteryWebService.DBService();
LotteryWebService.WebServiceResponse wsr = new LotteryWebService.WebServiceResponse();
try
{
wsr = lws.InsertStoreInfo(StoreName.Value.Trim(), Address.Value.Trim(), Timing.Value.Trim());
if (wsr.Status == "1")
{
Response.Redirect("Store.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
else if (wsr.Status == "0")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + wsr.Error + "');", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true);
}
}
