コード例 #1
0
 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";
     }
 }
コード例 #2
0
    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();
        }
    }