/// <summary>
 /// Thêm đối tượng Contact
 /// </summary>
 /// <param name="obj"></param>
 /// <returns></returns>
 public bool Add(OContact obj)
 {
     SqlParameter[] sqlPara = new SqlParameter[13];
     sqlPara[0]        = new SqlParameter("@ContactName", SqlDbType.NVarChar);
     sqlPara[0].Value  = obj.ContactName;
     sqlPara[1]        = new SqlParameter("@FullName", SqlDbType.NVarChar);
     sqlPara[1].Value  = obj.FullName;
     sqlPara[2]        = new SqlParameter("@Phone", SqlDbType.VarChar);
     sqlPara[2].Value  = obj.Phone;
     sqlPara[3]        = new SqlParameter("@Tel", SqlDbType.VarChar);
     sqlPara[3].Value  = obj.Tel;
     sqlPara[4]        = new SqlParameter("@BirthDay", SqlDbType.DateTime);
     sqlPara[4].Value  = obj.BirthDay;
     sqlPara[5]        = new SqlParameter("@Gender", SqlDbType.NVarChar);
     sqlPara[5].Value  = obj.Gender;
     sqlPara[6]        = new SqlParameter("@Job", SqlDbType.NVarChar);
     sqlPara[6].Value  = obj.Job;
     sqlPara[7]        = new SqlParameter("@Address", SqlDbType.NVarChar);
     sqlPara[7].Value  = obj.Address;
     sqlPara[8]        = new SqlParameter("@IDContactGroup", SqlDbType.Int);
     sqlPara[8].Value  = obj.IDContactGroup;
     sqlPara[9]        = new SqlParameter("@IDUser", SqlDbType.Int);
     sqlPara[9].Value  = obj.IDUser;
     sqlPara[10]       = new SqlParameter("@TitleName", SqlDbType.NVarChar);
     sqlPara[10].Value = obj.TitleName;
     sqlPara[11]       = new SqlParameter("@Email", SqlDbType.VarChar);
     sqlPara[11].Value = obj.Email;
     sqlPara[12]       = new SqlParameter("@Other", SqlDbType.NVarChar);
     sqlPara[12].Value = obj.Other;
     return(RunProcudure("sp_tblContact_add", sqlPara));
 }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            CultureInfo culture     = new CultureInfo("fr-FR", true);
            BContact    BobjContact = new BContact();
            OContact    objContact  = new OContact();

            objContact.ContactName    = "";
            objContact.TitleName      = ddlXungDanh.SelectedValue.ToString();
            objContact.FullName       = txtFullName.Text;
            objContact.Phone          = txtPhone.Text;
            objContact.Tel            = txtTel.Text;
            objContact.Email          = txtEmail.Text;
            objContact.BirthDay       = DateTime.Parse(txtBirthDay.Text, culture, DateTimeStyles.NoCurrentDateDefault);
            objContact.Gender         = ddlGender.SelectedValue.ToString();
            objContact.Job            = txtJob.Text;
            objContact.Address        = txtAddress.Text;
            objContact.Other          = txtOther.Text;
            objContact.IDContactGroup = int.Parse(ddlContactGroup.SelectedValue.ToString());
            objContact.IDUser         = Global.UserInfo.UserID;//Lấy IDUser sau

            if (BobjContact.Add(objContact))
            {
                lblThongBao.Text = "BẠN ĐÃ THÊM DANH BẠ THÀNH CÔNG!";
            }
        }
        protected void Infomation_Load()
        {
            int ContactID = int.Parse(Request.QueryString["ID"].ToString());
            int UserID    = Global.UserInfo.UserID;

            BContact Bobj = new BContact();
            OContact obj  = new OContact();

            obj = Bobj.Get(ContactID, UserID).First();

            txtFullName.Text = obj.FullName;
            txtBirthDay.Text = obj.BirthDay.ToString("dd/MM/yyyy");
            txtAddress.Text  = obj.Address;
            txtEmail.Text    = obj.Email;
            txtJob.Text      = obj.Job;
            txtOther.Text    = obj.Other;
            txtPhone.Text    = obj.Phone;
            txtTel.Text      = obj.Tel;

            ddlContactGroup.SelectedValue = obj.IDContactGroup.ToString();
            ddlGender.SelectedValue       = obj.Gender;
            ddlXungDanh.SelectedValue     = obj.TitleName;
        }