public string giris(string username, string password, string Hardware_Id)
{
User_Details UserTable = db.User_Details.Where(x => x.User_Name == username && x.User_Pass == password).FirstOrDefault();
if (UserTable != null)
{
PC_Details pc_varmi = db.PC_Details.Where(x => x.Hardware_Id == Hardware_Id).FirstOrDefault();
if (pc_varmi == null)
{
PC_Details PC_Details = new PC_Details();
PC_Details.User_Id = UserTable.id;
PC_Details.Hardware_Id = Hardware_Id;
PC_Details.Status_ = true;
PC_Details.Last_Sync = DateTime.Now;
db.PC_Details.Add(PC_Details);
db.SaveChanges();
return("Pc_Eklendi");//Kullanıcı id si bu olan kayıt giriş yaptı ve bilgisayarı ekledı
}
else
{
pc_varmi.Status_ = true;
pc_varmi.Last_Sync = DateTime.Now;
db.SaveChanges();
return("Normal_Giris");//Kullanıcıya Ait Bilgisayar Var Normal Giriş Yap.
}
}
else
{
return("Kullanici_Bulunamadi");//Kullanıcı Bulunamadı.
}
}
public void Find_UID(User_Details u_id)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM Login WHERE Login_id='" + u_id.UID + "' OR Username ='******' ", connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@uid", u_id.UID);
command.Parameters.AddWithValue("@ueid", u_id.UEID);
command.Parameters.AddWithValue("@uname", u_id.USERNAME);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("User ID or Username already exists", "Exists", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
// return
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtPass.Text.Equals(txtCPass.Text))
{
int id = int.Parse(txtId.Text);
User_Details u = new User_Details();
u = cmd.User_Details.First(x => x.U_ID == id);
u.Password = txtPass.Text;
cmd.Entry(u).State = EntityState.Modified;
cmd.SaveChanges();
//btnNew.PerformClick();
this.Visible = false;
}
else
{
MessageBox.Show("Passwords Do Not Match");
}
}
catch (Exception exception)
{
MessageBox.Show("Please fill the fields properly");
}
}
public HttpResponseMessage RegisterUser([FromBody] User_Details newUser)
{
try
{
using (BloggerAppDBEntities entities = new BloggerAppDBEntities())
{
var user = entities.User_Details.FirstOrDefault(d => d.UserName == newUser.UserName);
if (user == null)
{
entities.User_Details.Add(newUser);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, newUser);
message.Headers.Location = new Uri(Request.RequestUri + newUser.UserName.ToString());
return(message);
}
else
{
var message = Request.CreateResponse(HttpStatusCode.Conflict, "User already exists!");
return(message);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public int Insert(User_Details u_det)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO Login VALUES('" + u_det.UID + "','" + u_det.UEID + "', '" + u_det.USERNAME + "' ,'" + u_det.PASSWORD + "')", connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@uid", u_det.UID);
command.Parameters.AddWithValue("@ueid", u_det.UEID);
command.Parameters.AddWithValue("@username", u_det.USERNAME);
command.Parameters.AddWithValue("@password", u_det.PASSWORD);
return(command.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
public ActionResult User_Details(userdata ud)
{
DataUtility du = new DataUtility();
User_Details responce = new User_Details();
try
{
string query = "Exec spCustomer '','" + ud.Email + "','','','','','','SelectByEmail'";
DataSet ds = du.BindDataset(query);
List <userdata> lst = new List <userdata>();
if (ds.Tables[0].Rows.Count > 0)
{
userdata u = new userdata();
u.U_ID = int.Parse(ds.Tables[0].Rows[0]["U_id"].ToString());
u.Name = ds.Tables[0].Rows[0]["Name"].ToString();
u.Contact = ds.Tables[0].Rows[0]["Contact"].ToString();
u.Address = ds.Tables[0].Rows[0]["Address"].ToString();
u.Pin_Code = ds.Tables[0].Rows[0]["Pin_Code"].ToString();
u.Email = ds.Tables[0].Rows[0]["Email"].ToString();
lst.Add(u);
responce.Data = lst;
}
}
catch (Exception e)
{
responce.Description = e.Message;
}
return(Json(responce));
}
public ActionResult Register(UserDetailsModel _UserDetailsModel)
{
if (ModelState.IsValid)
{
var UserTable = new User {
UserName = _UserDetailsModel.UserName, PassWord = _UserDetailsModel.PassWord, RoleId = _UserDetailsModel.RoleId
};
var UserDetails = new User_Details();
using (var context = _obj)
{
context.Users.Add(UserTable);
context.SaveChanges();
// var id = _obj.Users.Where(x => x.UserName == _UserDetailsModel.UserName && x.PassWord == _UserDetailsModel.PassWord && x.RoleId == _UserDetailsModel.RoleId);
UserDetails.UserId = UserTable.Id;
UserDetails.FirstName = _UserDetailsModel.FirstName;
UserDetails.LastName = _UserDetailsModel.LastName;
UserDetails.Email = _UserDetailsModel.Email;
context.User_Details.Add(UserDetails);
//etc add your other classes
context.SaveChanges();
return(RedirectToAction("Login", "Home"));
}
}
return(View());
}
public int Update(User_Details u_det)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
SqlCommand command = new SqlCommand("UPDATE Login SET Login_id='" + u_det.UID + "', Username='******' ,Password='******' WHERE User_ID = '" + u_det.UID + "'", connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@uid", u_det.UID);
command.Parameters.AddWithValue("@username", u_det.USERNAME);
command.Parameters.AddWithValue("@password", u_det.PASSWORD);
return(command.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
public void MaptoModel(User user, User_Details details)
{
user.First_Name = FirstName;
user.Last_Name = LastName;
user.Email = Email;
details.Phone_No_Country_Code = CountryCode;
details.Phone_No = Phone;
}
public ActionResult Giris(User_Details uye)
{
uye.Last_Login = DateTime.Now;
uye.Status_ = true;
db.User_Details.Add(uye);
db.SaveChanges();
return(View());
}
public void MAptoModel(User user, User_Details details)
{
user.First_Name = First_Name;
user.Last_Name = Last_Name;
details.Secondary_Email = SecondaryEmail;
//details.Profile_Img = ProfileImage;
details.Phone_No = Phone;
details.Phone_No_Country_Code = Phonecode;
}
public ActionResult SignUp(User_Details model)
{
using (var context = new RailwayReservationSystemEntities1())
{
context.User_Details.Add(model);
context.SaveChanges();
}
return(RedirectToAction("login"));
}
public user_details getUser(int u)
{
User_Details ud = db.Users.Find(u);
return(new user_details()
{
name = ud.name,
Email = ud.Email,
Password = ud.Password
});
}
protected void CreateUserWizard1_CreatedUser1(object sender, EventArgs e)
{
var user = Membership.GetUser((sender as CreateUserWizard).UserName).ProviderUserKey;
Guid userId = (Guid)user;
AppManager userActions = new AppManager();
User_Details user_Details = new User_Details();
user_Details.Id = userId;
userActions.userDetails.Add(user_Details);
}
public async Task <ActionResult> Create(User_Details u)
{
RegistrationBL reg = new RegistrationBL();
string student = JsonConvert.SerializeObject(u);
string result = await reg.Register(student);
if (result == "true")
{
return(RedirectToAction("Index", "Home"));
}
return(View());
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
Guid newuserid = Guid.Parse(Request.QueryString["userid"].ToString());
InternshipProgramEntities ipe = new InternshipProgramEntities();
User_Details us = new User_Details();
us.First_Name = fname.Text;
us.Last_Name = lname.Text;
us.DoB = DateTime.Parse(dob1.Text);
us.UserID = newuserid;
ipe.AddToUser_Details(us);
ipe.SaveChanges();
Response.Redirect("/index.aspx");
}
public void bilgisayari_varmi()
{
User_Details temp_ = Session["User_Details"] as User_Details;
List <PC_Details> temp_pc = db.PC_Details.Where(x => x.User_Id == temp_.id).ToList();
if (temp_pc.Count == 0)
{
Session["bilgisayari_varmi"] = 0;
}
else
{
Session["bilgisayari_varmi"] = 1;
Session["PC_Detail"] = temp_pc;
}
}
public HttpResponseMessage RegisterUser([FromBody] RegisterExternalBindingModel newUser)
{
try
{
using (BloggerAppDBEntities entities = new BloggerAppDBEntities())
{
var id_string = Convert.ToString(newUser.id);
int UID = new int();
var alreadyRegistered = entities.Oauth_info.FirstOrDefault(d => d.oAuthID == id_string);
if (alreadyRegistered == null)
{
var userToAdd = new User_Details();
var authInfo = new Oauth_info();
userToAdd.UserName = newUser.UserName;
userToAdd.EMAIL = newUser.email;
userToAdd.PWD = "0";
entities.User_Details.Add(userToAdd);
entities.SaveChanges();
var externalUser = entities.User_Details.FirstOrDefault(d => d.UserName == newUser.UserName);
UID = externalUser.UID;
authInfo.oAuthID = Convert.ToString(newUser.id);
authInfo.UID = UID;
entities.Oauth_info.Add(authInfo);
entities.SaveChanges();
}
else
{
var externalUser = entities.User_Details.FirstOrDefault(d => d.UserName == newUser.UserName);
UID = externalUser.UID;
}
JObject token = GenerateLocalAccessTokenResponse(newUser.UserName, UID);
var message = Request.CreateResponse(HttpStatusCode.Created, token);
message.Headers.Location = new Uri(Request.RequestUri + newUser.UserName.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public int Login(string email, string pass)
{
try
{
User_Details u = db.Users.FirstOrDefault(x => x.Email == email && x.Password == pass);
if (u == null)
{
return(-1);
}
return(u.Id);
}
catch (Exception e)
{
Console.WriteLine(e);
return(-1);
}
}
public int Post([FromBody] User_Details ud)
{
try
{
db.User_Details.Add(ud);
var res = db.SaveChanges();
if (res > 0)
{
return(ud.Acc_No);
}
}
catch (Exception e)
{
throw e;
}
return(0);
}
public int Insert(User_Details u_det)
{
UsersDAL UDAL = new UsersDAL();
try
{
return(UDAL.Insert(u_det));
}
catch (Exception)
{
throw;
}
finally
{
UDAL = null;
}
}
public void Find_UID(User_Details u_id)
{
UsersDAL UDAL = new UsersDAL();
try
{
UDAL.Find_UID(u_id);
}
catch (Exception)
{
throw;
}
finally
{
UDAL = null;
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (userDetailsBindingSource.Current != null)
{
User_Details u = new User_Details();
u = userDetailsBindingSource.Current as User_Details;
if (u.User_Type != 1)
{
if (MessageBox.Show("Are you sure ?", "Message", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
cmd.User_Details.Remove(userDetailsBindingSource.Current as User_Details);
userDetailsBindingSource.RemoveCurrent();
cmd.SaveChanges();
}
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (salesmanDetailsBindingSource.Current != null)
{
if (MessageBox.Show("Are you sure ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int id = ((Salesman_Details)salesmanDetailsBindingSource.Current).Sal_ID;
cmd.Salesman_Details.Remove(salesmanDetailsBindingSource.Current as Salesman_Details);
salesmanDetailsBindingSource.RemoveCurrent();
cmd.SaveChanges();
User_Details u = new User_Details();
u = cmd.User_Details.First(x => x.U_ID == id);
cmd.User_Details.Remove(u);
cmd.SaveChanges();
}
}
}
public List <files> Fetch_All_Files(int u)
{
User_Details fl = db.Users.Include("files").FirstOrDefault(x => x.Id == u);
List <files> list = new List <files>();
foreach (Files j in fl.files)
{
list.Add(new files()
{
Id = j.Id,
Name = j.name,
Extention = j.extention,
d = null
});
}
return(list);
}
public void MaptoModel(User user, User_Details details)
{
user.First_Name = FirstName;
user.Last_Name = LastName;
user.Email = Email;
details.DOB = DOB;
details.Gender = Gender;
details.Phone_No_Country_Code = CountryCode;
details.Phone_No = Phone;
//details.Profile_Img = ProfilePicture;
details.Address_Line1 = Address1;
details.Address_Line2 = Address2;
details.City = City;
details.State = State;
details.ZipCode = Zipcode;
details.Country_Id = Country;
details.College = College;
details.University = University;
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (managerdetailsBindingSource.Current != null)
{
if (MessageBox.Show("Are you sure ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int id = ((Manager_details)managerdetailsBindingSource.Current).MId;
cmd.Manager_details.Remove(managerdetailsBindingSource.Current as Manager_details);
managerdetailsBindingSource.RemoveCurrent();
cmd.SaveChanges();
//MessageBox.Show(id.ToString());
User_Details u = new User_Details();
u = cmd.User_Details.First(x => x.U_ID == id);
cmd.User_Details.Remove(u);
cmd.SaveChanges();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Roles.IsUserInRole("admin"))
{
Response.Write("<script>alert('You dont have permission')</script>");
Response.Redirect("./index.aspx");
}
InternshipProgramEntities ipe = new InternshipProgramEntities();
Education c = ipe.Educations.ToList().Where(x => x.InternID == int.Parse(Request.QueryString["id"].ToString())).First();
User_Details ud = ipe.User_Details.ToList().Where(x => x.Id == c.Supervisor).First();
Department dpa = ipe.Departments.ToList().Where(x => x.DepID == c.Deptmnt).First();
sup.InnerHtml = ud.First_Name.ToString() + ud.Last_Name.ToString();
dp.InnerHtml = dpa.DepName;
jd.InnerHtml = c.JoinDate.ToString();
ed.InnerHtml = c.EndDate.ToString();
mjr.InnerHtml = c.Major.ToString();
cv.HRef = c.CV;
dgr.HRef = c.Degree;
gc.HRef = c.GradCert;
}
public bool UpdateUserDetails(AccountDetails userDetails)
{
Account account = new Account();
using (AccountMgtDBEntities dbContext = new AccountMgtDBEntities())
{
User_Details user_Details = new User_Details();
var userAccount = dbContext.User_Account.Where(x => x.Id == userDetails.UserId).FirstOrDefault();
if (userAccount != null)
{
if (userAccount.User_Details.Count() <= 0)
{
user_Details.Id = Guid.NewGuid();
user_Details.User_Id = (Guid)userDetails.UserId;
user_Details.FirstName = userDetails.FirstName;
user_Details.LastName = userDetails.LastName;
user_Details.MiddleName = userDetails.MiddleName;
user_Details.companyName = userDetails.CompanyName;
user_Details.Phone = userDetails.Phone;
user_Details.Zip = userDetails.zip;
dbContext.User_Details.Add(user_Details);
dbContext.SaveChanges();
return(true);
}
else
{
var userDetail = dbContext.User_Details.Where(x => x.User_Id == userAccount.Id).FirstOrDefault();
userDetail.FirstName = userDetails.FirstName;
userDetail.LastName = userDetails.LastName;
userDetail.MiddleName = userDetails.MiddleName;
userDetail.companyName = userDetails.CompanyName;
userDetail.Phone = userDetails.Phone;
userDetail.Zip = userDetails.zip;
dbContext.SaveChanges();
return(true);
}
}
}
return(false);
}
public string ayarKontrol(string username, string password, string hardware_id)
{
User_Details User_Detailss = db.User_Details.Where(x => x.User_Name == username && x.User_Pass == password).FirstOrDefault();
if (User_Detailss != null)
{
PC_Details PC_DetailsS = db.PC_Details.Where(x => x.Hardware_Id == hardware_id).FirstOrDefault();
if (PC_DetailsS != null)
{
return("AyarAc");
}
else
{
return("PcEslesmedi");
}
}
else
{
//bulunamadı
return("Bulunamadi");
}
}
