Error 1053: Please give the solution for the following code

Question

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.ServiceProcess;
using System.Text;
using System.Net.Mail;
using System.Net;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Threading;
namespace ServiceCIS
{
    public partial class Service1 : ServiceBase
    {
        private String MotherFirstName = null;
        private string FatherFirstName = null;
        private string MotherEmailId = null;
        private string FatherEmailId = null;
        private string SampleCode = null;
        private string CustomerCode = null;
        private int DueAmount = 0;
        private int InvoiceAmount = 0;
        private String Date_BeforeOneMonth;
        private DateTime DDate_BeforeOneMonth;
        private String Date_BeforeOneWeek;
        private DateTime DDate_BeforeOneWeek;
        private String Date_DueDate;
        private string Date_OTPBOW;
        private DateTime Ddate;
        private string PaymentStatus = null;
        private string Mgr_EmailId = null;
        private Boolean Flag_BeforeOneMonth;
        private Boolean Flag_BeforeOneWeek;
        private Boolean Flag_OnDueDate;
        private String CurrentDate = DateTime.Today.ToShortDateString();
        private DateTime CDate = DateTime.Today.Date;
        private DateTime Date_OTPBOWD;
        private string InvoiceType = null;
        private string date1;
        private string date2;
        private DateTime Date_ODRBOW;
        private DateTime Date_OverDueReminder;
        private DateTime DateOfTermination;
        private string StringDateOfTermination;
        private Boolean Flag_TOS;
        private string CustomerStatus;
        private DateTime Date_RenewalOfTerm;
        private string Accounant_Email_IAF;
        private DateTime InvoiceAlertDate_IAF;
        private string PaymentStatus_IAF;
        private string SampleCode_IAF;
        private string SampleCode_PDCAlert = null;
        private int Chequeno_PDCAlert;
        private int ChequeAmount_PDCAlert;
        private string ChequeStatus_PDCAlert = null;
        private string Reason_PDCAlert = null;
        private string MotherName_PDCAlert = null;
        private string FatherName_PDCAlert = null;
        private string MotherEmailId_PDCAlert = null;
        private string FatherEmailId_PDCAlert = null;
        private DateTime ChequeDate_PDCAlert;
        private DateTime Cheque_Date_BOD_PDCAlert;
        private string Cheque_BankName_PDCAlert = null;
        private string Accountant_EmailId_PDCAlert = null;
        private bool Flag_Clearance;
        private bool Flag_Honoured;
        private bool Flag_Dishonoured;
             
          
        Service1 obj = new Service1();     
          
        public static DataTable Execute(String strsql)
        {
            SqlConnection obj = new SqlConnection("Data Source=.;initial catalog=Db_CIS1;Integrated Security=True");
            SqlDataAdapter sda = new SqlDataAdapter(strsql, obj);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;
        }
        public static  void Update(string strsql)
        {
            SqlConnection obj = new SqlConnection("Data Source=.;Initial Catalog=Db_CIS1;Integrated Security=True");
            SqlDataAdapter sda = new SqlDataAdapter(strsql, obj);
            DataSet ds = new DataSet();
            sda.Fill(ds);
         }
        
        public  void SendEmail_InvoiceAlert_Accountant(string Message)
        {
            MailMessage mail = new MailMessage();
            mail.From = new System.Net.Mail.MailAddress("[e-mail]");
            // The important part -- configuring the SMTP client
            SmtpClient smtp = new SmtpClient();
            smtp.Port = 587;   // [1] You can try with 465 also, I always used 587 and got success
            smtp.EnableSsl = true;
            smtp.DeliveryMethod = SmtpDeliveryMethod.Network; // [2] Added this
            smtp.UseDefaultCredentials = false; // [3] Changed this
            smtp.Credentials = new NetworkCredential("[e-mail]", "ssm@cskpl");  // [4] Added this. Note, first parameter is NOT string.
            smtp.Host = "smtp.gmail.com";
            //mail.To.Add(new MailAddress("[e-mail]"));
            mail.To.Add(new MailAddress(Accounant_Email_IAF));
            mail.IsBodyHtml = true;
            mail.Body = Message;
            smtp.Send(mail);
        
        }

        public Service1()
        {
            InitializeComponent();
            if (!System.Diagnostics.EventLog.SourceExists("EmailSource"))
            {
                System.Diagnostics.EventLog.CreateEventSource("EmailSource", "EmailLog");
            }
            eventLogEmail.Source = "EmailSource";
            eventLogEmail.Log = "EmailLog";
        }

        protected override void OnStart(string[] args)
        {
            Thread t = new Thread(new ThreadStart(SomeTask));
        }
        private  void SomeTask()
        {
                         string QueryForInvoiceAlert = "select * from InvoiceAlert_Accountant";
              string QueryForEmailID_Accountant = "select EmailID,EmpFirstName from EmployeeDetails where EmpType='Accountant'";
              DataTable dt2 = Service1.Execute(QueryForInvoiceAlert);
              string test1 = "check date" + CDate;
              System.IO.File.WriteAllText(@"F:\Polyclone\Check1.txt", test1);
              foreach (System.Data.DataRow r in dt2.Rows)
              {
                  InvoiceAlertDate_IAF = Convert.ToDateTime(r["Date_InvoiceAlert"]);
                  string test = "check date" + InvoiceAlertDate_IAF+CDate;
                  System.IO.File.WriteAllText(@"F:\Polyclone\Check2.txt", test);
                  SampleCode_IAF = r["SampleCode"].ToString();
                  if (InvoiceAlertDate_IAF == CDate)
                  {
                      DataTable dt3 = Service1.Execute(QueryForEmailID_Accountant);
                      foreach (System.Data.DataRow row1 in dt3.Rows)
                      {
                          Accounant_Email_IAF = row1["EmailID"].ToString();
                          string Accountant_FirstName = row1["EmpFirstName"].ToString();
                          string st = "<html><body>" +
                          "Date : " + CurrentDate + "</br> REMINDER NOTICE:</br> " +
                          "Dear" +Accountant_FirstName+",</br> Please generate invoice for the sample"+SampleCode_IAF;
                          obj.SendEmail_InvoiceAlert_Accountant(st);
                       
                      }
                  }                
            
              }  
                       }      
        

        protected override void OnStop()
        {
            EventLog.WriteEntry("My Simple Service Stopped");
        }
    }
}

Answer 1

This forum supports .NET Framework setup.

It appears you need help with C# code, so please ask the C# experts here:

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/threads

Answer 2

Hi Sagar_sm90,

I am not sure what you intend to do, but I am guessing you get the "Error 1053: The service did not respond to the start or control request in a timely fashion" and try to solve it, right?

Here is the fix for that, please refer to:

FIX: You receive an "Error 1053: The service did not respond to the start or control request in a timely fashion" error message when you stop or pause a managed Windows service

You receive an "Error 1053: The service did not respond to the start or control request in a timely fashion" error message when a service that uses the local system account tries to start on a Windows Server 2003-based computer

Regards,

---

Lisa Zhu [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

Hi Sagar_sm90,

I provisionally marked my reply as answer.Please  feel  free to unmark it if you think the information does not help.

Thanks for your understanding.

Regards,

---

Lisa Zhu [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.