public List <Chasier> SelectEmployees() { List <Chasier> chasiers = new List <Chasier>(); try { connection.Open(); } catch (SqlException sqle) { Console.WriteLine("Connection error"); } SqlCommand command = new SqlCommand("select * from dbo.ChasierSystem", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Chasier chasier = new Chasier(); chasier.Id_Item = int.Parse(reader["id_item"].ToString()); chasier.Nama_Item = reader["nama_item"].ToString(); chasier.Kode_Item = reader["kode_item"].ToString(); chasier.Harga_Item = int.Parse(reader["harga_item"].ToString()); chasiers.Add(chasier); } connection.Close(); return(chasiers); }
public void Register(Chasier chasier) { connection.Open(); string cekUser = "******" + chasier.Email + "' "; SqlCommand command = new SqlCommand(cekUser, connection); int jumlah = int.Parse(command.ExecuteScalar().ToString()); connection.Close(); if (jumlah != 0) { } else { try { connection.Open(); string insert = "insert into dbo.userlogin VALUES(@Fname,@email,@password,@gender)"; SqlCommand queryInsert = new SqlCommand(insert, connection); queryInsert.Parameters.AddWithValue("@Fname", chasier.Fname); queryInsert.Parameters.AddWithValue("@email", chasier.Email); queryInsert.Parameters.AddWithValue("@password", chasier.Password); queryInsert.Parameters.AddWithValue("@gender", chasier.Gender); queryInsert.ExecuteNonQuery(); }catch (Exception e) { Console.WriteLine(e.Message); } connection.Close(); } }
public void CalEmail(Chasier chasier) { connection.Open(); string cekUser = "******" + chasier.Email + "' "; SqlCommand command = new SqlCommand(cekUser, connection); int jumlah = int.Parse(command.ExecuteScalar().ToString()); chasier.TotalEmail = jumlah; connection.Close(); }
public void Encrypt(Chasier chasier) { using (MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider()) { UTF8Encoding utf8 = new UTF8Encoding(); byte[] data = md5.ComputeHash(utf8.GetBytes(chasier.Password)); chasier.EncryptPass = Convert.ToBase64String(data); //return Convert.ToBase64String(data); } }
public void InsertEmployee(Chasier chasier) { try { connection.Open(); SqlCommand command = new SqlCommand("insert into dbo.ChasierSystem(nama_item, kode_item, harga_item) values(@firstName, @lastName, @email)", connection); command.Parameters.AddWithValue("@firstName", chasier.Nama_Item); command.Parameters.AddWithValue("@lastName", chasier.Kode_Item); command.Parameters.AddWithValue("@email", chasier.Harga_Item); command.ExecuteNonQuery(); Console.WriteLine("Insert success with employee_id {0}", chasier.Id_Item); } catch (Exception e) { Console.WriteLine(e.Message); } connection.Close(); }
public void Login(Chasier chasier) { //string decryptPass = Encrypt(chasier); try { connection.Open(); string cekPass = "******" + chasier.Email + "'"; SqlCommand command = new SqlCommand(cekPass, connection); string password = Convert.ToString(command.ExecuteScalar().ToString()); connection.Close(); if (password == chasier.EncryptPass) { chasier.CekPassword = true; } else if (password != chasier.Password) { chasier.CekPassword = false; } }catch (Exception e) { Console.Write(e.Message); } }