예제 #1
0
    private void BindGrid()
    {
        DistrictClub dc = new DistrictClub();
        DataTable    dt = new DataTable();

        dt = dc.GetAllClubs();
        if (dt.Rows.Count > 0)
        {
            lblMsg.Visible        = false;
            RadGrid1.Visible      = true;
            RadGrid1.DataSourceID = string.Empty;
            RadGrid1.DataSource   = dt;
            RadGrid1.Rebind();
        }
        else
        {
            lblMsg.Visible   = true;
            RadGrid1.Visible = false;
        }
    }
예제 #2
0
    private void GetClubDetails(int id)
    {
        try
        {
            DistrictClub obj = new DistrictClub();
            obj.Id = id;

            DataTable dt = new DataTable();
            dt = obj.GetClubById();
            if (dt.Rows.Count > 0)
            {
                // Club Details

                lblClubName.Text = dt.Rows[0]["club_name"].ToString();
                lblClubNo.Text   = dt.Rows[0]["ri_club_No"].ToString();

                DateTime chrterdate = DateTime.Parse(dt.Rows[0]["charter_date"].ToString());
                lblCharterDate.Text = chrterdate.ToString("dd-MMMM-yyyy");

                lblMeetingDay.Text = dt.Rows[0]["meeting_day"].ToString();
                // lblMeetingTime.Text = dt.Rows[0]["meeting_time"].ToString();

                try
                {
                    DateTime meetingTime = DateTime.Parse(dt.Rows[0]["meeting_time"].ToString());
                    lblMeetingTime.Text = meetingTime.ToString("hh:mm tt");
                }
                catch
                {
                    lblMeetingTime.Text = "-";
                }


                lblVenue.Text = dt.Rows[0]["venue1"].ToString() + " " + dt.Rows[0]["venue2"].ToString() + " " + dt.Rows[0]["city"].ToString();

                lblDS.Text = dt.Rows[0]["ds"].ToString();
                lblAT.Text = dt.Rows[0]["at"].ToString();
                lblAG.Text = dt.Rows[0]["ag"].ToString();

                lblFlagship.Text = dt.Rows[0]["flagship_text"].ToString();

                string strFlagship = dt.Rows[0]["flagship_image"].ToString();
                if (strFlagship != "")
                {
                    imgFlagship.Visible  = true;
                    imgFlagship.ImageUrl = "../ProjectFlagship/" + strFlagship;
                }
                else
                {
                    imgFlagship.Visible = false;
                }

                DateTime instDate = DateTime.Parse(dt.Rows[0]["installation_date"].ToString());
                lblInstallation.Text = instDate.ToString("dd-MMMM-yyyy");

                DateTime ocvDate = DateTime.Parse(dt.Rows[0]["ocv_date"].ToString());
                lblOcv.Text = ocvDate.ToString("dd-MMMM-yyyy");

                //string gps = dt.Rows[0]["gps_latitude"].ToString();
                //if (gps != "")
                //{
                //    lblGPS.Text = "Latitude : " + dt.Rows[0]["gps_latitude"].ToString() + "    " + "Longitude : " + dt.Rows[0]["gps_longitude"].ToString();
                //}
                //else
                //{
                //    lblGPS.Text = "";
                //}



                //lblInstTime.Text = dt.Rows[0]["installation_time"].ToString();
                //lblInstChiefGuest.Text = dt.Rows[0]["installation_chief_guest"].ToString();
                //lblInstVenue.Text = dt.Rows[0]["installation_venue"].ToString();



                //lblOcvTime.Text = dt.Rows[0]["ocv_time"].ToString();

                //lblTrfStatus.Text = dt.Rows[0]["club_trf_status"].ToString();

                //string strLogo = dt.Rows[0]["club_logo"].ToString();
                //if(strLogo!="")
                //{
                //    imgLogo.Visible = true;
                //    imgLogo.ImageUrl = "../ClubsLogo/" + strLogo;
                //}
                //else
                //{
                //    imgLogo.Visible = false;
                //}


                //string strLocationMap = dt.Rows[0]["location_map"].ToString();
                //if (strLocationMap != "")
                //{
                //    imgMap.Visible = true;
                //    imgMap.ImageUrl = "../ClubsLogo/" + strLocationMap;
                //}
                //else
                //{
                //    imgMap.Visible = false;
                //}
            }
        }
        catch { }
    }
