public ActionResult Delete(TwitterClone.Models.Person objItem) { //SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConString"]); //SqlCommand cmd = new SqlCommand(); //string Query = @"Update person set active=0 where user_id = @user_Id"; //cmd = new SqlCommand(Query, con); //cmd.Parameters.AddWithValue("@user_Id", objItem.user_id); //con.Open(); //cmd.ExecuteNonQuery(); //con.Close(); testEntities dbPersonEntity = new testEntities(); var empQuery = from person in dbPersonEntity.People where person.user_Id == objItem.user_id select person; Person objPerson = empQuery.Single(); objPerson.user_Id = objItem.user_id; objPerson.active = false; dbPersonEntity.SaveChanges(); return(View("TweetsView")); }
public ActionResult create(TwitterClone.Models.Person objItem) { MD5CryptoServiceProvider md5hasher = new MD5CryptoServiceProvider(); UTF8Encoding encoder = new UTF8Encoding(); string strPassWrodEnc = md5hasher.ComputeHash(encoder.GetBytes(objItem.password)).ToString(); // SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConString"]); // SqlCommand cmd = new SqlCommand(); // string Query = @"INSERT INTO Person (user_Id ,Password ,fullName, email, joined, active ) // Values(@user_Id ,@Password ,@fullName, @email, @joined, @active)"; // cmd = new SqlCommand(Query, con); // cmd.Parameters.AddWithValue("@user_Id", objItem.user_id); // cmd.Parameters.AddWithValue("@Password", strPassWrodEnc); // cmd.Parameters.AddWithValue("@fullName", objItem.fullName); // cmd.Parameters.AddWithValue("@email", objItem.email); // cmd.Parameters.AddWithValue("@joined", DateTime.Now.ToString()); // cmd.Parameters.AddWithValue("@active", 1); // con.Open(); // cmd.ExecuteNonQuery(); // con.Close(); testEntities dbPersonEntity = new testEntities(); Person objPerson = new Person(); objPerson.user_Id = objItem.user_id; objPerson.Password = strPassWrodEnc; objPerson.fullName = objItem.fullName; objPerson.email = objItem.email; objPerson.joined = DateTime.Now; objPerson.active = true; dbPersonEntity.People.Add(objPerson); dbPersonEntity.SaveChanges(); return(View("SignUpview")); }
public ActionResult Edit(TwitterClone.Models.Person objItem) { MD5CryptoServiceProvider md5hasher = new MD5CryptoServiceProvider(); UTF8Encoding encoder = new UTF8Encoding(); string strPassWrodEnc = md5hasher.ComputeHash(encoder.GetBytes(objItem.password)).ToString(); //SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConString"]); //SqlCommand cmd = new SqlCommand(); //string Query = @"Update person set password=@Password, fullName=@fullName, email=@email where user_id = @user_Id"; //cmd = new SqlCommand(Query, con); //cmd.Parameters.AddWithValue("@user_Id", objItem.user_id); //cmd.Parameters.AddWithValue("@Password", strPassWrodEnc); //cmd.Parameters.AddWithValue("@fullName", objItem.fullName); //cmd.Parameters.AddWithValue("@email", objItem.email); //con.Open(); //cmd.ExecuteNonQuery(); //con.Close(); testEntities dbPersonEntity = new testEntities(); var empQuery = from person in dbPersonEntity.People where person.user_Id == objItem.user_id select person; Person objPerson = empQuery.Single(); objPerson.user_Id = objItem.user_id; objPerson.Password = strPassWrodEnc; objPerson.fullName = objItem.fullName; objPerson.email = objItem.email; dbPersonEntity.SaveChanges(); return(View("SignUpview")); }