Esempio n. 1
0
 public DataSet SelectNewVillage(string DistrictId, ChkUser chk)
 {
     try
     {
         dataset = new DataSet();
         if (connection != null && chk.username == "PPMS_02112012" && chk.password == "16112012")
         {
             connection.Open();
             command = new SqlCommand();
             //string qry = "select * from VillageMaster where District_Id='" + DistrictId + "' and Tehsil_ID='" + TehsilId + "' ";
             string qry = "select * from VillageMaster where District_Id='" + DistrictId + "' and VILLAGE_STATUS='N' ";
             command.CommandText = qry;
             command.Connection  = connection;
             SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
             dataAdapter.Fill(dataset);
             command.Dispose();
         }
     }
     catch (Exception)
     {
         connection.Close();
     }
     finally
     {
         connection.Close();
     }
     return(dataset);
 }
Esempio n. 2
0
    public bool chkInformation(ChkUser userpwd)
    {
        bool rtev = false;

        if (userpwd != null)
        {
            //change on 16112012
            //if (userpwd.username == "paddyservice30" && userpwd.password == "paddy2012")
            if (userpwd.username == "16112012" && userpwd.password == "16112012")
            {
                rtev = true;
                return(rtev);
            }
        }
        else
        {
            return(rtev);
        }

        return(rtev);
    }
Esempio n. 3
0
    public void InsertRunnerLog(string societyID, ChkUser userpwd)
    {
        try
        {
            if (connection != null && userpwd.username == "16112012" && userpwd.password == "16112012")
            {
                connection.Open();
                string date          = getDate_MDY(System.DateTime.Now.ToShortTimeString());
                string LogID         = societyID.ToString() + date;
                string LogIP         = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"].ToString();
                string LogDate       = "";
                string Pc_Id         = societyID.ToString();
                string District_Code = societyID.Substring(0, 4);
                string Society_Id    = societyID.ToString();
                string RunnerID      = societyID.ToString();
                string Status        = "YES";
                string RunnerVer     = "3.0";


                command = new SqlCommand();
                string qry = "Insert Into RunnerLog(LogID,LogIP,LogDate,Pc_Id,District_Code,Society_Id,RunnerID,Status,RunnerVer)";
                qry += " values('" + LogID + "','" + LogIP + "',getDate(),'" + Pc_Id + "','" + District_Code + "','" + Society_Id + "','" + RunnerID + "','" + Status + "','" + RunnerVer + "')";
                command.CommandText = qry;
                command.Connection  = connection;
                int ret = command.ExecuteNonQuery();
            }
        }
        catch (Exception)
        {
            connection.Close();
        }
        finally
        {
            connection.Close();
        }
    }