예제 #3
0
    private void GetClub(int id)
    {
        DistrictClub dc = new DistrictClub();
        DataTable    dt = new DataTable();


        dc.Id = id;
        dt    = dc.GetClubById();

        //dc.RiClubNo = id;
        //dt = dc.GetClubByClubId();

        if (dt.Rows.Count > 0)
        {
            ddlDistNo.SelectedItem.Text = dt.Rows[0]["district_no"].ToString();
            txtTitle.Text  = dt.Rows[0]["club_name"].ToString();
            txtClubNo.Text = dt.Rows[0]["ri_club_no"].ToString();
            DDLClubName.SelectedItem.Text = dt.Rows[0]["sponsored_club"].ToString();

            charterDate.SelectedDate = DateTime.Parse(dt.Rows[0]["charter_date"].ToString());
            DDLDay.SelectedItem.Text = dt.Rows[0]["meeting_day"].ToString();
            meetingTime.SelectedDate = DateTime.Parse(dt.Rows[0]["meeting_time"].ToString());

            txtVenue1.Text    = dt.Rows[0]["venue1"].ToString();
            txtVenue2.Text    = dt.Rows[0]["venue2"].ToString();
            txtLandmark.Text  = dt.Rows[0]["landmark"].ToString();
            txtCity.Text      = dt.Rows[0]["city"].ToString();
            txtPin.Text       = dt.Rows[0]["pin"].ToString();
            txtState.Text     = dt.Rows[0]["state"].ToString();
            txtCountry.Text   = dt.Rows[0]["country"].ToString();
            txtLatitude.Text  = dt.Rows[0]["gps_latitude"].ToString();
            txtLongitude.Text = dt.Rows[0]["gps_longitude"].ToString();
            txtWebsite.Text   = dt.Rows[0]["website"].ToString();


            string strImgLogo = dt.Rows[0]["club_logo"].ToString();
            if (strImgLogo != "")
            {
                Session["ImageLogo"] = strImgLogo;
                imgLogo.Visible      = true;
                imgLogo.ImageUrl     = "../ClubsLogo/" + strImgLogo;
            }

            string strImgMap = dt.Rows[0]["location_map"].ToString();
            if (strImgMap != "")
            {
                Session["ImageMap"] = strImgMap;
                imgMap.Visible      = true;
                imgMap.ImageUrl     = "../ClubsLogo/" + strImgMap;
            }


            DDLMem1.SelectedItem.Text = dt.Rows[0]["ds"].ToString();
            DDLMem2.SelectedItem.Text = dt.Rows[0]["ag"].ToString();
            DDLMem3.SelectedItem.Text = dt.Rows[0]["at"].ToString();
            DDLMem4.SelectedItem.Text = dt.Rows[0]["gc"].ToString();

            txtPHF.Text       = dt.Rows[0]["phf"].ToString();
            txtTRFSM.Text     = dt.Rows[0]["trfsm"].ToString();
            txtMD.Text        = dt.Rows[0]["md"].ToString();
            txtPHSM.Text      = dt.Rows[0]["phsm"].ToString();
            txtArchKlump.Text = dt.Rows[0]["arch_klump"].ToString();

            try
            {
                installationDate.SelectedDate = DateTime.Parse(dt.Rows[0]["installation_date"].ToString());
            }
            catch { }
            //try
            //{
            //    installationTime.SelectedDate = DateTime.Parse(dt.Rows[0]["installation_time"].ToString());
            //}
            //catch { }

            string strTime = dt.Rows[0]["installation_time"].ToString();
            if (strTime == "Morning")
            {
                rbtnTime.SelectedIndex = 0;
            }
            if (strTime == "Afternoon")
            {
                rbtnTime.SelectedIndex = 1;
            }
            if (strTime == "Evening")
            {
                rbtnTime.SelectedIndex = 2;
            }



            txtChiefGuest.Text        = dt.Rows[0]["installation_chief_guest"].ToString();
            txtInstallationVenue.Text = dt.Rows[0]["installation_venue"].ToString();

            try
            {
                ocvDate.SelectedDate = DateTime.Parse(dt.Rows[0]["ocv_date"].ToString());
            }
            catch { }
            try
            {
                ocvTime.SelectedDate = DateTime.Parse(dt.Rows[0]["ocv_time"].ToString());
            }
            catch { }

            string strTrfStatus = dt.Rows[0]["club_trf_status"].ToString();
            if (strTrfStatus == "N/A")
            {
                rbtnClubTrfStatus.SelectedIndex = 0;
            }
            if (strTrfStatus == "100% PHFSM Club")
            {
                rbtnClubTrfStatus.SelectedIndex = 1;
            }
            if (strTrfStatus == "100% PHF Club")
            {
                rbtnClubTrfStatus.SelectedIndex = 2;
            }
            if (strTrfStatus == "100% EREY Club")
            {
                rbtnClubTrfStatus.SelectedIndex = 3;
            }
            if (strTrfStatus == "100% MD Club")
            {
                rbtnClubTrfStatus.SelectedIndex = 4;
            }

            txtFlagshipProject.Text = dt.Rows[0]["flagship_text"].ToString();
            string strFlagshipImg = dt.Rows[0]["flagship_image"].ToString();
            if (strFlagshipImg != "")
            {
                Session["FlagshipImg"] = strFlagshipImg;
                imgFlagship.Visible    = true;
                imgFlagship.ImageUrl   = "../ProjectFlagship/" + strFlagshipImg;
            }
        }
    }
