public ActionResult BindGridView(GridParamater GP)
 {
     try
     {
         DataSet ds = _obj_db_UM.BindGrid(GP);
         List<UserMaster> items = new List<UserMaster>();
         if (ds.Tables[0].Rows.Count > 0)
         {
             ViewBag.fname = ds.Tables[0];
             foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
             {
                 items.Add(new UserMaster
                 {
                     RowNumber = @dr["RowNumber"].ToString(),
                     srno = @dr["srno"].ToString(),
                     Email = @dr["Email"].ToString(),
                     Name = @dr["Name"].ToString(),
                 });
             }
         }
         var result = items;
         return Json(result, JsonRequestBehavior.AllowGet);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public ActionResult BindGridView(GridParamater GP)
 {
     try
     {
         DataSet ds = _objwl.BindGrid(GP);
         List<GridFrmControlDisplay> items = new List<GridFrmControlDisplay>();
         if (ds.Tables[0].Rows.Count > 0)
         {
             ViewBag.fname = ds.Tables[0];
             foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
             {
                 items.Add(new GridFrmControlDisplay
                 {
                     RowNumber = @dr["RowNumber"].ToString(),
                     CompanyName = @dr["CompanyName"].ToString(),
                     CompanyIndustry = @dr["CompanyIndustry"].ToString(),
                     ApplicationURL = @dr["ApplicationURL"].ToString(),
                     RefferenceCompany = @dr["ReferenceCompany"].ToString(),
                     Srno = @dr["Srno"].ToString()
                 });
             }
         }
         var result = items;
         return Json(result, JsonRequestBehavior.AllowGet);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 3
0
 public DataSet BindGrid(GridParamater GP)
 {
     try
     {
         _cn = new SqlConnection(ConfigurationManager.ConnectionStrings["gtcon"].ToString());
         _cn.Open();
         SqlCommand _cmd = new SqlCommand("Sp_Grid_RoleMaster", _cn);
         _cmd.CommandType = CommandType.StoredProcedure;
         _cmd.Parameters.AddWithValue("@tablename", GP.tablename);
         _cmd.Parameters.AddWithValue("@Corporate", GP.Corporate);
         _cmd.Parameters.AddWithValue("@unit", GP.unit);
         _cmd.Parameters.AddWithValue("@userid", GP.userid);
         _cmd.Parameters.AddWithValue("@WhereClause", GP.WhereClause);
         _cmd.Parameters.AddWithValue("@Branch", GP.Branch);
         _cmd.Parameters.AddWithValue("@PageNo", GP.PageNo);
         _cmd.Parameters.AddWithValue("@RecordsPerPage", GP.RecordsPerPage);
         _cmd.Parameters.AddWithValue("@Formcode", GP.Formcode);
         _cmd.Parameters.AddWithValue("@Formtabcode", GP.Formtabcode);
         _cmd.Parameters.AddWithValue("@type", GP.type);
         _cmd.Parameters.AddWithValue("@Segment", GP.Segment);
         _cmd.Parameters.AddWithValue("@Field1", GP.Field1);
         _cmd.CommandType = CommandType.StoredProcedure;
         SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
         DataSet _ds = new DataSet();
         _adp.Fill(_ds);
         _adp.Dispose();
         _cmd.Dispose();
         return _ds;
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         _cn.Close();
         _cn.Dispose();
     }
 }
 public ActionResult BindGridUser(GridParamater GP)
 {
     try
     {
         DataSet ds = _objCM.BindGridUser(GP);
         List<GridUserMasterparamater> items = new List<GridUserMasterparamater>();
         if (ds.Tables[0].Rows.Count > 0)
         {
             ViewBag.fname = ds.Tables[0];
             foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
             {
                 items.Add(new GridUserMasterparamater
                 {
                     RowNumber = @dr["RowNumber"].ToString(),
                     xmaster = @dr["xmaster"].ToString(),
                     xname = @dr["xname"].ToString(),
                     SrNo = @dr["SrNo"].ToString(),
                 });
             }
         }
         var result = items;
         return Json(result, JsonRequestBehavior.AllowGet);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public ActionResult BindAccessgrid(GridParamater GP)
 {
     try
     {
         DataSet ds = _obj_db_UM.BindAccessgrid(GP);
         List<UserMaster_AccessRight> items = new List<UserMaster_AccessRight>();
         if (ds.Tables[0].Rows.Count > 0)
         {
             ViewBag.fname = ds.Tables[0];
             foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
             {
                 items.Add(new UserMaster_AccessRight
                 {
                     //  Module = @dr["Module"].ToString(),
                     //   Screen = @dr["Screen"].ToString(),
                     //  srno = @dr["srno"].ToString(),
                 });
             }
         }
         var result = items;
         return Json(result, JsonRequestBehavior.AllowGet);
     }
     catch (Exception)
     {
         throw;
     }
 }
        public ActionResult BindGridView(GridParamater GP)
        {
            try
            {
                DataSet ds = _objCM.BindGrid(GP);
                List<GridAdminparamater> items = new List<GridAdminparamater>();
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ViewBag.fname = ds.Tables[0];
                    foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
                    {
                        items.Add(new GridAdminparamater
                        {
                            RowNumber = @dr["RowNumber"].ToString(),
                            name = @dr["xname"].ToString(),
                            Mastercode = @dr["XMaster"].ToString(),
                            Entry_Level = @dr["ENTRYCONTROL"].ToString(),
                            segment = @dr["SEGMENT"].ToString()

                        });
                    }
                }
                var result = items;
                return Json(result, JsonRequestBehavior.AllowGet);
            }
            catch (Exception)
            {
                throw;
            }
        }
 public ActionResult BindGridView(GridParamater GP)
 {
     try
     {
         DataSet ds = _objDCFS.BindGrid(GP);
         List<GridFromControlDisplay> items = new List<GridFromControlDisplay>();
         if (ds.Tables[0].Rows.Count > 0)
         {
             ViewBag.fname = ds.Tables[0];
             foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
             {
                 items.Add(new GridFromControlDisplay
                 {
                     RowNumber = dr["RowNumber"].ToString(),
                     corporate = dr["corporate"].ToString(),
                     Features = dr["Features"].ToString(),
                     Module = dr["Module"].ToString(),
                     Form = dr["Form"].ToString(),
                     Tab = dr["Tab"].ToString(),
                     Section = dr["Section"].ToString(),
                     Controls = dr["Control"].ToString(),
                     Srno = dr["Srno"].ToString()
                 });
             }
         }
         var result = items;
         return Json(result, JsonRequestBehavior.AllowGet);
     }
     catch (Exception)
     {
         throw;
     }
 }