Example #1
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string cellnumber = txtTo.Text;
        string message = txtComments.Text;
        SerialPort port = new SerialPort();
        clsSMS objclsSMS = new clsSMS();
        string portname =ConfigurationManager.AppSettings["ComPort"];
        string baudrate = "57600";
        port = objclsSMS.OpenPort(portname, baudrate);
        try
        {
            if (objclsSMS.sendMsg(port, portname, "57600", cellnumber, message))
                Label1.Text = "Sms-ul a fost trimis!";
            else
                Label1.Text = "Trimitere esuata!";
            objclsSMS.ClosePort(port);
        }
        catch (Exception ex)
        {
            Label1.Text = ex.Message;
			 objclsSMS.ClosePort(port);
        }
    }
Example #2
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string adresafizicaserver = Server.MapPath("~");
        string cale_rap = Server.MapPath("~/Documents/Sms/");
        string cale_log = Server.MapPath("~/Documents/Sms/");
        string logname = "LogSmsFerme" + DataSelectie.Text.Trim().Replace(@"/", @"_") + ".txt";
        string smsname = "SmsTrimise" + DataSelectie.Text.Trim().Replace(@"/", @"_") + ".txt";
        string fulllogname = adresafizicaserver + @"\Documents\Sms\" + logname;
        string fullsmsname = adresafizicaserver + @"\Documents\Sms\" + smsname;
        DateTime datatestare = DateTime.Parse(DataSelectie.Text);
        MostreDB mostre = new MostreDB();
        List<MostreFabrica> mostresms = MostreFabrica.GetMostreSMS(datatestare);
        SerialPort port = new SerialPort();
        clsSMS objclsSMS = new clsSMS();
        string portname = ConfigurationManager.AppSettings["ComPort"].ToString();
        string baudrate = "9600";
        port = objclsSMS.OpenPort(portname, baudrate);

        StringBuilder updateSql = new StringBuilder("update mostretancuri set SentSms=1 where ");
        int countSms = 0;
        int countError = 0;

        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, "************" + "Data: " + DateTime.Now.ToString() + "**********");
        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, "************" + "Data: " + DateTime.Now.ToString() + "**********");
        int counter = 0;
        foreach (MostreFabrica ms in mostresms)
        {
           // text sms
            //TODO : uncomment !!!
            if (!string.IsNullOrEmpty(ms.TelContact))
            {
                if (ms.FermeNume.Length > 30)
                    ms.FermeNume = ms.FermeNume.Substring(0, 30);
                //  if (string.IsNullOrEmpty(ms.TelContact))
              //  ms.TelContact = "+40722217495";
                StringBuilder sms = new StringBuilder();
         //       sms.Append(ms.FermeNume + " analizele sunt incarcate pe site");
                sms.Append("In " + datatestare + " contul dvs. " + ms.FermeNume + " a fost actualizat cu rezultatele analizelor"); 
                string cellnumber = Regex.Replace(ms.TelContact, @"[\s()-]", "");
                cellnumber = (cellnumber.StartsWith("0") ? "+4"+cellnumber : cellnumber);

                try
                {
                    //todo uncomment
                    bool res = objclsSMS.sendMsg(port, portname, "9600", cellnumber, sms.ToString());
                  //  bool res = true;
                    if (res == true)
                    {
                        string cond = "(FermaID = " + ms.FermeId + " AND DataTestare = CONVERT(date, ''" + datatestare.ToShortDateString() + "', 103))";
                        string strupdate = (countSms > 0) ? " or "+ cond : cond;
                        updateSql.Append(strupdate);
                        countSms++;
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, countSms + ". " + ms.CodFerma + " " + ms.FermeNume + " " + cellnumber + " - " + DateTime.Now.ToString());
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, sms.ToString());
                    }
                    else
                    {
                        countError++;
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, countError + ". " + ms.CodFerma + " " + ms.FermeNume + " " + cellnumber + " - " + DateTime.Now.ToString());
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, sms.ToString());
                    }
                }
                catch (Exception ex)
                {
                      mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname,ex.Message+ " - " + ex.StackTrace);
                }
                counter++;
            }
    
        }
        try
        {
            objclsSMS.ClosePort(port);
        }
        catch { }
        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, "************" + "End Data: " + DateTime.Now + "**********");
        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, "************" + "End Data: " + DateTime.Now + "**********");
        // update moste tancuri set sentsms=1
        SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);

        try
        {
            if (countSms > 0)
            {
                SqlCommand cmd = new SqlCommand(updateSql.ToString(), cnn);
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
            }
        }
        catch (Exception exU)
        {
            Label1.Text = " Update MostreTancuri failed! " + exU.Message;
        }

        fissms.NavigateUrl = HttpContext.Current.Request.ApplicationPath + @"/Documents/Sms/" + smsname;
        fissms.Visible = true;
      
   	    fislog.NavigateUrl  = HttpContext.Current.Request.ApplicationPath + @"/Documents/Sms/"+logname;
        fislog.Visible = true;
    }