예제 #4
0
    private void UpdateDistClub(int id)
    {
        try
        {
            System.Data.SqlTypes.SqlDateTime nullDate;
            nullDate = SqlDateTime.Null;

            int?nullInt = null;

            DistrictClub dc = new DistrictClub();

            dc.Id = id;

            dc.DistrictNo = int.Parse(ddlDistNo.SelectedItem.Text.ToString());
            dc.ClubName   = txtTitle.Text.ToString();
            try
            {
                dc.RiClubNo = int.Parse(txtClubNo.Text.ToString());
            }
            catch
            {
                dc.RiClubNo = 0;
            }

            string sponsorClub = DDLClubName.SelectedItem.Text.Trim();
            if (sponsorClub == "Select")
            {
                dc.SponsoredClub = "";
            }
            else
            {
                dc.SponsoredClub = DDLClubName.SelectedItem.Text.Trim();
            }

            try
            {
                dc.CharterDate = DateTime.Parse(charterDate.SelectedDate.ToString());// DDLDays.SelectedItem.Text + "/" + DDLMonth.SelectedItem.Text + "/" + DDLYear.SelectedItem.Text;
            }
            catch { dc.CharterDate = nullDate; }
            dc.MeetingDay = DDLDay.SelectedItem.Text;
            try
            {
                dc.MeetingTime = DateTime.Parse(meetingTime.SelectedDate.ToString());
            }
            catch { dc.MeetingTime = nullDate; }

            dc.Venu1        = txtVenue1.Text.Trim();
            dc.Venu2        = txtVenue2.Text.Trim();
            dc.Landmark     = txtLandmark.Text.Trim();
            dc.City         = txtCity.Text.Trim();
            dc.Pin          = txtPin.Text.Trim();
            dc.State        = txtState.Text.Trim();
            dc.Country      = txtCountry.Text.Trim();
            dc.GpsLatitude  = txtLatitude.Text.Trim();
            dc.GpsLongitude = txtLongitude.Text.Trim();

            dc.Website      = txtWebsite.Text.Trim();
            dc.FacebookLink = txtFacebookLink.Text.Trim();
            if (Session["ImageLogo"] != null)
            {
                dc.Logo = Session["ImageLogo"].ToString();
            }
            else
            {
                dc.Logo = "";
            }

            if (Session["ImageMap"] != null)
            {
                dc.LocationMap = Session["ImageMap"].ToString();
            }
            else
            {
                dc.LocationMap = "";
            }

            try
            {
                dc.InstallationDate = DateTime.Parse(installationDate.SelectedDate.ToString());
            }
            catch { dc.InstallationDate = nullDate; }
            //try
            //{
            //    dc.InstallationTime = DateTime.Parse(installationTime.SelectedDate.ToString());
            //}
            //catch { dc.InstallationTime = nullDate; }

            try
            {
                dc.InstallationTime = rbtnTime.SelectedItem.Text.ToString();
            }
            catch { dc.InstallationTime = ""; }


            dc.InstallationChiefGuest = txtChiefGuest.Text.Trim();
            dc.InstallationVenue      = txtInstallationVenue.Text.Trim();

            try
            {
                dc.OcvDate = DateTime.Parse(ocvDate.SelectedDate.ToString());
            }
            catch { dc.OcvDate = nullDate; }
            try
            {
                dc.OcvTime = DateTime.Parse(ocvTime.SelectedDate.ToString());
            }
            catch { dc.OcvTime = nullDate; }

            try
            {
                dc.Phf = int.Parse(txtPHF.Text.Trim());
            }
            //catch { dc.Phf = nullInt.Value; }
            catch { dc.Phf = 0; }

            try
            {
                dc.Trfsm = int.Parse(txtTRFSM.Text.Trim());
            }
            catch { dc.Trfsm = 0; }
            try
            {
                dc.Md = int.Parse(txtMD.Text.Trim());
            }
            catch { dc.Md = 0; }
            try
            {
                dc.Phsm = int.Parse(txtPHSM.Text.Trim());
            }
            catch { dc.Phsm = 0; }
            try
            {
                dc.ArchKlump = int.Parse(txtArchKlump.Text.Trim());
            }
            catch { dc.ArchKlump = 0; }

            dc.DS = DDLMem1.SelectedItem.Text.Trim();
            dc.AG = DDLMem2.SelectedItem.Text.Trim();
            dc.AT = DDLMem3.SelectedItem.Text.Trim();
            dc.GC = DDLMem4.SelectedItem.Text.Trim();

            dc.ClubTrfStatus = rbtnClubTrfStatus.SelectedItem.Text.Trim();

            dc.FlagshipText = txtFlagshipProject.Text.Trim();

            if (Session["FlagshipImg"] != null)
            {
                dc.FlagshipImage = Session["FlagshipImg"].ToString();
            }
            else
            {
                dc.FlagshipImage = "";
            }

            int exe = dc.UpdateDistrictClub();
            if (exe > 0)
            {
                showmsg("Record updated successfully !", "view_clubs.aspx");
            }
        }
        catch
        {
        }
    }
