public ActionResult BindDropDown_Corporate(WhitelabelStep2 CBP)
{
try
{
DataSet ds = _objw2.Base(CBP);
List<CommanDropdown> items = new List<CommanDropdown>();
if (ds.Tables[1].Rows.Count > 0)
{
ViewBag.category = ds.Tables[1];
foreach (System.Data.DataRow dr in ViewBag.category.Rows)
{
items.Add(new CommanDropdown { Text = @dr["xname"].ToString(), Value = @dr["xcode"].ToString() });
}
}
var result = items;
return Json(result, JsonRequestBehavior.AllowGet);
// return Json(new SelectList(result, "Text", "Value"));
}
catch (Exception)
{
throw;
}
}
public DataSet Base(WhitelabelStep2 CFP)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Base_White_Register_Step2", _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("@control", CFP.control);
_cmd.Parameters.AddWithValue("@Type", CFP.Type);
_cmd.Parameters.AddWithValue("@field1", CFP.Field1);
_cmd.Parameters.AddWithValue("@field2", CFP.Field2);
_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 Encry(WhitelabelStep2 CBP)
{
try
{
EncryptionDecryption enc_dec = new EncryptionDecryption();
var data = HttpUtility.UrlEncode(enc_dec.UrlEncrypt(CBP.Corporate.ToString()));
return Json(data, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public ActionResult FillAll(CommanFieldConditionalPara CFP)
{
try
{
DataSet dsList = _objWhitelabelAccessRights.BindDropdown_BaseAccessRights(CFP);
WhitelabelStep2 CV = new WhitelabelStep2();
Grid _grid = new Grid();
List<GridHearder> GridHearder = new List<GridHearder>();
List<GridColumn> GridColumn = new List<GridColumn>();
List<Grid> lstGrid = new List<Grid>();
if (dsList.Tables[0].Rows.Count > 0)
{
ViewBag.GridHearder = dsList.Tables[0];
ViewBag.GridColumn = dsList.Tables[1];
if (dsList.Tables[0] != null)
{
foreach (System.Data.DataRow dr in ViewBag.GridColumn.Rows)
{
GridColumn.Add(new GridColumn
{
xname = @dr["xname"].ToString(),
SrNo = @dr["xcode"].ToString(),
xlink = @dr["xlink"].ToString()
});
}
}
if (dsList.Tables[1] != null)
{
foreach (System.Data.DataRow dr in ViewBag.GridHearder.Rows)
{
GridHearder.Add(new GridHearder
{
xname = @dr["xname"].ToString(),
SrNo = @dr["xcode"].ToString()
});
}
}
}
_grid.GridColumn = GridColumn.ToList();
_grid.GridHearder = GridHearder.ToList();
lstGrid.Add(_grid);
return Json(new { ColumnList = _grid.GridColumn, HeaderList = _grid.GridHearder }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public DataSet Insert(WhitelabelStep2 CFP)
{
try
{
DataTable dt = new DataTable();
if (dt.Columns.Count == 0)
{
dt.Columns.Add("id", typeof(int));
dt.Columns.Add("Srno", typeof(string));
dt.Columns.Add("Featuregroup", typeof(string));
dt.Columns.Add("Feature", typeof(string));
dt.Columns.Add("Attribute1", typeof(string));
dt.Columns.Add("Attribute2", typeof(string));
dt.Columns.Add("Attribute3", typeof(string));
dt.Columns.Add("Attribute4", typeof(string));
dt.Columns.Add("Attribute5", typeof(string));
dt.Columns.Add("Attribute6", typeof(string));
dt.Columns.Add("Attribute7", typeof(string));
dt.Columns.Add("Attribute8", typeof(string));
dt.Columns.Add("Attribute9", typeof(string));
dt.Columns.Add("Attribute10", typeof(string));
dt.Columns.Add("UnitCorpBy", typeof(string));
dt.Columns.Add("BranchBy", typeof(string));
dt.Columns.Add("CreatedBy", typeof(string));
dt.Columns.Add("EntryDatetime", typeof(DateTime));
dt.Columns.Add("EditedBy", typeof(string));
dt.Columns.Add("EditDatetime", typeof(DateTime));
dt.Columns.Add("CorpcentreBy", typeof(string));
dt.Columns.Add("TerminalBy", typeof(string));
}
var arrGroup = ((string[])(CFP.groupAry))[0];
arrGroup = arrGroup.Replace("[", String.Empty);
arrGroup = arrGroup.Replace("]", String.Empty);
arrGroup = arrGroup.Replace("\"", String.Empty);
var arrGroups = arrGroup.Split(',');
string[] arr = (string[])CFP.groupAry;
object[] arr1 = (object[])CFP.FeatureAry;
var arrFeature = ((string[])(CFP.FeatureAry))[0];
arrFeature = arrFeature.Replace("[", String.Empty);
arrFeature = arrFeature.Replace("]", String.Empty);
arrFeature = arrFeature.Replace("\"", String.Empty);
var arrFeatures = arrFeature.Split(',');
int Count = 0;
foreach (object item in arrGroups)
{
DataRow dr = dt.NewRow();
dr["Featuregroup"] = item.ToString();
//dr["Feature"] = "";
int count2 = 0;
foreach (object Index in arrFeatures)
{
if (Count == count2)
{
dr["Feature"] = Index.ToString();
}
count2++;
}
// dr["Feature"] = "";
dr["Attribute1"] = CFP.Attribute1;
dr["Attribute2"] = CFP.Attribute2;
dr["Attribute3"] = CFP.Attribute3;
dr["Attribute4"] = CFP.Attribute4;
dr["Attribute5"] = CFP.Attribute5;
dr["Attribute6"] = CFP.Attribute6;
dr["Attribute7"] = CFP.Attribute7;
dr["Attribute8"] = CFP.Attribute8;
dr["Attribute9"] = CFP.Attribute9;
dr["Attribute10"] = CFP.Attribute10;
dr["Unitcorpby"] = CFP.UnitCorpBy;
dr["Branchby"] = CFP.BranchBy;
dr["CreatedBy"] = CFP.CreatedBy;
dr["EntryDatetime"] = DBNull.Value;
dr["EditedBy"] = CFP.CreatedBy;
dr["EditDatetime"] = DBNull.Value; ;
dr["CorpcentreBy"] = CFP.CorpcentreBy;
dr["TerminalBy"] = CFP.TerminalBy;
dt.Rows.Add(dr);
Count++;
}
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_save_White_feature_mapping", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@srno", CFP.srno);
_cmd.Parameters.AddWithValue("@Corporate", CFP.Corporate);
_cmd.Parameters.AddWithValue("@Module", CFP.Module);
_cmd.Parameters.AddWithValue("@Screen", CFP.screen);
_cmd.Parameters.AddWithValue("@FeaturesCategory", CFP.FeaturesCategory);
_cmd.Parameters.AddWithValue("@Attribute1", CFP.Attribute1);
_cmd.Parameters.AddWithValue("@Attribute2", CFP.Attribute2);
_cmd.Parameters.AddWithValue("@Attribute3", CFP.Attribute3);
_cmd.Parameters.AddWithValue("@Attribute4", CFP.Attribute4);
_cmd.Parameters.AddWithValue("@Attribute5", CFP.Attribute5);
_cmd.Parameters.AddWithValue("@Attribute6", CFP.Attribute6);
_cmd.Parameters.AddWithValue("@Attribute7", CFP.Attribute7);
_cmd.Parameters.AddWithValue("@Attribute8", CFP.Attribute8);
_cmd.Parameters.AddWithValue("@Attribute9", CFP.Attribute9);
_cmd.Parameters.AddWithValue("@Attribute10", CFP.Attribute10);
_cmd.Parameters.AddWithValue("@CreatedBy", CFP.CreatedBy);
_cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value);
_cmd.Parameters.AddWithValue("@EditedBy", CFP.CreatedBy);
_cmd.Parameters.AddWithValue("@EditDatetime",DBNull.Value);
_cmd.Parameters.AddWithValue("@CorpcentreBy", CFP.CorpcentreBy);
_cmd.Parameters.AddWithValue("@UnitCorpBy", CFP.UnitCorpBy);
_cmd.Parameters.AddWithValue("@TerminalBy", CFP.TerminalBy);
_cmd.Parameters.AddWithValue("@BranchBy", CFP.BranchBy);
if (dt != null)
{
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@TYPE";
parameter.SqlDbType = System.Data.SqlDbType.Structured;
parameter.Value = dt;
_cmd.Parameters.Add(parameter);
}
_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 DataSet Edit(WhitelabelStep2 CFP)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Edit_White_feature_mapping", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@tablename", CFP.tablename);
_cmd.Parameters.AddWithValue("@Corporate", CFP.Corporate);
_cmd.Parameters.AddWithValue("@unit", CFP.unit);
_cmd.Parameters.AddWithValue("@Formcode", CFP.FormCode);
_cmd.Parameters.AddWithValue("@Formtabcode", DBNull.Value);
_cmd.Parameters.AddWithValue("@srno", CFP.srno);
_cmd.Parameters.AddWithValue("@Type", CFP.Type);
_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 BindGridBase(WhitelabelStep2 CBP)
{
try
{
DataSet dsList = _objw2.Base(CBP);
WhitelabelStep2 CV = new WhitelabelStep2();
List<GridHearder> GridHearder = new List<GridHearder>();
if (dsList.Tables[0].Rows.Count > 0)
{
ViewBag.GridHearder = dsList.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.GridHearder.Rows)
{
GridHearder.Add(new GridHearder { xname = @dr["xname"].ToString(), SrNo = @dr["xcode"].ToString() });
}
}
var Header = GridHearder;
CV.GridHearder = GridHearder;
// return View(CV);
// return Json(result, JsonRequestBehavior.AllowGet);
return Json(new SelectList(Header, "xname", "SrNo"));
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(WhitelabelStep2 CBP)
{
try
{
DataSet result = _objw2.Edit(CBP);
List<WhitelabelStep2> WhitelabelStep2 = new List<WhitelabelStep2>();
if (result.Tables[0].Rows.Count > 0)
{
ViewBag.fname = result.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
WhitelabelStep2.Add(new WhitelabelStep2
{
srno = @dr["srno"].ToString(),
Corporate = @dr["Corporate"].ToString(),
FeaturesCategory = @dr["FeaturesCategory"].ToString(),
});
}
}
List<WhitelabelStep2> Obj_WhitelabelStep2 = new List<WhitelabelStep2>();
if (result.Tables[1].Rows.Count > 0)
{
ViewBag.Grid = result.Tables[1];
foreach (System.Data.DataRow dr in ViewBag.Grid.Rows)
{
Obj_WhitelabelStep2.Add(new WhitelabelStep2
{
srno = @dr["srno"].ToString(),
FeatureGroup = @dr["FeatureGroup"].ToString(),
Feature = @dr["Feature"].ToString(),
});
}
}
return Json(new { Dropdown = WhitelabelStep2, Grid = Obj_WhitelabelStep2 }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public ActionResult Insert(WhitelabelStep2 CBP)
{
try
{
ViewBag.Message = "";
ViewBag.Event = "";
ViewBag.SrNo = "";
DataSet result = _objw2.Insert(CBP);
if (result.Tables[0].Rows.Count > 0)
{
ViewBag.Message = result.Tables[0].Rows[0]["msg"].ToString();
if (result.Tables[0].Rows[0]["Help"].ToString() == "Save" || result.Tables[0].Rows[0]["Help"].ToString() == "Update")
{
ViewBag.Event = "success";
}
ViewBag.SrNo = result.Tables[0].Rows[0]["SrNo"].ToString();
}
var result1 = ViewBag.Message;
return Json(new { success = result1, Event = ViewBag.Event, SrNo = ViewBag.SrNo }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public PartialViewResult _DisplayGridData(string id)
{
DataSet dsList = _objw2.Basegrid(id);
WhitelabelStep2 CV = new WhitelabelStep2();
Grid _grid = new Grid();
List<GridHearder> GridHearder = new List<GridHearder>();
List<GridColumn> GridColumn = new List<GridColumn>();
List<Grid> lstGrid = new List<Grid>();
if (dsList.Tables[0].Rows.Count > 0)
{
ViewBag.GridHearder = dsList.Tables[0];
ViewBag.GridColumn = dsList.Tables[1];
if (dsList.Tables[0] != null)
{
foreach (System.Data.DataRow dr in ViewBag.GridColumn.Rows)
{
GridColumn.Add(new GridColumn
{
xname = @dr["xname"].ToString(),
SrNo = @dr["xcode"].ToString(),
xlink = @dr["xlink"].ToString()
});
}
}
if (dsList.Tables[1] != null)
{
foreach (System.Data.DataRow dr in ViewBag.GridHearder.Rows)
{
GridHearder.Add(new GridHearder
{
xname = @dr["xname"].ToString(),
SrNo = @dr["xcode"].ToString()
});
// var gf = GridColumn.Where(s => s.SrNo == dr["xcode"].ToString()).ToList();
}
}
}
_grid.GridColumn = GridColumn.ToList();
_grid.GridHearder = GridHearder.ToList();
lstGrid.Add(_grid);
return PartialView(lstGrid);
}