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;
}
}
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;
}
}