protected void btnSaveEmail_OnClick(object sender, EventArgs e) { this.lblmsgEmail.Text = ""; if (this.extddlLawFirm.Text != "NA") { if (this.txtEmailAddress.Text != "") { DataSet set = new DataSet(); string str = ConfigurationManager.AppSettings["Connection_String"]; SQLToDAO odao = new SQLToDAO(str); FileTransferEmailNotifications_DAO s_dao = new FileTransferEmailNotifications_DAO(); s_dao.sz_company_id = this.txtCompanyID.Text; s_dao.sz_law_firm_company_id = this.extddlLawFirm.Text; s_dao.sz_user_id = ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID; s_dao.sz_email = this.txtEmailAddress.Text; s_dao.i_flag = 0; set = odao.LoadDataSet("SP_MANAGE_FILE_TRANSFER_NOTIFICATIONS", "mbs.dao.FileTransferEmailNotifications_DAO", s_dao, "mbs.dao"); if ((set.Tables.Count >= 1) && (set.Tables[0].Rows.Count >= 1)) { this.txtEmailAddress.Text = set.Tables[0].Rows[0][0].ToString(); } this.lblmsgEmail.Text = "Record Inserted Successfully"; } else { this.lblmsgEmail.Text = "Please Enter Email Address"; } } else { this.lblmsgEmail.Text = "Please Select LawFirm"; } }
protected void OnextendDropDown_SelectedIndexChanged(object sender, EventArgs e) { this.lblmsgEmail.Text = ""; this.txtEmailAddress.Text = ""; DataSet set = new DataSet(); string str = ConfigurationManager.AppSettings["Connection_String"]; SQLToDAO odao = new SQLToDAO(str); FileTransferEmailNotifications_DAO s_dao = new FileTransferEmailNotifications_DAO(); s_dao.sz_company_id = this.txtCompanyID.Text; s_dao.sz_law_firm_company_id = this.extddlLawFirm.Text; s_dao.i_flag = 1; set = odao.LoadDataSet("SP_MANAGE_FILE_TRANSFER_NOTIFICATIONS", "mbs.dao.FileTransferEmailNotifications_DAO", s_dao, "mbs.dao"); if ((set.Tables.Count >= 1) && (set.Tables[0].Rows.Count >= 1)) { this.txtEmailAddress.Text = set.Tables[0].Rows[0][0].ToString(); } }