public JsonResult GetUploadedContent(int?SheetID, int?page, int?limit, string sortBy, string direction, string searchString = null)
        {
            int total;
            var records = (dynamic)null;

            if (DropDownListModel.getSelectedValue <= 0)
            {
                DropDownListModel.getSelectedValue = 1;
            }

            if (DropDownListModel.getSelectedMonth != null)
            {
                if (DropDownListModel.getSelectedMonth.Contains("Select"))
                {
                    DropDownListModel.getSelectedMonth = String.Format("{0:MMMM}", DateTime.Now);
                }

                if (DropDownListModel.getSelectedYear.Contains("Select"))
                {
                    DropDownListModel.getSelectedYear = String.Format("{0:yyyy}", DateTime.Now);
                }
            }
            else
            {
                DropDownListModel.getSelectedMonth = String.Format("{0:MMMM}", DateTime.Now);
                DropDownListModel.getSelectedYear  = String.Format("{0:yyyy}", DateTime.Now);
            }

            records = new CPReadWriteModel().GetUploadedData(DropDownListModel.getSelectedValue, DropDownListModel.getSelectedMonth, DropDownListModel.getSelectedYear, page, limit, sortBy, direction, searchString, out total);
            return(Json(new { records, total }, JsonRequestBehavior.AllowGet));
        }
 public ActionResult Airtel1(string command, DropDownListModel obj)
 {
     if (command == "GridLoad")
     {
         DropDownListModel.getSelectedValue = Convert.ToInt32(obj.SheetID);
         DropDownListModel.getSelectedMonth = obj.MonthValue;
         DropDownListModel.getSelectedYear  = obj.YearValue;
     }
     if (command == "Sync")
     {
         DropDownListModel.getSelectedValue = Convert.ToInt32(obj.SheetID);
         CPReadWriteModel objCPModelReadWrite = new CPReadWriteModel();
         //objCPModelReadWrite.DataSync(DropDownListModel.getSelectedValue);
         objCPModelReadWrite.DataSyncAirtel(DropDownListModel.getSelectedValue, DropDownListModel.getSelectedMonth, DropDownListModel.getSelectedYear);
     }
     return(RedirectToAction(ActionModel.ActionNameGet, obj));
 }