Ejemplo n.º 1
0
        private void btnSend_Click(object sender, EventArgs e)
        {
            SMS sm = new SMS(cboPorts.Text);

            sm.Opens();
            sm.sendSMS(txtPhone.Text, txtMessage.Text);
            sm.Closes();
            MessageBox.Show("Message Sent!");
            //sendmessagetomobile();
        }
Ejemplo n.º 2
0
        private void btnSendSmsList_Click(object sender, EventArgs e)
        {
            GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
            ArrayList arQuery = new ArrayList();
            //GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection("GTRHRIS");
            string sqlQuery = "";
            Int32  NewId    = 0;

            try
            {
                SMS sm = new SMS(cboPorts.Text);
                sm.Opens();
                int count = 0;
                foreach (UltraGridRow row in gridList.Rows)
                {
                    if ((Int16.Parse(row.Cells["isChecked"].Value.ToString()) == 1) && (Int16.Parse(row.Cells["Mobileno"].Text.Length.ToString()) > 10) && (Int16.Parse(row.Cells["Mobileno"].Text.Length.ToString()) < 15) && (Int16.Parse(row.Cells["Remarks"].Text.Length.ToString()) > 0))
                    {
                        row.Appearance.BackColor       = Color.Coral;
                        row.Cells["Sending_Sts"].Value = "Running";
                        row.Cells["Sending_Sts"].Refresh();
                        gridList.Refresh();

                        //sqlQuery = "Exec prcDBBackup '" + row.Cells["SLNo"].Value + "','','','" + Common.Classes.clsMain.intUserId + "'";
                        //clsCon.GTRSaveDataWithSQLCommand(sqlQuery);

                        sm.sendSMS(row.Cells["MobileNo"].Text.ToString(), row.Cells["empname"].Text.ToString() + " - " + row.Cells["status"].Text.ToString() + " - " + row.Cells["Remarks"].Text.ToString());

                        row.Appearance.BackColor       = Color.BlanchedAlmond;
                        row.Cells["Sending_Sts"].Value = "Complete";
                        row.Cells["Sending_Sts"].Refresh();
                        gridList.Refresh();

                        count = count + 1;

                        //SMS Insert
                        //NewId
                        //sqlQuery = "Select Isnull(Max(EmpId),0)+1 As NewId from tblEmp_Info";
                        //NewId = clsCon.GTRCountingData(sqlQuery);

                        sqlQuery = "Insert Into tblsms_send (ComId, empId, emp_Code, dtSent,tmSent, sendSMS, aId, PCName)"
                                   + " Values (" + Common.Classes.clsMain.intComId + ", '" +
                                   row.Cells["empId"].Value.ToString() + "', '" + row.Cells["emp_Code"] + "', '" +
                                   row.Cells["dtSent"] + "', '" + row.Cells["tmSent"] + "', '" + row.Cells["sendSMS"] +
                                   "', " + NewId + ", " + Common.Classes.clsMain.intUserId + "' ";
                        arQuery.Add(sqlQuery);
                    }
                }

                sm.Closes();

                MessageBox.Show("Message Sent !  " + count + " ");

                //MessageBox.Show("AT+CMGF=1" + (char)(13));


                //        dbName = dbName.Substring(0, dbName.Length - 1);

                // MessageBox.Show("Data backup SuccessFully");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                clsCon = null;
            }
        }