public JsonResult SaveEvent(EventReminder events)
{
var status = false;
using (SqlConnection con = new SqlConnection(Connectionstring))
{
string userid = Session["UserID"].ToString();
con.Open();
string qry = string.Empty;
qry = "Update tblEvents set Subject = '" + events.Subject + "', Description = '" + events.Description +
"', StartDate= '" + events.StartDate + "',EndDate= '" + events.EndDate + "' where EventID= '" + events.EventID + "' and UserID= " + userid;
eventRepository.AddUpdateDeleteSQL(qry);
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult SignUp(Registration registration)
{
string uId;
string uEmail;
string uname = "";
var status = false;
string queryCheck = $"Select UserId,Email,UserName from [dbo].[tblRegistration] where Email='{registration.Email}'";
List <string> isRegisterd = eventRepository.GetUserLoginDetails(queryCheck);
if (isRegisterd.Count != 0)
{
var isRegistered = true;
return(new JsonResult {
Data = new { isRegistered = isRegistered }
});
}
var dob = registration.DOB.ToString("yyyy-MM-dd");
string query = "insert into tblRegistration(UserName,Email,Password,DOB,Phone)" +
" values('" + registration.UserName + "','" + registration.Email + "','" + registration.Password + "','" + dob + "','" + registration.Phone + "')";
int count = eventRepository.AddUpdateDeleteSQL(query);
if (count == 1)
{
string query2 = $"Select UserId,Email,Password,UserName from [dbo].[tblRegistration] where Email='{registration.Email}' and Password='******'";
List <string> sessionVariables = eventRepository.GetUserLoginDetails(query2);
if (sessionVariables.Count != 0)
{
uId = sessionVariables[0];
uEmail = sessionVariables[1];
uname = sessionVariables[2];
Session["userid"] = uId;
Session["email"] = uEmail;
Session["username"] = uname;
status = true;
}
return(new JsonResult {
Data = new { status = status, username = uname }
});
}
else
{
return(new JsonResult {
Data = new { status = status }
});
}
}
public JsonResult Register(Registration register)
{
string userid;
string mail;
string uname;
var status = false;
var dob = register.DOB.ToString("yyyy-MM-dd");
string qry = "Select UserID,EmailId,UserName,Password From tblRegister Where EmailId=@EmailId";
List <string> var = eventRepository.LoginDetails(qry, register);
if (var.Count == 0)
{
string query = "insert into tblRegister(UserName,DOB,Phone,EmailId,Password)" +
" values('" + register.Username + "','" + dob + "','" + register.Phone + "','" + register.Email + "','" + register.Password + "')";
eventRepository.AddUpdateDeleteSQL(query);
List <string> variables = eventRepository.UserRegister(register);
if (variables.Count != 0)
{
userid = variables[0];
mail = variables[1];
uname = variables[2];
Session["UserID"] = userid;
Session["EmailId"] = mail;
Session["UserName"] = uname;
status = true;
return(new JsonResult {
Data = new { status = status, Username = uname }
});
}
}
return(new JsonResult {
Data = new { status = status }
});
}
