internal void InsertOrUpdateUserSessionFilter(UserSessionFilterEntity obj)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.AddUserSessionFilter";
sproc.StoredProceduresParameter.Add(GetParam("@UserId", obj.UserId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", (obj.SrcRecordId != null) ? obj.SrcRecordId.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CompanyName", (obj.CompanyName != null) ? obj.CompanyName.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@City", (obj.City != null) ? obj.City.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@State", (obj.State != null) ? obj.State.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CountryISOAlpha2Code", (obj.CountryISOAlpha2Code != null) ? obj.CountryISOAlpha2Code.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@OrderByColumn", (obj.OrderByColumn != null) ? obj.OrderByColumn.ToString().Trim() : "SrcRecordId", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tag", (obj.Tag != null) ? obj.Tag.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CountryGroupId", (obj.CountryGroupId > 0) ? obj.CountryGroupId.ToString() : null, SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ImportProcess", (obj.ImportProcess != null) ? obj.ImportProcess.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ErrorCode", (!string.IsNullOrEmpty(obj.ErrorCode)) ? obj.ErrorCode.Trim() : null, SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
internal UserSessionFilterEntity GetUserSessionFilterByUserId(int UserID)
{
UserSessionFilterEntity results = new UserSessionFilterEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetUserSessionFilterByUserId";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = "@UserId";
param.ParameterValue = UserID.ToString();
sproc.StoredProceduresParameter.Add(param);
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new UserSessionFilterAdapter().Adapt(dt).FirstOrDefault();
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
public static List <TagsEntity> GetAllTags(string ConnectionString)
{
// Get All tags from the database and fill the dropdown
List <TagsEntity> model = new List <TagsEntity>();
TagFacade fac = new TagFacade(ConnectionString);
model = fac.GetAllTags(Helper.oUser.LOBTag);
return(model);
}
public ActionResult popupUserFilter(UserSessionFilterEntity model)
{
// Save data to database for Session Filter.
UserSessionFacade fac = new UserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);
int id = model.UserId;
model.UserId = Helper.oUser.UserId;
fac.InsertOrUpdateUserSessionFilter(model);
ViewBag.Message = id > 0 ? "Data created successfully." : "Data updated successfully.";
ViewBag.CloseAlert = "<script type='text/javascript'>$(document).ready(function(){parent.backToparent2();});</script>";
TempData.Keep();
return(PartialView("_popupUserFilter", model));
}
public ActionResult popupUserFilterJson(string UserId)
{
UserSessionFacade fac = new UserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);
model = fac.GetUserSessionFilterByUserId(Helper.oUser.UserId);
if (model.UserId > 0)
{
model.OrderByColumn = model.OrderByColumn == null ? "SrcRecordId" : model.OrderByColumn;
}
else
{
model = new UserSessionFilterEntity();
model.OrderByColumn = "SrcRecordId";
}
TempData.Keep();
return(Json(new { Data = model }, JsonRequestBehavior.AllowGet));
}
public ActionResult popupUserFilter(string UserId)
{
// Open Session filter popup and set data to Popup
UserSessionFacade fac = new UserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);
model = fac.GetUserSessionFilterByUserId(Helper.oUser.UserId);
if (model.UserId > 0)
{
model.OrderByColumn = model.OrderByColumn == null ? "SrcRecordId" : model.OrderByColumn;
}
else
{
model = new UserSessionFilterEntity();
model.OrderByColumn = "SrcRecordId";
}
TempData.Keep();
return(PartialView("_popupUserFilter", model));
}
public ActionResult SaveImportFiler(string ImportProcess, string From)
{
if (!string.IsNullOrEmpty(ImportProcess))
{
ImportProcess = StringCipher.Decrypt(ImportProcess, General.passPhrase);
UserSessionFacade fac = new UserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);
model = fac.GetUserSessionFilterByUserId(Helper.oUser.UserId);
if (model.ImportProcess != ImportProcess)
{
model.ImportProcess = ImportProcess;
fac.InsertOrUpdateUserSessionFilter(model);
}
}
if (From == "MatchData")
{
return(RedirectToAction("Index", "StewardshipPortal"));
}
else
{
return(RedirectToAction("Index", "BadInputData"));
}
}
public void InsertOrUpdateUserSessionFilter(UserSessionFilterEntity obj)
{
rep.InsertOrUpdateUserSessionFilter(obj);
}
public ActionResult FilterCleanData(List <FilterData> filters)
{
UserSessionFilterEntity filtermodel = new UserSessionFilterEntity();
foreach (var item in filters)
{
if (item.FieldName == "SrcRecordId")
{
filtermodel.SrcRecordId = item.FilterValue;
}
else if (item.FieldName == "CompanyName")
{
filtermodel.CompanyName = item.FilterValue;
}
else if (item.FieldName == "City")
{
filtermodel.City = item.FilterValue;
}
else if (item.FieldName == "State")
{
filtermodel.State = item.FilterValue;
}
else if (item.FieldName == "Country")
{
filtermodel.CountryISOAlpha2Code = item.FilterValue;
}
else if (item.FieldName == "ImportProcess")
{
filtermodel.ImportProcess = item.FilterValue;
}
else if (item.FieldName == "CountryGroup")
{
filtermodel.CountryGroupId = Convert.ToInt32(item.FilterValue);
}
else if (item.FieldName == "Tag")
{
filtermodel.Tag = item.FilterValue;
}
else if (item.FieldName == "OrderByColumn")
{
filtermodel.OrderByColumn = item.FilterValue;
}
else if (item.FieldName == "ErrorCode")
{
filtermodel.ErrorCode = item.FilterValue;
}
}
filtermodel.UserId = Helper.oUser.UserId;
int pagenumber = 0;
if (string.IsNullOrEmpty(Convert.ToString(SessionHelper.BadInputData_IsFirstTimeFilter)) || !SessionHelper.BadInputData_IsFirstTimeFilter)
{
UserSessionFacade fac = new UserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.InsertOrUpdateUserSessionFilter(filtermodel);
pagenumber = 1;
}
else
{
if (SessionHelper.BadInputData_IsFirstTimeFilter)
{
pagenumber = 1;
}
else
{
if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPage))
{
pagenumber = Convert.ToInt32(SessionHelper.CleanMatchPage);
}
else
{
pagenumber = 1;
}
}
}
SessionHelper.BadInputData_IsFirstTimeFilter = false;
int totalCount = 0;
int pagevalue = 0;
if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPageNo))
{
pagevalue = Convert.ToInt32(SessionHelper.CleanMatchPageNo);
}
if (pagevalue == null || pagevalue == 0)
{
SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
pagevalue = Convert.ToInt32(sfac.GetDefaultPageSize(Helper.oUser.UserId, "BadInputData"));
pagevalue = pagevalue == 0 ? 10 : pagevalue;
}
pagevalue = pagevalue < 5 ? 5 : pagevalue;
BadInputDataModel model = new BadInputDataModel();
CompanyFacade cfac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName);
Tuple <List <CompanyEntity>, string> tuplecompany = cfac.GetBIDCompany(Helper.oUser.UserId, 1, pagevalue, out totalCount);
model.Companies = tuplecompany.Item1;
SessionHelper.CleanQueueMessage = tuplecompany.Item2;
SessionHelper.CleanMatchPage = pagenumber.ToString();
SessionHelper.CleanMatchPageNo = Convert.ToString(pagevalue);
SessionHelper.CleanTotalCount = Convert.ToString(totalCount);
SessionHelper.CleanMatchedCompany = JsonConvert.SerializeObject(model.Companies);
IPagedList <CompanyEntity> pagedCompany = new StaticPagedList <CompanyEntity>(model.Companies.ToList(), pagenumber, pagevalue, totalCount);// Set model of Company entity to pass this model to view.
return(PartialView("_Index", pagedCompany));
}
