public ChiTietTaiKhoanSmsMODEL getChiTietTaiKhoanSMSByID(int id) { ChiTietTaiKhoanSmsMODEL chiTietTaiKhoanModel = new ChiTietTaiKhoanSmsMODEL(); //String sql = ConfigurationManager.AppSettings["sql.getChiTietTaiKhoanSMSByID"]; //SqlCommand objCommand = new SqlCommand(sql); //objCommand.Parameters.AddWithValue("@id", id); //DataTable result = DataUtil.executeQuery(objCommand); SqlParameter[] parameter = new SqlParameter[1]; int i = 0; parameter[i] = new SqlParameter("Ma_tai_khoan_SMS", SqlDbType.NVarChar); parameter[i++].Value = id; DataTable result = DataUtil.executeStore("sp_getChiTietTaiKhoanSMSByID", parameter); foreach (DataRow row in result.Rows) { chiTietTaiKhoanModel.Id = row["ID"].ToString(); chiTietTaiKhoanModel.Ma_Tai_Khoan_Sms = row["Ma_tai_khoan_SMS"].ToString(); chiTietTaiKhoanModel.Dang_Ki_Thang = row["Dang_ky_thang"].ToString(); chiTietTaiKhoanModel.Dang_Ki_Nam = row["Dang_ky_nam"].ToString(); chiTietTaiKhoanModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString(); chiTietTaiKhoanModel.User11 = row["User1"].ToString(); chiTietTaiKhoanModel.User21 = row["User2"].ToString(); chiTietTaiKhoanModel.User31 = row["User3"].ToString(); chiTietTaiKhoanModel.User41 = row["User4"].ToString(); chiTietTaiKhoanModel.User51 = row["User5"].ToString(); } return(chiTietTaiKhoanModel); }
public Boolean updateChiTietTaiKhoanSMS(ChiTietTaiKhoanSmsMODEL chiTietTaiKhoanSMSModel) { try { SqlParameter[] parameter = new SqlParameter[10]; int i = 0; parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar); parameter[i++].Value = chiTietTaiKhoanSMSModel.Id; parameter[i] = new SqlParameter("Ma_tai_khoan_sms", SqlDbType.NVarChar); parameter[i++].Value = chiTietTaiKhoanSMSModel.Ma_Tai_Khoan_Sms; parameter[i] = new SqlParameter("Dang_ky_thang", SqlDbType.NVarChar); parameter[i++].Value = chiTietTaiKhoanSMSModel.Dang_Ki_Thang; parameter[i] = new SqlParameter("Dang_ky_nam", SqlDbType.NVarChar); parameter[i++].Value = chiTietTaiKhoanSMSModel.Dang_Ki_Nam; parameter[i] = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User1", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User2", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User3", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User4", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User5", SqlDbType.NVarChar); parameter[i++].Value = ""; Boolean kq = DataUtil.executeNonStore("sp_SMS_UpdateChiTietTaiKhoanByID", parameter); return(kq); } catch (Exception) { throw; } }
private void but_Edit_Click(object sender, EventArgs e) { if (common.Constants.idDetail.Equals("")) { MessageBox.Show("Bạn chưa chọn dòng để cập nhật. Vui lòng chọn lại: "); } else { pnl_Add.Visible = true; lb_tilte.Text = "Cập Nhật Thông Tin TK"; but_Ok.Text = "Cập Nhật"; ctTaiKhoanSMSModel = ctTaiKhoanSMSDao.getChiTietTaiKhoanSMSByID(Convert.ToInt32(common.Constants.idDetail)); txt_RegistrationMonth.Text = ctTaiKhoanSMSModel.Dang_Ki_Thang; txt_Registrationyear.Text = ctTaiKhoanSMSModel.Dang_Ki_Nam; common.Constants.idDetail = ""; common.Constants.chooseUpdate = 1; lblYouChoose.Text = "Bạn chọn dòng: "; but_Delete.Enabled = false; but_Edit.Enabled = false; } }