예제 #5
0
    private void AddDistClub()
    {
        if (Page.IsValid)
        {
            System.Data.SqlTypes.SqlDateTime nullDate;
            nullDate = SqlDateTime.Null;

            int?nullInt = null;

            //string h, m, am, time = "";
            //h = DDLTimeH.SelectedItem.Text;
            //m = DDLTimeM.SelectedItem.Text;
            //am = DDLTime2.SelectedItem.Text;

            //time = h + ":" + m + ":" + am;

            //string ih, im, iam, iTime = "";
            //ih = DDLInstallationTimeH.SelectedItem.Text;
            //im = DDLInstallationTimeM.SelectedItem.Text;
            //iam = DDLInstallationTimeM.SelectedItem.Text;

            //iTime = ih + ":" + im + ":" + iam;

            DistrictClub dc = new DistrictClub();

            dc.DistrictNo = int.Parse(ddlDistNo.SelectedItem.Text.ToString());
            dc.ClubName   = txtTitle.Text.ToString();
            try
            {
                dc.RiClubNo = int.Parse(txtClubNo.Text.ToString());
            }
            catch
            {
                dc.RiClubNo = 0;
            }

            string sponsorClub = DDLClubName.SelectedItem.Text.Trim();
            if (sponsorClub == "Select")
            {
                dc.SponsoredClub = "";
            }
            else
            {
                dc.SponsoredClub = DDLClubName.SelectedItem.Text.Trim();
            }

            try
            {
                dc.CharterDate = DateTime.Parse(charterDate.SelectedDate.ToString());// DDLDays.SelectedItem.Text + "/" + DDLMonth.SelectedItem.Text + "/" + DDLYear.SelectedItem.Text;
            }
            catch { dc.CharterDate = nullDate; }
            dc.MeetingDay = DDLDay.SelectedItem.Text;
            try
            {
                dc.MeetingTime = DateTime.Parse(meetingTime.SelectedDate.ToString());
            }
            catch { dc.MeetingTime = nullDate; }

            dc.Venu1        = txtVenue1.Text.Trim();
            dc.Venu2        = txtVenue2.Text.Trim();
            dc.Landmark     = txtLandmark.Text.Trim();
            dc.City         = txtCity.Text.Trim();
            dc.Pin          = txtPin.Text.Trim();
            dc.State        = txtState.Text.Trim();
            dc.Country      = txtCountry.Text.Trim();
            dc.GpsLatitude  = txtLatitude.Text.Trim();
            dc.GpsLongitude = txtLongitude.Text.Trim();

            dc.Website      = txtWebsite.Text.Trim();
            dc.FacebookLink = txtFacebookLink.Text.Trim();
            if (Session["ImageLogo"] != null)
            {
                dc.Logo = Session["ImageLogo"].ToString();
            }
            else
            {
                dc.Logo = "";
            }

            if (Session["ImageMap"] != null)
            {
                dc.LocationMap = Session["ImageMap"].ToString();
            }
            else
            {
                dc.LocationMap = "";
            }

            try
            {
                dc.InstallationDate = DateTime.Parse(installationDate.SelectedDate.ToString());
            }
            catch { dc.InstallationDate = nullDate; }
            //try
            //{
            //    dc.InstallationTime = DateTime.Parse(installationTime.SelectedDate.ToString());
            //}
            //catch { dc.InstallationTime = nullDate; }

            try
            {
                dc.InstallationTime = rbtnTime.SelectedItem.Text.ToString();
            }
            catch { dc.InstallationTime = ""; }


            dc.InstallationChiefGuest = txtChiefGuest.Text.Trim();
            dc.InstallationVenue      = txtInstallationVenue.Text.Trim();

            try
            {
                dc.OcvDate = DateTime.Parse(ocvDate.SelectedDate.ToString());
            }
            catch { dc.OcvDate = nullDate; }
            try
            {
                dc.OcvTime = DateTime.Parse(ocvTime.SelectedDate.ToString());
            }
            catch { dc.OcvTime = nullDate; }

            try
            {
                dc.Phf = int.Parse(txtPHF.Text.Trim());
            }
            //catch { dc.Phf = nullInt.Value; }
            catch { dc.Phf = 0; }

            try
            {
                dc.Trfsm = int.Parse(txtTRFSM.Text.Trim());
            }
            catch { dc.Trfsm = 0; }
            try
            {
                dc.Md = int.Parse(txtMD.Text.Trim());
            }
            catch { dc.Md = 0; }
            try
            {
                dc.Phsm = int.Parse(txtPHSM.Text.Trim());
            }
            catch { dc.Phsm = 0; }
            try
            {
                dc.ArchKlump = int.Parse(txtArchKlump.Text.Trim());
            }
            catch { dc.ArchKlump = 0; }

            dc.DS = DDLMem1.SelectedItem.Text.Trim();
            dc.AG = DDLMem2.SelectedItem.Text.Trim();
            dc.AT = DDLMem3.SelectedItem.Text.Trim();
            dc.GC = DDLMem4.SelectedItem.Text.Trim();

            dc.ClubTrfStatus = rbtnClubTrfStatus.SelectedItem.Text.Trim();

            dc.FlagshipText = txtFlagshipProject.Text.Trim();

            if (Session["FlagshipImg"] != null)
            {
                dc.FlagshipImage = Session["FlagshipImg"].ToString();
            }
            else
            {
                dc.FlagshipImage = "";
            }


            int exe = dc.AddClub();
            if (exe > 0)
            {
                int pid = GetClubId();
                UpdateIWClubId(pid);

                clear();
                string jv = "<script>alert('Record Added Successfully');</script>";
                ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
            }
        }
    }
