// -------------------->> Tab-4 ( Create Access Rights )
public ActionResult BindDropdown_FormLoadAccessRights(CommanFieldPara CFP)
{
try
{
DataSet ds = _objRoleRightsDb.BindDropdown_FormLoadAccessRights(CFP);
List<CommanDropdown> Corporate = new List<CommanDropdown>();
List<CommanDropdown> Status = new List<CommanDropdown>();
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Corporate.Add(new CommanDropdown { Text = @dr["xname"].ToString(), Value = @dr["xcode"].ToString() });
}
}
if (ds.Tables[1].Rows.Count > 0)
{
ViewBag.Status = ds.Tables[1];
foreach (System.Data.DataRow dr in ViewBag.Status.Rows)
{
Status.Add(new CommanDropdown { Text = @dr["xname"].ToString(), Value = @dr["xcode"].ToString() });
}
}
var Corporatedrp = Corporate; var Status_Drp = Status;
return Json(new { Corp = Corporatedrp, Status = Status_Drp }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public ActionResult BindDropDownLoad(CommanFieldPara _CBP)
{
try
{
DataSet ds = _objDBViewSetup.BindDropDownFormLoad(_CBP);
List<CommanDropdown> items = new List<CommanDropdown>();
List<CommanDropdown> Master = new List<CommanDropdown>();
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
items.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var result = items;
if (ds.Tables[1].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[1];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Master.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var result1 = Master;
return Json(new { GTCorporate = result, GTMaster = result1 }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public DataSet BindDropdown_FormLoadAccessRights(CommanFieldPara CFP)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Formload_RoleMaster", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@Module", CFP.Module);
_cmd.Parameters.AddWithValue("@screen", CFP.screen);
_cmd.Parameters.AddWithValue("@FormCode", CFP.FormCode);
_cmd.Parameters.AddWithValue("@TabCode", CFP.TabCode);
_cmd.Parameters.AddWithValue("@Corporate", CFP.Corporate);
_cmd.Parameters.AddWithValue("@unit", CFP.unit);
_cmd.Parameters.AddWithValue("@Branch", CFP.Branch);
_cmd.Parameters.AddWithValue("@userid", CFP.userid);
_cmd.Parameters.AddWithValue("@Ip", CFP.Ip);
_cmd.Parameters.AddWithValue("@Type", CFP.Type);
_cmd.Parameters.AddWithValue("@Srno", CFP.Srno);
_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 BindDropDown(CommanFieldPara CFP)
{
try
{
DataSet ds = _objwl.BindDropDown(CFP);
List<CommanDropdown> Industry = new List<CommanDropdown>();
List<CommanDropdown> items = new List<CommanDropdown>();//company Type
List<CommanDropdown> itemservice = new List<CommanDropdown>();
List<CommanDropdown> BMode = new List<CommanDropdown>();
List<CommanDropdown> CURRENCY = new List<CommanDropdown>();
List<CommanDropdown> Language = new List<CommanDropdown>();
List<CommanDropdown> Corporate = new List<CommanDropdown>();
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Industry.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var Industrys = Industry;
if (ds.Tables[1].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[1];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
items.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var result = items;
if (ds.Tables[2].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[2];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
itemservice.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var service = itemservice;
if (ds.Tables[3].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[3];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
BMode.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var BussineMode = BMode;
if (ds.Tables[4].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[4];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
CURRENCY.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var currency = CURRENCY;
if (ds.Tables[5].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[5];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Language.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var language = Language;
if (ds.Tables[6].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[6];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Corporate.Add(new CommanDropdown { Text = dr["xname"].ToString(), Value = dr["xcode"].ToString() });
}
}
var corporate = Corporate;
return Json(new { GTINDUTRYS = Industrys, GTIndutry = result, GTservice = service, GTBmode = BussineMode, GTcurrency = currency, GTlanguage = language, GTCorporate = corporate }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public DataSet BindDropdownLocation(CommanFieldPara CFP)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Base_UserRoleMaster", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@Module", CFP.Module);
_cmd.Parameters.AddWithValue("@screen", CFP.screen);
_cmd.Parameters.AddWithValue("@FormCode", CFP.FormCode);
_cmd.Parameters.AddWithValue("@TabCode", CFP.TabCode);
_cmd.Parameters.AddWithValue("@Corporate", CFP.Corporate);
_cmd.Parameters.AddWithValue("@unit", CFP.unit);
_cmd.Parameters.AddWithValue("@Branch", CFP.Branch);
_cmd.Parameters.AddWithValue("@userid", CFP.userid);
_cmd.Parameters.AddWithValue("@Ip", CFP.Ip);
_cmd.Parameters.AddWithValue("@Type", CFP.Type);
_cmd.Parameters.AddWithValue("@field1", "UNIT-2-0-1");
_cmd.Parameters.AddWithValue("@field2", "");
_cmd.Parameters.AddWithValue("@field3", "");
_cmd.Parameters.AddWithValue("@field4", "");
_cmd.Parameters.AddWithValue("@field5", "");
_cmd.Parameters.AddWithValue("@Control", "DrpLocation");
_cmd.Parameters.AddWithValue("@Srno", CFP.Srno);
_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 BindDropdown_Base(CommanFieldPara CFP)
{
try
{
DataSet ds = _objWhitelabelAccessRights.BindDropdown_Base(CFP);
List<CommanDropdown> Corporate = new List<CommanDropdown>();
//List<CommanDropdown> Item = new List<CommanDropdown>();
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Corporate.Add(new CommanDropdown { Text = @dr["xname"].ToString(), Value = @dr["xcode"].ToString() });
}
}
var Corporatedrp = Corporate;
return Json(new { Corp = Corporatedrp }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public ActionResult BindDropdownUserrole(CommanFieldPara CFP)
{
try
{
DataSet ds = _obj_db_UM.BindDropdownUserrole(CFP);
List<CommanDropdown> Industry = new List<CommanDropdown>();
List<CommanDropdown> Item = new List<CommanDropdown>();
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Industry.Add(new CommanDropdown { Text = @dr["xname"].ToString(), Value = @dr["xcode"].ToString() });
}
}
var Unitdrp = Industry;
if (ds.Tables[1].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[1];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Item.Add(new CommanDropdown { Text = @dr["xname"].ToString(), Value = @dr["xcode"].ToString() });
}
}
var Locationdrp = Item;
return Json(new { UNITDRPJS = Unitdrp, USERDRPJS = Locationdrp }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}