Example #3
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string adresafizicaserver = Server.MapPath("~");
        string cale_rap = Server.MapPath("~/Documents/Sms/");
        string cale_log = Server.MapPath("~/Documents/Sms/");

        string logname = "LogSmsFerme" + DataSelectie.Text.Trim().Replace(@"/", @"_") + ".txt";
        string smsname = "SmsTrimise" + DataSelectie.Text.Trim().Replace(@"/", @"_") + ".txt";
        string fulllogname = adresafizicaserver + @"\Documents\Sms\" + logname;
        string fullsmsname = adresafizicaserver + @"\Documents\Sms\" + smsname;
        string datatestare = DataSelectie.Text;
        MostreDB mostre = new MostreDB();
        List<MostreFabrica> mostresms = MostreFabrica.GetMostreSMS(datatestare);
        SerialPort port = new SerialPort();
        clsSMS objclsSMS = new clsSMS();
        string portname = ConfigurationManager.AppSettings["ComPort"].ToString();
        string baudrate = "9600";
        port = objclsSMS.OpenPort(portname, baudrate);

        StringBuilder updateSql = new StringBuilder("update mostretancuri set SentSms=1 where ");
        int countSms = 0;
        int countError = 0;

        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, "************" + "Data: " + DateTime.Now.ToString() + "**********");
        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, "************" + "Data: " + DateTime.Now.ToString() + "**********");
        int counter = 0;
        foreach (MostreFabrica ms in mostresms)
        {
            //create sms string
            // G:99,99;P:9,99;C:9,99;L:9,99;SUN:99,99;pH:9,99;Pct ing:-0,513;
            //Inhib:N;U:99,99;NTG:10000000;NCS:99999999
            // G-grasime; P-proteina; C-cazeina; L-lactoza; SUN- subst. uscata negrasa; 
            //Pct. ing- punct inghet; 
            //Inhib- reziduuri inhibitori ce poate fi P-pozitiv sau N-negativ; U- uree

            //TODO : uncomment !!!
            if (!string.IsNullOrEmpty(ms.TelContact))
            {
                if (ms.FermeNume.Length > 30)
                    ms.FermeNume = ms.FermeNume.Substring(0, 30);
                StringBuilder sms = new StringBuilder();
                sms.Append(ms.FermeNume + ";");
                sms.Append("G:" + ms.Grasime + ";");
                sms.Append("P:" + ms.Proteina + ";");
                sms.Append("C:" + ms.Casein + ";");
                sms.Append("L:" + ms.Lactoza + ";");
                sms.Append("SUN:" + ms.Substu + ";");
                sms.Append("pH:" + ms.Ph + ";");
                sms.Append("Pct.ing.:" + ms.Puncti + ";");
                sms.Append("Inhib:" + ms.Antib + ";");
                sms.Append("U:" + ms.Urea + ";");
                try
                {
                    sms.Append("NTG:" + ms.NTG + "000;");
                }
                catch
                {
                    sms.Append("NTG:>10000000;");
                }
                try
                {
                    sms.Append("NCS:" + ms.NCS + "000;");
                }
                catch
                {
                    sms.Append("NCS:" + ms.NCS + ";");
                }
                sms.Append("Cod:" + ms.CodBare);

                string cellnumber = Regex.Replace(ms.TelContact, @"[\s()-]", "");
                cellnumber = (cellnumber.StartsWith("0") ? "+4" + cellnumber : cellnumber);

                try
                {
                    bool res = objclsSMS.sendMsg(port, portname, "9600", cellnumber, sms.ToString());
                    if (res)
                    {
                        string strupdate = (countSms > 0) ? " or codbare ='" + ms.CodBare + "' " : " codbare ='" + ms.CodBare + "' ";
                        updateSql.Append(strupdate);
                        countSms++;
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, countSms + ". " + ms.CodFerma + " " + ms.FermeNume + " " + cellnumber + " - " + DateTime.Now.ToString());
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, sms.ToString());
                    }
                    else
                    {
                        countError++;
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, countError + ". " + ms.CodFerma + " " + ms.FermeNume + " " + cellnumber + " - " + DateTime.Now.ToString());
                        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, sms.ToString());
                    }
                }
                catch (Exception ex)
                {
                    mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, ex.Message + " - " + ex.StackTrace);
                }
                counter++;
            }
        }
        try
        {
            objclsSMS.ClosePort(port);
        }
        catch { }
        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + logname, "************" + "End Data: " + DateTime.Now.ToString() + "**********");
        mostre.Addtext(adresafizicaserver + @"\Documents\Sms\" + smsname, "************" + "End Data: " + DateTime.Now.ToString() + "**********");
        // update moste tancuri set sentsms=1
        SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);

        try
        {
            if (countSms > 0)
            {
                SqlCommand cmd = new SqlCommand(updateSql.ToString(), cnn);
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
            }
        }
        catch (Exception exU)
        {
            Label1.Text = " Update MostreTancuri failed! " + exU.Message;
        }


        fissms.NavigateUrl = HttpContext.Current.Request.ApplicationPath + @"/Documents/Sms/" + smsname;
        fissms.Visible = true;


        fislog.NavigateUrl = HttpContext.Current.Request.ApplicationPath + @"/Documents/Sms/" + logname;
        fislog.Visible = true;
    }