예제 #6
0
    protected void btnSendDistrictDirectoryData_Click(object sender, EventArgs e)
    {
        int    clubId = 0;
        string email = "-";
        string clubName = "-";
        string clubNo = "-";
        string charterDate = "-";
        string mettingDay = "-";
        string strMeetingTime = "-";
        string venue = "-";
        string ds = "-";
        string at = "-";
        string ag = "-";
        string flagshipText = "-";
        string strFlagship = "";
        int    members = 0;
        int    womenMembers = 0;
        int    iw, rotract, interact, srCitizen, rcc = 0;



        foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
        {
            try
            {
                CheckBox chkbox    = (CheckBox)item.FindControl("chkActive");
                Label    lblClubId = (Label)item.FindControl("lblClubId");
                Label    lblEmail  = (Label)item.FindControl("lblEmail");

                if (chkbox.Checked)
                {
                    clubId = Int32.Parse(lblClubId.Text.ToString());

                    //GetClubDetails(clubId);
                    iw        = GetIw(clubId);
                    rotract   = GetRotaract(clubId);
                    interact  = GetInteract(clubId);
                    srCitizen = GetSrCitizen(clubId);
                    rcc       = GetRcc(clubId);
                    //GetBodDetails(clubId);
                    BindGridview(clubId);
                    BindPresident(clubId);
                    BindSecretary(clubId);


                    DataTable    dt  = new DataTable();
                    DBconnection obj = new DBconnection();
                    obj.SetCommandSP = "z_GetMaleFemaleMembersByClubId";
                    obj.AddParam("@club_id", clubId);
                    dt = obj.ExecuteTable();
                    if (dt.Rows.Count > 0)
                    {
                        members      = int.Parse(dt.Rows[0]["Total"].ToString());
                        womenMembers = int.Parse(dt.Rows[0]["WomenMembers"].ToString());
                    }


                    try
                    {
                        DistrictClub obj1 = new DistrictClub();
                        obj1.Id = clubId;

                        DataTable dt1 = new DataTable();
                        dt1 = obj1.GetClubById();
                        if (dt1.Rows.Count > 0)
                        {
                            // Club Details

                            clubName = dt1.Rows[0]["club_name"].ToString();
                            clubNo   = dt1.Rows[0]["ri_club_No"].ToString();

                            DateTime chrterdate = DateTime.Parse(dt1.Rows[0]["charter_date"].ToString());
                            charterDate = chrterdate.ToString("dd-MMMM-yyyy");
                            mettingDay  = dt1.Rows[0]["meeting_day"].ToString();


                            try
                            {
                                DateTime meetingTime = DateTime.Parse(dt1.Rows[0]["meeting_time"].ToString());
                                strMeetingTime = meetingTime.ToString("hh:mm tt");
                            }
                            catch
                            {
                                strMeetingTime = "-";
                            }


                            venue = dt1.Rows[0]["venue1"].ToString() + " " + dt1.Rows[0]["venue2"].ToString() + " " + dt1.Rows[0]["city"].ToString();

                            ds = dt1.Rows[0]["ds"].ToString();
                            at = dt1.Rows[0]["at"].ToString();
                            ag = dt1.Rows[0]["ag"].ToString();

                            flagshipText = dt1.Rows[0]["flagship_text"].ToString();

                            strFlagship = dt1.Rows[0]["flagship_image"].ToString();
                            //if (strFlagship != "")
                            //{
                            //    imgFlagship.Visible = true;
                            //    imgFlagship.ImageUrl = "../ClubsLogo/" + strFlagship;
                            //}
                            //else
                            //{
                            //    imgFlagship.Visible = false;
                            //}
                        }
                    }
                    catch { }


                    email = lblEmail.Text.ToString();
                    if (email != "")
                    {
                        try
                        {
                            SendMailtoDistDirectory(email, clubId, clubName, clubNo, charterDate, members, womenMembers, iw, rotract, interact, srCitizen, rcc, venue, mettingDay, strMeetingTime, ds, at, ag, flagshipText, strFlagship);
                        }
                        catch { }
                    }
                }
                chkbox.Checked = false;
            }
            catch { }
        }
    }