public FrmChiTietCmnd(Cmnd cmnd) { InitializeComponent(); this.cmnd = cmnd; SetData(); }
public Cmnd Read(string soCmnd) { string query = string.Empty; query += "SELECT TOP 1 * "; query += "FROM [CMND] WHERE [SoCmnd]=@SoCmnd"; Cmnd cd = new Cmnd(); using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@SoCmnd", soCmnd); try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); reader.Read(); cd.Ma = int.Parse(reader["Ma"].ToString()); cd.SoCmnd = reader["SoCmnd"].ToString(); cd.HoTen = reader["HoTen"].ToString(); cd.QueQuan = reader["QueQuan"].ToString(); cd.DiaChiHoKhau = reader["DiaChiHoKhau"].ToString(); cd.DanToc = reader["DanToc"].ToString(); cd.TonGiao = reader["TonGiao"].ToString(); cd.DacDiemNhanDang = reader["DacDiemNhanDang"].ToString(); cd.NoiCap = reader["NoiCap"].ToString(); cd.NguoiCap = reader["NguoiCap"].ToString(); cd.NgaySinh = DateTime.Parse(reader["NgaySinh"].ToString()); cd.NgayCap = DateTime.Parse(reader["NgayCap"].ToString()); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(cd); }
public void input() { Console.WriteLine("Nhap vao thong tin the ATM: "); do { Console.Write("Nhap vao So tai khoan:"); Sotaikhoan = Convert.ToString(Console.ReadLine()); } while (Sotaikhoan == null || Sotaikhoan.Length <= 10); do { Console.Write("\nNhap vao Ten chu the:"); Tenchuthe = Convert.ToString(Console.ReadLine()); //char getenter = Convert.ToChar(Console.ReadKey()); } while (Tenchuthe == null || (Array.TrueForAll(Tenchuthe.ToCharArray(), c => char.IsDigit(c) == true))); DateTime require18 = DateTime.Now; do { Console.Write("\nNhap vao Ngay sinh- Format:MM/dd/yyyy-( Hay dam bao hien tai ban > 18 tuoi):"); Ngaysinh = Convert.ToDateTime(Console.ReadLine()); } while ((require18.Year - Ngaysinh.Year) < 18); do { Console.Write("\nNhap vao CMND( 9 chu so):"); Cmnd = Convert.ToDecimal(Console.ReadLine()); } while ((Cmnd.ToString().Length) < 9); do { Console.Write("\nNhap vao Ngay mo the- Format:MM/dd/yyyy-( Hay dam bao hien tai ban > 18 tuoi):"); Ngaymothe = Convert.ToDateTime(Console.ReadLine()); } while (Ngaymothe.Year < ngaySinh.Year + 18); do { Console.Write("\nNhap vao Thoi han:"); Hansudung = Convert.ToInt32(Console.ReadLine()); } while (Hansudung % 6 != 0); do { Console.Write("\nNhap vao So du( Toi thieu 100.000 VND) :"); Sodu = Convert.ToDecimal(Console.ReadLine()); } while (Sodu < 100000); do { Console.Write("\nNhap vao Ma PIN( 6 chu so):"); Mapin = Convert.ToInt32(Console.ReadLine()); } while ((Mapin.ToString().Length != 6) || Array.TrueForAll(Mapin.ToString().ToCharArray(), c => char.IsDigit(c) == false)); Console.WriteLine("Mo the thanh cong !"); }
private void setCmndCccd() { if (congDan.CoCccd()) { cccd = cccdBUS.Read(congDan.SoCccd); } else { btnXemCccd.Enabled = false; } if (congDan.CoCmnd()) { cmnd = cmndBUS.Read(congDan.SoCmnd); } else { btnXemCmnd.Enabled = false; } }