public IHttpActionResult Post(User_details b)
{
b.password = Encryptdata(b.password);
var user = db.AddUser(b);
return(Created(Request.RequestUri + "/" + user.user_id, user));
}
public HttpResponseMessage signup([FromBody] User_details userdetails)
{
try
{
using (Contextclass contextclass = new Contextclass())
{
var mailverification = emailexits(userdetails.Email);
if (mailverification)
{
return(Request.CreateResponse(HttpStatusCode.NoContent, "email_already_exits"));
}
userdetails.user_id = Guid.NewGuid();
userdetails.Verification = false;
userdetails.Created_on = DateTime.Now.Date;
contextclass.user_Details.Add(userdetails);
contextclass.SaveChanges();
senduserverificationmail(userdetails.Email, userdetails.user_id);
var message = Request.CreateResponse(HttpStatusCode.Created, userdetails.user_id);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Login(User_details UD)
{
Conn.Open();
SqlCommand selectUserQuery = new SqlCommand("SELECT * from Login where UserID = @UserID and Password = @Password", Conn);
selectUserQuery.Parameters.AddWithValue("@UserID", UD.UserID);
selectUserQuery.Parameters.AddWithValue("@Password", UD.Password);
SqlDataReader Reader = selectUserQuery.ExecuteReader();
while (Reader.Read())
{
Session["User ID"] = Reader[0].ToString();
Session["Dept"] = Reader[2].ToString();
Session["Admin"] = Reader[3].ToString();
Conn.Close();
if (Session["Dept"].ToString() == "Professional Skills")
{
return(RedirectToAction("ps", "Home", new { Info = "Welcome" }));
}
if (Session["Dept"].ToString() == "Mechanical Engineering")
{
return(RedirectToAction("Userhome", "Home", new { Info = "Welcome" }));
}
}
Conn.Close();
return(RedirectToAction("Home", "Home", new { Info = "Invalid User ID/Password" }));
}
public ActionResult Login(User_details user, string returnUrl)
{
var u = db.User_details.ToList();
User_details u2 = new User_details();
foreach (User_details u1 in u)
{
if (u1.name == user.name)
{
u2.name = u1.name;
u2.password = u1.password;
u2.user_id = u1.user_id;
}
}
int id = u2.user_id;
Session["id"] = id;
Session["name"] = u2.name;
int lid = 1;
if (Session["lid"] != null)
{
lid = Convert.ToInt32(Session["lid"]);
}
if (ModelState.IsValid)
{
if (isValid(user.name, user.password))
{
if (FormsAuthentication.IsEnabled)
{
FormsAuthentication.SetAuthCookie(user.name, false);
}
if (returnUrl != null)
{
if (Url.IsLocalUrl(returnUrl))
{
return(Redirect(returnUrl));
}
}
else
{
if (lid == 1)
{
return(RedirectToAction("Cancel", "Login"));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
}
return(RedirectToAction("Error", "Login"));
}
else
{
return(View("Error"));
}
}
private void btnupdate_Click_1(object sender, RoutedEventArgs e)
{
User_details userObj = new User_details();
userObj.UserId = Application.Current.Properties["User_ID"].ToString();
userObj.FirstName = txtFirstName.Text;
userObj.LastName = txtLastName.Text;
userObj.DateOfBirth = Convert.ToDateTime(dtpDateOfBirth.Text);
userObj.Address = txtAddress.Text;
userObj.LandLineNumber = txtLandlineNumber.Text;
userObj.MobileNumber = txtMobileNumber.Text;
string strCheckValue = "";
if (chkEngineering.IsChecked == true)
{
strCheckValue = strCheckValue + "," + chkEngineering.Content;
}
if (chkMedical.IsChecked == true)
{
strCheckValue = strCheckValue + "," + chkMedical.Content;
}
if (chkLaw.IsChecked == true)
{
strCheckValue = strCheckValue + "," + chkLaw.Content;
}
userObj.AreaOfInterest = strCheckValue;
if (rbtnMale.IsChecked == true)
{
userObj.Gender = "M";
}
else if (rbtnFemale.IsChecked == true)
{
userObj.Gender = "F";
}
if (rbtnSubscriber.IsChecked == true)
{
userObj.UserType = "Subscriber";
}
else if (rbtnNonSubscriber.IsChecked == true)
{
userObj.UserType = "Non_subscriber";
}
var userBLL = new User_detailsBLL();
var IsAddedUser = userBLL.UpdateUserDetails(userObj);
if (IsAddedUser)
{
Application.Current.Properties["User_Name"] = userObj.FirstName + " " + userObj.LastName;
MessageBox.Show("Updated!!!! ");
}
else
{
MessageBox.Show("Sorry!!!..Updation Failed.Try Again Later");
}
}
public void Put(int id, User_details b)
{
b.user_id = id;
b.password = Encryptdata(b.password);
if (!db.UpdateUser(b))
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
}
public User_details LogIn(User_details DetailsObj)
{
User_details newObj = new User_details();
var ConnectionObj = DatabaseConnection.CreateConnection();
var CommandObj = DatabaseConnection.CreateCommand(ConnectionObj, "ELIB_Management_System.uspLogInELIB", CommandType.StoredProcedure);
var P1 = DatabaseConnection.CreateParameter(CommandObj, "@User_Id", DbType.String);
P1.Value = DetailsObj.UserId;
P1.Size = 30;
CommandObj.Parameters.Add(P1);
var P2 = DatabaseConnection.CreateParameter(CommandObj, "@Password", DbType.String);
P2.Value = DetailsObj.Password;
P1.Size = 30;
CommandObj.Parameters.Add(P2);
try
{
DataTable TableObj = DatabaseConnection.ExecuteReader(CommandObj);
if (TableObj != null && TableObj.Rows.Count > 0)
{
foreach (DataRow row in TableObj.Rows)
{
newObj.UserId = (string)row[0];
newObj.FirstName = (string)row[1];
newObj.LastName = (string)row[2];
newObj.DateOfBirth = (DateTime)row[3];
newObj.Address = (string)row[4];
newObj.LandLineNumber = (string)row[5];
newObj.MobileNumber = (string)row[6];
newObj.AreaOfInterest = (string)row[7];
newObj.Gender = (string)row[8];
newObj.UserType = (string)row[9];
newObj.DateOfRegistration = (DateTime)row[10];
newObj.Password = (string)row[11];
}
}
}
catch (DbException ex)
{
throw new ELibException(ex.Message);
}
catch (Exception ex)
{
throw new ELibException(ex.Message);
}
return(newObj);
}
public ActionResult Register([Bind(Include = "name,date_of_birth,email_id,mobile_no,password,address")] User_details model)
{
if (ModelState.IsValid)
{
model.password = Encryptdata(model.password);
db.User_details.Add(model);
db.SaveChanges();
FormsAuthentication.SetAuthCookie(model.name, false);
return(RedirectToAction("Index", "Search"));
}
else
{
ModelState.AddModelError("", "Invalid Values");
}
return(View(model));
}
public HttpResponseMessage Login([FromBody] User_details userdetails)
{
using (Contextclass contextclass = new Contextclass())
{
bool Isvalid = contextclass.user_Details.Any(x => x.Email == userdetails.Email && x.Password == userdetails.Password && x.Verification == true);
if (Isvalid)
{
var Activationcode = contextclass.user_Details.Where(x => x.Email == userdetails.Email).Select(x => x.user_id).Single();
var message = Request.CreateResponse(HttpStatusCode.OK, Activationcode);
return(message);
}
else
{
return(Request.CreateResponse(HttpStatusCode.NoContent, "User_not_found"));
}
}
}
public User_details FindbyID(string userId)
{
User_details DetailsObj = new User_details();
var ConnectionObj = DatabaseConnection.CreateConnection();
var CommandObj = DatabaseConnection.CreateCommand(ConnectionObj, "ELIB_Management_System.uspFind_User_details", CommandType.StoredProcedure);
var P1 = DatabaseConnection.CreateParameter(CommandObj, "@User_ID", DbType.String);
P1.Value = userId;
P1.Size = 15;
CommandObj.Parameters.Add(P1);
try
{
DataTable TableObj = DatabaseConnection.ExecuteReader(CommandObj);
if (TableObj != null && TableObj.Rows.Count > 0)
{
foreach (DataRow row in TableObj.Rows)
{
DetailsObj.UserId = (string)row[0];
DetailsObj.FirstName = (string)row[1];
DetailsObj.LastName = (string)row[2];
DetailsObj.DateOfBirth = (DateTime)row[3];
DetailsObj.Address = (string)row[4];
DetailsObj.LandLineNumber = (string)row[5];
DetailsObj.MobileNumber = (string)row[6];
DetailsObj.AreaOfInterest = (string)row[7];
DetailsObj.Gender = (string)row[8];
DetailsObj.UserType = (string)row[9];
DetailsObj.DateOfRegistration = (DateTime)row[10];
DetailsObj.Password = (string)row[11];
}
}
}
catch (DbException ex)
{
throw new ELibException("Error reading data", ex);
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(DetailsObj);
}
public HttpResponseMessage newpassword(User_details userdetails)
{
try
{
using (Contextclass contextclass = new Contextclass())
{
var user_data = contextclass.user_Details.Where(x => x.Email == userdetails.Email).FirstOrDefault();
string password = userdetails.Password;
user_data.Password = passwordencryption(password);
contextclass.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public User_details LogIn(User_details userobj)
{
User_details newObj = null;
try
{
var DALObj = new User_detailsOperations();
newObj = DALObj.LogIn(userobj);
}
catch (ELibException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(newObj);
}
private void LoadData(string id)
{
id = enc.DecryptString(id, SV.LoginKey);
var uDetails = new User_details(id);
fname.InnerText = uDetails.Fname.ToUpper();
lname.InnerText = uDetails.Lname.ToUpper();
NameLiteral.Text = new User_details_view().Load_record_with(User_details_view_support.Column.Id, User_details_view_support.LogicalOperator.EQUAL_TO, id).Name;
dob.InnerText = DateTime.Parse(uDetails.Dob).ToLongDateString();
contact.InnerText = uDetails.Contact;
userTpe.InnerHtml = uDetails.User_type.ToUpper();
var s = new Speciality_table().Load_record_with(Speciality_table_support.Column.Doctor_id, Speciality_table_support.LogicalOperator.EQUAL_TO, uDetails.User_id).Speciality;
speciality.InnerText = !string.IsNullOrEmpty(s) ? s.ToUpper() : "N/A";
DisplayShift(id);
var prof = SV.GetImage(new Profile_image_table().Load_record_with(Profile_image_table_support.Column.User_id, Profile_image_table_support.LogicalOperator.EQUAL_TO, id).Url);
ProfPicLiteral.Text = $"<img src='../../images/{SV.GetImage(prof)}' alt='' class='img-responsive' />";
}
/// <summary>
/// Event that Fires on Button Login Click and Directs to HomePage
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
User_details userObj = new User_details();
userObj.UserId = txtUserID.Text;
userObj.Password = txtPassword.Text;
var userBLL = new User_detailsBLL();
var Obj = userBLL.LogIn(userObj);
if (Obj.UserType == "Administrator")
{
Session["User_Type"] = Obj.UserType;
Session["User_ID"] = userObj.UserId;
Session["User_Name"] = Obj.FirstName + " " + Obj.LastName;
Response.Redirect("DocumentUploadUpdate.aspx");
lblLoginMessage.Text = Obj.FirstName + " " + Obj.LastName + " is " + Obj.UserType;
}
else if (Obj.UserType == "Subscriber" || Obj.UserType == "Non_Subscriber")
{
Session["User_Type"] = Obj.UserType;
Session["User_ID"] = userObj.UserId;
Session["User_Name"] = Obj.FirstName + " " + Obj.LastName;
Response.Redirect("HomePage.aspx");
lblLoginMessage.Text = Obj.FirstName + " " + Obj.LastName + " is " + Obj.UserType;
}
else
{
Response.Write("<script>alert('Please Enter Proper Credentials')</script>");
}
}
catch (FormatException ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
catch (ELibException ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
public bool UpdateUserDetails(User_details userobj)
{
var IsSaved = false;
try
{
var DALObj = new User_detailsOperations();
IsSaved = DALObj.UpdateUserDetails(userobj);
}
catch (ELibException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(IsSaved);
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
try
{
User_details userObj = new User_details();
userObj.UserId = txtuserid.Text;
userObj.Password = txtpassword.Password;
var userBLL = new User_detailsBLL();
var Obj = userBLL.LogIn(userObj);
if (Obj.UserType == "Administrator")
{
Application.Current.Properties["User_Type"] = Obj.UserType;
Application.Current.Properties["User_ID"] = userObj.UserId;
Application.Current.Properties["User_Name"] = Obj.FirstName + " " + Obj.LastName;
this.NavigationService.Navigate(new Uri("AdminPage.xaml", UriKind.Relative));
}
else if (Obj.UserType == "Subscriber" || Obj.UserType == "Non_subscriber")
{
Application.Current.Properties["User_Type"] = Obj.UserType;
Application.Current.Properties["User_ID"] = userObj.UserId;
Application.Current.Properties["User_Name"] = Obj.FirstName + " " + Obj.LastName;
this.NavigationService.Navigate(new Uri("HomePage.xaml", UriKind.Relative));
}
else
{
MessageBox.Show("Enter Proper Credentials");
}
}
catch (FormatException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
catch (ELibException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
}
public HttpResponseMessage google_login([FromBody] User_details userdetails)
{
try
{
userdetails.user_id = Guid.NewGuid();
userdetails.Created_on = DateTime.Now;
var emailverification = emailexits(userdetails.Email);
if (emailverification)
{
var activationkey = contextclass.user_Details.Where(x => x.Email == userdetails.Email).Select(x => x.user_id).FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.Accepted, activationkey));
}
contextclass.user_Details.Add(userdetails);
contextclass.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, userdetails.user_id));
}
catch (HttpResponseException ex)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, ex));
}
}
public bool Register(User_details userobj)
{
var IsSaved = false;
try
{
if (ValidateUser(userobj))
{
var DALObj = new User_detailsOperations();
IsSaved = DALObj.Register(userobj);
}
}
catch (ELibException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(IsSaved);
}
private void RegisterHandler()
{
regBtn.ServerClick += delegate
{
var redirect = string.Empty;
redirect = nav.Register;
var logins = new Login_table().Load_record_with(Login_table_support.Column.Username, Login_table_support.LogicalOperator.EQUAL_TO, userBox.Value);
if (string.IsNullOrEmpty(logins.Id))
{
if (passBox.Value == rePass.Value)
{
var(check, result) = reg.IsPassword(passBox.Value);
if (check)
{
var uDetails = new User_details();
logins.insert(userBox.Value, enc.GetMD5(enc.StrongEncrypt(passBox.Value)), DateTime.Now.ToString("dd-MM-yyyy"), "3");
uDetails.insert(logins.Id, fnameBox.Value, lname.Value, emailBox.Value, addressBox.Value, contactBox.Value, genderSelect.Value, dob.Value, "patient");
Session["message"] = elements.GetMesage($"Welcome {uDetails.Fname} {uDetails.Lname}, you can now login.", HtmlElements.MessageType.SUCCESS, HtmlElements.UserType.ALL);
redirect = nav.Index;
}
else
{
Session["message"] = elements.GetMesage(result, HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
}
else
{
Session["message"] = elements.GetMesage("Passwords do not match!", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
}
else
{
Session["message"] = elements.GetMesage("Username is not available!", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
Response.Redirect(redirect);
};
}
private void SaveDoctor()
{
SaveBtn.ServerClick += delegate
{
var redirect = string.Empty;
var logins = new Login_table().Load_record_with(Login_table_support.Column.Username, Login_table_support.LogicalOperator.EQUAL_TO, userBox.Value);
if (IsEmpty(logins.Id))
{
var uDetails = new User_details();
var spTable = new Speciality_table();
if (passBox.Value == rePass.Value)
{
logins.insert(userBox.Value, enc.GetMD5(enc.StrongEncrypt(passBox.Value)), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "3");
uDetails.insert(logins.Id, Session["fname"].ToString(), Session["lname"].ToString(), Session["email"].ToString(), Session["address"].ToString(),
Session["contact"].ToString(), Session["gender"].ToString(), Session["date"].ToString(), "doctor");
ImagePofile();
spTable.insert(logins.Id, Session["profession"].ToString());
new ShiftHandler().SetDocShift(logins.Id);
Session["message"] = elements.GetMesage("New doctor has been added :-)", HtmlElements.MessageType.SUCCESS, HtmlElements.UserType.MANAGEMENT);
Shift = new Shift(SV.ShiftFilePath, logins.Id);
redirect = nav.Dashboard;
}
else
{
Session["message"] = elements.GetMesage("Passwords do not match!", HtmlElements.MessageType.SUCCESS, HtmlElements.UserType.MANAGEMENT); redirect = nav.ManNewDoctorDetails;
}
}
else
{
Session["message"] = elements.GetMesage("Username already exist", HtmlElements.MessageType.SUCCESS, HtmlElements.UserType.MANAGEMENT); redirect = nav.ManNewDoctorDetails;
}
Response.Redirect(redirect);
};
}
private void LoginEvent()
{
loginBtn.ServerClick += delegate
{
var redirectTo = string.Empty;
redirectTo = nav.Index;
var att = int.Parse(Session["attempt"].ToString());
var logins = new Login_table().Load_record_with(Login_table_support.Column.Username, Login_table_support.LogicalOperator.EQUAL_TO, userBox.Value);
if (att > 0)
{
if (!string.IsNullOrEmpty(logins.Id))
{
var attempts = int.Parse(logins.Attempts);
if (attempts > 0)
{
var d = enc.GetMD5(enc.StrongEncrypt(passBox.Value));
if (enc.GetMD5(enc.StrongEncrypt(passBox.Value)) == logins.Password)
{
var uDetails = new User_details().Load_record_with(User_details_support.Column.User_id, User_details_support.LogicalOperator.EQUAL_TO, logins.Id);
var uImage = new Profile_image_table().Load_record_with(Profile_image_table_support.Column.User_id, Profile_image_table_support.LogicalOperator.EQUAL_TO, logins.Id);
Session["uid"] = logins.Id;
Session["name"] = uDetails.Fname + " " + uDetails.Lname;
Session["username"] = logins.Username;
Session["address"] = uDetails.Address;
Session["contact"] = uDetails.Contact;
Session["email"] = uDetails.Email;
Session["gender"] = uDetails.Gender;
Session["dob"] = uDetails.Dob;
Session["staus"] = uDetails.User_type;
Session["image"] = uImage.Url;
logins.Attempts = "3";
var f = UserTypes.MANAGEMENT.ToString();
if (uDetails.User_type == UserTypes.MANAGEMENT.ToString().ToLower())
{
redirectTo = nav.Dashboard;
}
else if (uDetails.User_type == UserTypes.PATIENT.ToString().ToLower())
{
redirectTo = nav.PatientHome;
}
else if (uDetails.User_type == UserTypes.DOCTOR.ToString().ToLower())
{
redirectTo = nav.DoctorHome;
}
else
{
redirectTo = nav.Index;
}
}
else
{
attempts = attempts - 1;
logins.Attempts = attempts.ToString();
Session["message"] = elements.GetMesage($"Wrong username or password! left with {attempts} attemps", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
}
else if (attempts == 0)
{
Session["message"] = elements.GetMesage($"Max attempts reached, try again later or contact the mnagement.", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
else
{
attempts = attempts - 1;
logins.Attempts = attempts.ToString();
Session["message"] = elements.GetMesage($"Wrong username or password! left with {attempts} attemps", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
}
else
{
Session["message"] = elements.GetMesage("Wrong username or password!", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
}
else if (att == 0)
{
Session["message"] = elements.GetMesage($"Max attempts reached, try again later or contact the mnagement.", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
else
{
att = att - 1;
Session["attempt"] = att.ToString();
Session["message"] = elements.GetMesage("Wrong username or password!", HtmlElements.MessageType.INFO, HtmlElements.UserType.ALL);
}
Response.Redirect(redirectTo);
};
}
public PaymentWindow(User_details obj)
{
InitializeComponent();
Obj = obj;
}
/// <summary>
/// Event That Fires On Update Button Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
User_details UpdteObj = new User_details();
UpdteObj.UserId = Session["User_ID"].ToString();
UpdteObj.FirstName = txtFirstName.Text;
UpdteObj.LastName = txtLastName.Text;
UpdteObj.DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text);
UpdteObj.Address = txtAddress.Text;
UpdteObj.LandLineNumber = txtLandlineNumber.Text;
UpdteObj.MobileNumber = txtMobileNumber.Text;
string strCheckValue = "";
for (int i = 0; i < chkAreaOfInterestList.Items.Count; i++)
{
if (chkAreaOfInterestList.Items[i].Selected)
{
strCheckValue += chkAreaOfInterestList.Items[i].Value + ",";
}
}
strCheckValue = strCheckValue.TrimEnd(',');
UpdteObj.AreaOfInterest = strCheckValue;
UpdteObj.Gender = rdoGenderGroup.SelectedItem.Value.ToString();
UpdteObj.UserType = rdoUserTypeGroup.SelectedItem.Value.ToString();
if (UpdteObj.UserType == "Subscriber" && type == "Non_Subscriber")
{
Session["UpdteObj"] = UpdteObj;
Response.Redirect("EditProfilePayment.aspx");
}
//if(UpdteObj.UserType == "Non_Subscriber" && type == "Subscriber")
else
{
var userBLL = new User_detailsBLL();
var IsAddedUser = userBLL.UpdateUserDetails(UpdteObj);
if (IsAddedUser)
{
Session["User_Name"] = UpdteObj.FirstName + " " + UpdteObj.LastName;
Response.Write("<script>alert('Details Updated')</script>");
// Response.Write("<script>alert('Updated!!!! ')</script>");
}
else
{
// lblUpdateMessage.Text = "Sorry!!!..Updation Failed.Try Again Later";
Response.Write("<script>alert('Sorry!!!..Updation Failed.Try Again Later')</script>");
}
//Session["userObj"] = UpdteObj;
//Response.Redirect("SubscriberRegistrationPage.aspx");
}
}
catch (ELibException)
{
Response.Write("<script>alert('Please enter valid details.')</script>");
}
catch (Exception)
{
Response.Write("<script>alert('Sorry! Try again later.')</script>");
}
}
static string type; //Global Variable
/// <summary>
/// Event that Fires on Button Edit Details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnEditDetails_Click(object sender, EventArgs e)
{
try
{
if (Session["User_ID"] != null)
{
User_details NewObj = new User_details();
NewObj.UserId = Session["User_ID"].ToString();
var editObj = new User_detailsBLL();
var DetailsObj = editObj.FindbyID(NewObj.UserId);
txtFirstName.Text = DetailsObj.FirstName;
txtLastName.Text = DetailsObj.LastName;
txtDateOfBirth.Text = DetailsObj.DateOfBirth.ToString("yyyy-MM-dd");
txtAddress.Text = DetailsObj.Address;
txtLandlineNumber.Text = DetailsObj.LandLineNumber;
txtMobileNumber.Text = DetailsObj.MobileNumber;
var a = DetailsObj.AreaOfInterest;
chkAreaOfInterestList.DataBind();
//var b=chkAreaOfInterestList.Items;
if (a.Contains("Engineering"))
{
chkAreaOfInterestList.Items[0].Selected = true;
}
if (a.Contains("Medical"))
{
chkAreaOfInterestList.Items[1].Selected = true;
}
if (a.Contains("Law"))
{
chkAreaOfInterestList.Items[2].Selected = true;
}
if (DetailsObj.Gender == "M")
{
rdoGenderGroup.Items[0].Selected = true;
}
else
{
rdoGenderGroup.Items[1].Selected = true;
}
if (DetailsObj.UserType == "Subscriber")
{
rdoUserTypeGroup.Items[0].Selected = true;
type = "Subscriber";
}
else
{
rdoUserTypeGroup.Items[1].Selected = true;
type = "Non_Subscriber";
}
}
else
{
Response.Redirect("HomePage.aspx");
}
}
catch (ELibException ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
public bool Register(User_details DetailsObj)
{
var IsRegistered = false;
var ConnectionObj = DatabaseConnection.CreateConnection();
var CommandObj = DatabaseConnection.CreateCommand(ConnectionObj, "ELIB_Management_System.uspInsert_User_details", CommandType.StoredProcedure);
var P1 = DatabaseConnection.CreateParameter(CommandObj, "@User_ID", DbType.String);
P1.Value = DetailsObj.UserId;
P1.Size = 15;
CommandObj.Parameters.Add(P1);
var P2 = DatabaseConnection.CreateParameter(CommandObj, "@First_Name", DbType.String);
P2.Value = DetailsObj.FirstName;
P2.Size = 50;
CommandObj.Parameters.Add(P2);
var P3 = DatabaseConnection.CreateParameter(CommandObj, "@Last_Name", DbType.String);
P3.Value = DetailsObj.LastName;
P3.Size = 50;
CommandObj.Parameters.Add(P3);
var P4 = DatabaseConnection.CreateParameter(CommandObj, "@Date_Of_Birth", DbType.Date);
P4.Value = DetailsObj.DateOfBirth;
CommandObj.Parameters.Add(P4);
var P5 = DatabaseConnection.CreateParameter(CommandObj, "@Address", DbType.String);
P5.Value = DetailsObj.Address;
P5.Size = 1000;
CommandObj.Parameters.Add(P5);
var P6 = DatabaseConnection.CreateParameter(CommandObj, "@Land_Line_Number", DbType.String);
P6.Value = DetailsObj.LandLineNumber;
P6.Size = 15;
CommandObj.Parameters.Add(P6);
var P7 = DatabaseConnection.CreateParameter(CommandObj, "@Mobile_Number", DbType.String);
P7.Value = DetailsObj.MobileNumber;
P7.Size = 15;
CommandObj.Parameters.Add(P7);
var P8 = DatabaseConnection.CreateParameter(CommandObj, "@Area_Of_Interests", DbType.String);
P8.Value = DetailsObj.AreaOfInterest;
P8.Size = 100;
CommandObj.Parameters.Add(P8);
var P9 = DatabaseConnection.CreateParameter(CommandObj, "@Gender", DbType.String);
P9.Value = DetailsObj.Gender;
P9.Size = 1;
CommandObj.Parameters.Add(P9);
var P10 = DatabaseConnection.CreateParameter(CommandObj, "@User_Type", DbType.String);
P10.Value = DetailsObj.UserType;
P10.Size = 30;
CommandObj.Parameters.Add(P10);
var P11 = DatabaseConnection.CreateParameter(CommandObj, "@Date_Of_Registration", DbType.Date);
P11.Value = DetailsObj.DateOfRegistration;
CommandObj.Parameters.Add(P11);
var P12 = DatabaseConnection.CreateParameter(CommandObj, "@Password", DbType.String);
P12.Value = DetailsObj.Password;
P12.Size = 50;
CommandObj.Parameters.Add(P12);
try
{
DatabaseConnection.ExecuteNonQuery(CommandObj);
IsRegistered = true;
}
catch (DbException ex)
{
throw new ELibException(ex.Message);
}
catch (Exception ex)
{
throw new ELibException(ex.Message);
}
return(IsRegistered);
}
private void btnRegister_Click(object sender, RoutedEventArgs e)
{
try
{
User_details userObj = new User_details();
userObj.UserId = txtUserId.Text;
userObj.FirstName = txtFirstName.Text;
userObj.LastName = txtLastName.Text;
userObj.DateOfBirth = Convert.ToDateTime(dtpDateOfBirth.Text);
userObj.Address = txtAddress.Text;
userObj.LandLineNumber = txtLandlineNumber.Text;
userObj.MobileNumber = txtMobileNumber.Text;
string strCheckValue = "";
if (chkEngineering.IsChecked == true)
{
strCheckValue = strCheckValue + "," + chkEngineering.Content;
}
if (chkMedical.IsChecked == true)
{
strCheckValue = strCheckValue + "," + chkMedical.Content;
}
if (chkLaw.IsChecked == true)
{
strCheckValue = strCheckValue + "," + chkLaw.Content;
}
userObj.AreaOfInterest = strCheckValue;
if (rbtnMale.IsChecked == true)
{
userObj.Gender = "M";
}
else if (rbtnFemale.IsChecked == true)
{
userObj.Gender = "F";
}
if (rbtnSubscriber.IsChecked == true)
{
userObj.UserType = "Subscriber";
}
else if (rbtnNonSubscriber.IsChecked == true)
{
userObj.UserType = "Non_subscriber";
}
userObj.DateOfRegistration = Convert.ToDateTime(dtpDateOfRegistration.Text);
userObj.Password = txtPassword.Password;
//if Subscriber redirect to payment Window
if (userObj.UserType == "Subscriber")
{
var PaymentObj = new PaymentWindow(userObj);
PaymentObj.Show();
// PaymentObj.Close();
// if(PaymentObj.DialogResult.Value==)
this.NavigationService.Navigate(new Uri("HomePage.xaml", UriKind.Relative));
}
else
{
var userBLL = new User_detailsBLL();
var IsAddedUser = userBLL.Register(userObj);
if (IsAddedUser)
{
MessageBox.Show("Registration Successful as " + userObj.UserType + "!!..Access Granted To documents!");
}
else
{
MessageBox.Show("Sorry!!!..Registration Failed.Try Again Later");
}
}
}
catch (ELibException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
}
/// <summary>
/// Event That Fires on Button Register Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnRegister_Click(object sender, EventArgs e)
{
try
{
User_details userObj = new User_details();
userObj.UserId = txtUserId.Text;
userObj.FirstName = txtFirstName.Text;
userObj.LastName = txtLastName.Text;
userObj.DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text);
userObj.Address = txtAddress.Text;
userObj.LandLineNumber = txtLandlineNumber.Text;
userObj.MobileNumber = txtMobileNumber.Text;
string strCheckValue = "";
for (int i = 0; i < chkAreaOfInterestList.Items.Count; i++)
{
if (chkAreaOfInterestList.Items[i].Selected)
{
strCheckValue += chkAreaOfInterestList.Items[i].Value + ",";
}
}
strCheckValue = strCheckValue.TrimEnd(',');
userObj.AreaOfInterest = strCheckValue;
userObj.Gender = rdoGenderGroup.SelectedItem.Value.ToString();
userObj.UserType = rdoUserTypeGroup.SelectedItem.Value.ToString();
userObj.DateOfRegistration = Convert.ToDateTime(txtDateOfRegistration.Text);
userObj.Password = txtPassword.Text;
if (userObj.UserType == "Subscriber")
{
Session["userObj"] = userObj;
Response.Redirect("SubscriberRegistrationPage.aspx");
}
else
{
var userBLL = new User_detailsBLL();
var IsAddedUser = userBLL.Register(userObj);
if (IsAddedUser)
{
//lblRegistrationMessage.Text = "Registration Successful as " + userObj.UserType + "!!..Access Granted To documents!";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Registration Successful as" + userObj.UserType + "!!..Access Granted To documents!" + "');window.location='HomePage.aspx';", true);
}
else
{
Response.Write("<script>alert('Sorry!!!..Registration Failed.Try Again Later')</script>");
}
}
}
catch (ELibException ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
catch (Exception)
{
Response.Write("<script>alert('Please Check The Details')</script>");
}
}
/// <summary>
/// Event That Fires on Submit Button Click Which Registers as Subscriber or Else NoN_Subscriber
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
User_details Obj = (User_details)Session["userObj"];
var IsAdded = false;
try
{
var subscriberBll = new User_detailsBLL();
if (ValidateCard())
{
IsAdded = subscriberBll.Register(Obj);
if (IsAdded)
{
// lblPaymentMessage.Text = "Thank you for Subscribing!You are a Subsciber";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Registration Successful as " + Obj.UserType + "!!..Access Granted To documents!" + "');window.location='HomePage.aspx';", true);
//Response.Write("<script>alert('Thank you for Subscribing!You are a Subscriber')</script>");
//MessageBox.Show("Thankyou Subscribing!You are a Subsciber");
}
else
{
// lblPaymentMessage.Text = "Sorry,Subscription Failed";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Sorry!! Subscription Failed ');window.location='HomePage.aspx';", true);
// Response.Redirect("HomePage.aspx");
// Response.Write("<script>alert('Sorry,Subscription Failed')</script>");
// MessageBox.Show("Sorry,Subscription Failed");
}
}
else
{
Obj.UserType = "Non_Subscriber";
IsAdded = subscriberBll.Register(Obj);
if (IsAdded)
{
// lblPaymentMessage.Text = "You are a Non Subsciber";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('You are a Non-Subscriber');window.location='HomePage.aspx';", true);
//Response.Redirect("HomePage.aspx");
// Response.Write("<script>alert('You are a Non Subsciber')</script>");
//MessageBox.Show("You are a Non Subsciber");
}
else
{
// lblPaymentMessage.Text = "Sorry,Subscription Failed";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Sorry!! Subscription Failed ');window.location='HomePage.aspx';", true);
// Response.Redirect("HomePage.aspx");
// Response.Write("<script>alert('Sorry,Subscription Failed')</script>");
//MessageBox.Show("Sorry,Subscription Failed");
}
}
// Response.Redirect("HomePage.aspx");
}
catch (ELibException)
{
Response.Write("<script>alert('Please check the details')</script>");
//MessageBox.Show(ex.Message);
}
catch (Exception)
{
Response.Write("<script>alert('Sorry!Try again later')</script>");
//MessageBox.Show(ex.Message);
}
}
private bool ValidateUser(User_details userobj)
{
var IsValid = true;
var ErrorMessages = new StringBuilder();
var RegExObj = new Regex("^[a-zA-Z0-9]{8,15}$");
var RegNumber = new Regex("^[0-9]{3}-[0-9]{4}-[0-9]{4}$");
var regTenDigits = new Regex("^[1-9]{1}[0-9]{9}$");
if (string.IsNullOrEmpty(userobj.UserId.ToString()) || !RegExObj.IsMatch(userobj.UserId.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("User Id should not be blank");
ErrorMessages.AppendLine("Minimum of 8 Characters and maximum of 15 characters");
}
if (string.IsNullOrEmpty(userobj.FirstName))
{
IsValid = false;
ErrorMessages.AppendLine("FirstName Should Not Be Blank");
}
if (string.IsNullOrEmpty(userobj.LastName))
{
IsValid = false;
ErrorMessages.AppendLine("LastName Should Not Be Blank");
}
if (string.IsNullOrEmpty(userobj.DateOfBirth.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("Date Of Birth Should Not Be Blank");
}
var age = DateTime.Now.Year - userobj.DateOfBirth.Year;
if (age < 18)
{
IsValid = false;
ErrorMessages.AppendLine("You are not eligible to register.Age should be 18");
}
if (string.IsNullOrEmpty(userobj.Address))
{
IsValid = false;
ErrorMessages.AppendLine("Address Should Not Be Blank");
}
if (string.IsNullOrEmpty(userobj.LandLineNumber.ToString()) || !regTenDigits.IsMatch(userobj.LandLineNumber.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("LandLineNumber should not be blank");
ErrorMessages.AppendLine("LandLine Number Should Be in 10 digits");
}
if (string.IsNullOrEmpty(userobj.MobileNumber.ToString()) || !regTenDigits.IsMatch(userobj.MobileNumber.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("MobileNumber should not be blank");
ErrorMessages.AppendLine("LandLine Number Should Be in 10 digits");
}
if (string.IsNullOrEmpty(userobj.AreaOfInterest))
{
IsValid = false;
ErrorMessages.AppendLine("Area of Interest should not be blank");
}
if (string.IsNullOrEmpty(userobj.Gender.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("Gender Is Not Selected");
}
if (string.IsNullOrEmpty(userobj.UserType.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("UserType Is Not Selected");
}
var UserType = userobj.UserType.ToLower();
if (!UserType.Equals("subscriber") && !UserType.Equals("non_subscriber"))
{
IsValid = false;
ErrorMessages.AppendLine("Invalid UserType. Only Subscriber , Nonsubscriber is allowed");
}
if (string.IsNullOrEmpty(userobj.DateOfRegistration.ToString()))
{
IsValid = false;
ErrorMessages.AppendLine("Date Of Registration Should Not Be Blank");
}
if (!userobj.DateOfRegistration.Equals(DateTime.Now.Date))
{
IsValid = false;
ErrorMessages.AppendLine("Date Of Registration Should Be Current system's Date");
}
if (string.IsNullOrEmpty(userobj.Password))
{
IsValid = false;
ErrorMessages.AppendLine("Password Should Not Be Null");
}
if (IsValid == false)
{
throw new ELibException(ErrorMessages.ToString());
}
return(IsValid);
}
