Translate

Thursday, 29 September 2016

From date should lessthan to date using boostrap



Fromdate should less tahn todate using boostrap datepicker


$(document).ready(function(){
 
    $("#startdate").datepicker({
        todayBtn:  1,
        autoclose: true,
    }).on('changeDate', function (selected) {
        var minDate = new Date(selected.date.valueOf());
        $('#enddate').datepicker('setStartDate', minDate);
    });
   
    $("#enddate").datepicker()
        .on('changeDate', function (selected) {
            var minDate = new Date(selected.date.valueOf());
            $('#startdate').datepicker('setEndDate', minDate);
        });

});

Monday, 12 September 2016

Multiselect using jquery chosen plugin

Multiselect dropdownlist with jquery chosen plugin:


ActionResult at controller:


public ActionResult ChosenMultiselect()
        {
            return View();
        }


 Json data to bind dropdown:


        public ActionResult ListCountries()
        {

            List<string> category = new List<string>();
            StringBuilder sb=new StringBuilder();
            for (int i = 0; i <10; i++)
            {
              
                string country="Country"+i;
                    sb.Append("<option value="+country+ ">"+country+"</option> ");
               
            }
            return Json(sb.ToString(), JsonRequestBehavior.AllowGet);


        }

View:


@{
    ViewBag.Title = "ChosenMultiselect";
}

<h2>ChosenMultiselect</h2>
<script src="~/Scripts/jquery-1.7.1.min.js"></script>
<link href="@Url.Content("~/Content/MultiSelect/chosen.css")" rel="stylesheet" />
<script src="@Url.Content("~/Content/MultiSelect/chosen.jquery.js")"></script>

<script>
    jQuery(document).ready(function () {
        jQuery(".chosen").data("placeholder", "Select a Category...").chosen();
    });
    $(document).ready(function (event) {

        var url = '@Url.Action("ListCountries", "Home")';

            $.getJSON(url, function (options) {
                $("#ddlcountry").html(options);
                $('#ddlcountry').trigger('liszt:updated');
            });
            $("#btnSearch").click(function () {
                alert($("#ddlcountry").val());
            });
        });
</script>
<div>
    <div class="selectBox">

        <select class="chosen" id="ddlcountry" multiple="true" style="width: 210px; height: 42px" name="country">
        </select>
        <input type="button" id="btnSearch" value="Search" />
    </div>
</div>

Output:



Thursday, 1 September 2016

Disable Datepicker dates based on database list using JQUERY



To disable datapicker date getting from db shown below

Getting dates list from db using ajax call

  $(document).ready(function () {
            $("#ContentPlaceHolder_Body_ddlBlock").change(function () {
                getdates();
            });

            var holidays;
            function getdates() {
                $.ajax({
                    type: "POST",
                    url: "Dates.aspx/GetDatesArray",
                    data: '',
                    dataType: "json",
                    contentType: "application/json; charset=utf-8",
                    success: function (data) {
                        holidays = data.d;
                        localStorage.setItem("Holidays", holidays);
                    },
                });
            }

            var holidaysList = localStorage.getItem("Holidays");
            if (holidaysList != null && holidaysList != "") {
             var holidays = holidaysList.toString().split(',');
                $("# txtDate").datepicker({
                    changeMonth: true,
                    changeYear: true,
                    dateFormat: 'yy-mm-dd',
                    beforeShowDay: function (date) {
                        show = true;
                        if (date.getDay() == 0) { show = false; }//No Weekends
                        for (var i = 0; i < holidays.length; i++) {
                            if (new Date(holidays[i]).toString() == date.toString()) { show = false; }//No Holidays
                        }
                        var display = [show, '', (show) ? '' : 'No Weekends or Holidays'];//With Fancy hover tooltip!
                        return display;
                    }

                });
            }
            else {
                getdates();
            }


        });

webmethod in .cs file




[WebMethod]
        public static List<string> GetDatesArray()
        {
            string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            try
            {
                DataSet Sqlds = new DataSet();
                using (SqlConnection sqlCon = new SqlConnection(consString))
                {
                    using (SqlCommand sqlCmd = new SqlCommand("select * from table", sqlCon))
                    {

                        SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
                        sqlDa.Fill(Sqlds);

                    }
                }
                List<string> strPH = new List<string>();

                foreach (DataRow row in Sqlds.Tables[0].Rows)
                {

                    DateTime Dt = Convert.ToDateTime(row["d"].ToString());
                    //strPH.Add(String.Format("{0:MM/dd/yyyy}", Dt));

                    strPH.Add((Dt.ToString("M/d/yyyy")).Replace("-", "/"));
                }

                return strPH;
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }