public OIExportJobSettingsEntity GetExportJobSettingsById(int Id)
{
OIExportJobSettingsEntity results = new OIExportJobSettingsEntity();
results = rep.GetExportJobSettingsById(Id);
return(results);
}
public ActionResult Index(OIExportJobSettingsEntity objExport)
{
try
{
string invalid = new string(Path.GetInvalidFileNameChars()) + new string(Path.GetInvalidPathChars());
foreach (char c in invalid)
{
objExport.FilePath = objExport.FilePath.Replace(c.ToString(), "");
}
objExport.FilePath = objExport.FilePath + ".zip";
objExport.UserId = Helper.oUser.UserId;
objExport.ApplicationId = this.CurrentClient.ApplicationId;
objExport.ExportType = ProviderType.OI.ToString();// Set provider type OI as it is from Orb Intelligence
if (Helper.oUser.UserRole == UserRole.LOB.ToString())
{
objExport.LOBTag = Helper.oUser != null ? (Helper.oUser.LOBTag != null ? Helper.oUser.LOBTag : "") : "";
}
OIExportJobSettingsFacade efac = new OIExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase));
efac.InserExportJobSettings(objExport);
return(Json(new { result = true, message = ExportLang.msgExportDataSave }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = false, message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet));
}
}
//Cancel Export process
public JsonResult CancelExportProcess(int Id)
{
try
{
OIExportJobSettingsFacade fac = new OIExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase));
OIExportJobSettingsEntity objOIExport = new OIExportJobSettingsEntity();
objOIExport = fac.GetExportJobSettingsById(Id);
if (objOIExport.ProcessStartDate == null)
{
fac.CancelExportJobSettings(objOIExport);
return(Json(new { result = true, message = ExportLang.msgJobCancel }, JsonRequestBehavior.AllowGet));
}
else if (objOIExport.ProcessStartDate != null && !objOIExport.IsProcessComplete)
{
return(Json(new { result = true, message = ExportLang.msgJobInProcess }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = false, message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { result = false, message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet));
}
}
public List <OIExportJobSettingsEntity> Adapt(DataTable dt)
{
List <OIExportJobSettingsEntity> results = new List <OIExportJobSettingsEntity>();
foreach (DataRow rw in dt.Rows)
{
OIExportJobSettingsEntity ExportJob = new OIExportJobSettingsEntity();
ExportJob = AdaptItem(rw, dt);
results.Add(ExportJob);
}
return(results);
}
internal void UpdateExportJobSettingsSentMail(OIExportJobSettingsEntity obj, bool IsEmailSent)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.UpdateExportJobSettingsSentMail";
sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsEmailSent", IsEmailSent.ToString(), SQLServerDatatype.BitDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
internal void CancelExportJobSettings(OIExportJobSettingsEntity obj)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "capp.CancelExportJobSettings"; // MP-846 Admin database cleanup and code cleanup.
sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", obj.UserId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ApplicationId", obj.ApplicationId.ToString(), SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
internal int UpdateExportJobDetails(OIExportJobSettingsEntity obj)
{
int result = 0;
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.UpdateExportJob";
sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Input", Convert.ToString(obj.Input), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@FilePath", string.IsNullOrEmpty(obj.FilePath) ? null : obj.FilePath.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MatchOutPut", obj.MatchOutPut.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Enrichment", obj.Enrichment.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TrasferedDuns", obj.TrasferedDuns.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ActiveDataQueue", obj.ActiveDataQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LCMQueue", obj.LCMQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@NoMatchQueue", obj.NoMatchQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsMonitoringNotifications", obj.IsMonitoringNotifications.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Format", obj.Format.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@APILayer", string.IsNullOrEmpty(obj.APILayer) ? null : Convert.ToString(obj.APILayer), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Delimiter", string.IsNullOrEmpty(obj.Delimiter) ? null : Convert.ToString(obj.Delimiter), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecID", string.IsNullOrEmpty(obj.SrcRecID) ? null : Convert.ToString(obj.SrcRecID), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsExactMatch", obj.SrcRecIdExactMatch.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tags", string.IsNullOrEmpty(obj.Tags) ? null : obj.Tags.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LOBTag", string.IsNullOrEmpty(obj.LOBTag) ? null : obj.LOBTag.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@RequestedDate", obj.RequestedDate != DateTime.MinValue ? obj.RequestedDate.ToString() : null, SQLServerDatatype.DateTimeDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ProcessStartDate", obj.ProcessStartDate != DateTime.MinValue ? obj.ProcessStartDate.ToString() : null, SQLServerDatatype.DateTimeDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ProcessEndDate", obj.ProcessEndDate != DateTime.MinValue ? obj.ProcessEndDate.ToString() : null, SQLServerDatatype.DateTimeDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MarkAsExported", obj.MarkAsExported.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsProcessComplete", obj.IsProcessComplete.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsAlreadyDownloaded", obj.IsAlreadyDownloaded.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsEmailSent", obj.IsEmailSent.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LastDownloadedDate", obj.LastDownloadedDate != DateTime.MinValue ? obj.LastDownloadedDate.ToString() : null, SQLServerDatatype.DateTimeDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsDeleted", obj.IsDeleted.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsCancelled", obj.IsCancelled.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsAlreadyNotify", obj.IsAlreadyNotify.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@HasHeader", obj.HasHeader.ToString(), SQLServerDatatype.BitDataType));
result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
return(result);
}
// MP-846 Admin database cleanup and code cleanup.-CLIENT
internal void DeleteOIExportJobSettings(OIExportJobSettingsEntity obj)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "capp.DeleteExportJobSettings";
sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", obj.UserId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ApplicationId", obj.ApplicationId.ToString(), SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
//result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
}
internal void UpdateExportJobSettings(OIExportJobSettingsEntity obj, bool IsPorcessStart, bool IsRevert)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.UpdateExportJobSettings";
sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsProcessComplete", obj.IsProcessComplete.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@FilePath", obj.FilePath == null ? null : obj.FilePath.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsPorcessStart", IsPorcessStart.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsRevert", IsRevert.ToString(), SQLServerDatatype.BitDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
//result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
}
public JsonResult Delete(int Id)
{
try
{
OIExportJobSettingsFacade fac = new OIExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase));
OIExportJobSettingsEntity objOIExport = new OIExportJobSettingsEntity();
objOIExport = fac.GetExportJobSettingsById(Id);
string url = Request.Url.Scheme + "://" + Request.Url.Authority + Url.Action("Login", "Account");
string[] hostParts = new System.Uri(url).Host.Split('.');
string domain = hostParts[0];
ImageHelper.DeleteBlobFile(domain, objOIExport.FilePath);
fac.DeleteOIExportJobSettings(objOIExport);
return(Json(new { result = true, message = CommonMessagesLang.msgCommanDeleteMessage }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = false, message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet));
}
}
internal int InserExportJobSettings(OIExportJobSettingsEntity obj)
{
int result = 0;
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "capp.InserExportJobSettings"; // MP-846 Admin database cleanup and code cleanup.
sproc.StoredProceduresParameter.Add(GetParam("@UserId", obj.UserId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tags", string.IsNullOrEmpty(obj.Tags) ? null : obj.Tags.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Input", string.IsNullOrEmpty(obj.Input) ? null : obj.Input.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LOBTag", string.IsNullOrEmpty(obj.LOBTag) ? null : obj.LOBTag.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MatchOutPut", obj.MatchOutPut.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Enrichment", obj.Enrichment.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ActiveDataQueue", obj.ActiveDataQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MarkAsExported", obj.MarkAsExported.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Format", obj.Format == null ? null : obj.Format.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ApplicationId", obj.ApplicationId.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Delimiter", string.IsNullOrEmpty(obj.Delimiter) ? null : obj.Delimiter.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecID", string.IsNullOrEmpty(obj.SrcRecID) ? null : obj.SrcRecID.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsExactatch", string.IsNullOrEmpty(obj.SrcRecIdExactMatch.ToString()) ? "false" : obj.SrcRecIdExactMatch.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@FileName", string.IsNullOrEmpty(obj.FilePath.ToString()) ? "" : obj.FilePath.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LCMQueue", obj.LCMQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@NoMatchQueue", obj.NoMatchQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TrasferedDuns", obj.TrasferedDuns.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ExportType", obj.ExportType.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CompanyTree", obj.CompanyTree.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@HasHeader", obj.HasHeader.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@HasTextQualifierToAll", obj.HasTextQualifierToAll.ToString(), SQLServerDatatype.BitDataType));
result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
return(result);
}
public OIExportJobSettingsEntity AdaptItem(DataRow rw, DataTable dt)
{
OIExportJobSettingsEntity result = new OIExportJobSettingsEntity();
if (dt.Columns.Contains("Id"))
{
result.Id = SafeHelper.GetSafeint(rw["Id"]);
}
if (dt.Columns.Contains("UserId"))
{
result.UserId = SafeHelper.GetSafeint(rw["UserId"]);
}
if (dt.Columns.Contains("Tags"))
{
result.Tags = SafeHelper.GetSafestring(rw["Tags"]);
}
if (dt.Columns.Contains("Input"))
{
result.Input = SafeHelper.GetSafestring(rw["Input"]);
}
if (dt.Columns.Contains("LOBTag"))
{
result.LOBTag = SafeHelper.GetSafestring(rw["LOBTag"]);
}
if (dt.Columns.Contains("MatchOutPut"))
{
result.MatchOutPut = SafeHelper.GetSafebool(rw["MatchOutPut"]);
}
if (dt.Columns.Contains("Enrichment"))
{
result.Enrichment = SafeHelper.GetSafebool(rw["Enrichment"]);
}
if (dt.Columns.Contains("ActiveDataQueue"))
{
result.ActiveDataQueue = SafeHelper.GetSafebool(rw["ActiveDataQueue"]);
}
if (dt.Columns.Contains("MarkAsExported"))
{
result.MarkAsExported = SafeHelper.GetSafebool(rw["MarkAsExported"]);
}
if (dt.Columns.Contains("Format"))
{
result.Format = SafeHelper.GetSafestring(rw["Format"]);
}
if (dt.Columns.Contains("FilePath"))
{
result.FilePath = SafeHelper.GetSafestring(rw["FilePath"]);
}
if (dt.Columns.Contains("RequestedDate"))
{
result.RequestedDate = SafeHelper.GetSafeDateTime(rw["RequestedDate"]);
}
if (dt.Columns.Contains("ProcessStartDate"))
{
if (rw["ProcessStartDate"] == DBNull.Value)
{
result.ProcessStartDate = null;
}
else
{
result.ProcessStartDate = Convert.ToDateTime(rw["ProcessStartDate"]);
}
}
if (dt.Columns.Contains("ProcessEndDate"))
{
if (rw["ProcessEndDate"] == DBNull.Value)
{
result.ProcessEndDate = null;
}
else
{
result.ProcessEndDate = Convert.ToDateTime(rw["ProcessEndDate"]);
}
}
if (dt.Columns.Contains("IsProcessComplete"))
{
result.IsProcessComplete = SafeHelper.GetSafebool(rw["IsProcessComplete"]);
}
if (dt.Columns.Contains("IsAlreadyDownloaded"))
{
result.IsAlreadyDownloaded = SafeHelper.GetSafebool(rw["IsAlreadyDownloaded"]);
}
if (dt.Columns.Contains("ApplicationId"))
{
result.ApplicationId = SafeHelper.GetSafeint(rw["ApplicationId"]);
}
if (dt.Columns.Contains("LastDownloadedDate"))
{
result.LastDownloadedDate = SafeHelper.GetSafeDateTime(rw["LastDownloadedDate"]);
}
if (dt.Columns.Contains("LastDownloadedUserId"))
{
result.LastDownloadedUserId = SafeHelper.GetSafeint(rw["LastDownloadedUserId"]);
}
if (dt.Columns.Contains("Delimiter"))
{
result.Delimiter = SafeHelper.GetSafestring(rw["Delimiter"]);
}
if (dt.Columns.Contains("SrcRecID"))
{
result.SrcRecID = SafeHelper.GetSafestring(rw["SrcRecID"]);
}
if (dt.Columns.Contains("IsExactMatch"))
{
result.SrcRecIdExactMatch = SafeHelper.GetSafebool(rw["IsExactMatch"]);
}
if (dt.Columns.Contains("IsEmailSent"))
{
result.IsEmailSent = SafeHelper.GetSafebool(rw["IsEmailSent"]);
}
if (dt.Columns.Contains("LCMQueue"))
{
result.LCMQueue = SafeHelper.GetSafebool(rw["LCMQueue"]);
}
if (dt.Columns.Contains("NoMatchQueue"))
{
result.NoMatchQueue = SafeHelper.GetSafebool(rw["NoMatchQueue"]);
}
if (dt.Columns.Contains("TrasferedDuns"))
{
result.TrasferedDuns = SafeHelper.GetSafebool(rw["TrasferedDuns"]); //Add DUNS Transfer to Export(MP-367)
}
if (dt.Columns.Contains("IsCancelled"))
{
result.IsCancelled = SafeHelper.GetSafebool(rw["IsCancelled"]);
}
if (dt.Columns.Contains("ProcessCancelledDateTime"))
{
if (rw["ProcessCancelledDateTime"] == DBNull.Value)
{
result.ProcessCancelledDateTime = null;
}
else
{
result.ProcessCancelledDateTime = Convert.ToDateTime(rw["ProcessCancelledDateTime"]);
}
}
if (dt.Columns.Contains("IsDeleted"))
{
result.IsDeleted = SafeHelper.GetSafebool(rw["IsDeleted"]);
}
if (dt.Columns.Contains("IsAlreadyNotify"))
{
result.IsAlreadyNotify = SafeHelper.GetSafebool(rw["IsAlreadyNotify"]);
}
if (dt.Columns.Contains("ExportType"))
{
result.ExportType = SafeHelper.GetSafestring(rw["ExportType"]);
}
if (dt.Columns.Contains("CompanyTree"))
{
result.CompanyTree = SafeHelper.GetSafebool(rw["CompanyTree"]);
}
if (dt.Columns.Contains("ErrorMessage"))
{
result.ErrorMessage = SafeHelper.GetSafestring(rw["ErrorMessage"]);
}
if (dt.Columns.Contains("HasTextQualifierToAll"))
{
result.HasTextQualifierToAll = SafeHelper.GetSafebool(rw["HasTextQualifierToAll"]);
}
if (dt.Columns.Contains("HasHeader"))
{
result.HasHeader = SafeHelper.GetSafebool(rw["HasHeader"]);
}
return(result);
}
public void CancelExportJobSettings(OIExportJobSettingsEntity obj)
{
rep.CancelExportJobSettings(obj);
}
// MP-846 Admin database cleanup and code cleanup.-CLIENT
public void DeleteOIExportJobSettings(OIExportJobSettingsEntity obj)
{
rep.DeleteOIExportJobSettings(obj);
}
public void UpdateExportJobSettingsSentMail(OIExportJobSettingsEntity obj, bool IsEmailSent)
{
rep.UpdateExportJobSettingsSentMail(obj, IsEmailSent);
}
public void UpdateExportJobSettings(OIExportJobSettingsEntity obj, bool IsPorcessStart, bool IsRevert)
{
rep.UpdateExportJobSettings(obj, IsPorcessStart, IsRevert);
}
public int UpdateExportJobDetails(OIExportJobSettingsEntity obj)
{
return(rep.UpdateExportJobDetails(obj));
}
public int InserExportJobSettings(OIExportJobSettingsEntity obj)
{
return(rep.InserExportJobSettings(obj));
}
