public ActionResult ExportToCompanyData(ExportJobSettingsEntity 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.ExportType = ProviderType.DandB.ToString();// Set provider type DandB as it is from D & B
objExport.ApplicationId = this.CurrentClient.ApplicationId;
objExport.UserId = Helper.oUser.UserId;
objExport.FilePath = objExport.FilePath + ".zip";
if (Helper.oUser.UserRole == UserRole.LOB.ToString())
{
objExport.LOBTag = Helper.oUser != null ? (Helper.oUser.LOBTag != null ? Helper.oUser.LOBTag : "") : "";
}
ExportJobSettingsFacade efac = new ExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase));
efac.InserExportJobSettings(objExport);
return(Json(new { result = true, message = ExportLang.msgExportDataSave }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { result = false, message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet));
}
}
// Monitor Export Job Queue Details
// MP-846 Admin database cleanup and code cleanup.-CLIENT
public ExportJobSettingsEntity GetExportJobSettingsByIdByClient(int Id)
{
ExportJobSettingsEntity results = new ExportJobSettingsEntity();
results = rep.GetExportJobSettingsByIdByClient(Id);
return(results);
}
public JsonResult CancelExportProcess(int Id)
{
try
{
ExportJobSettingsFacade efac = new ExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase));
ExportJobSettingsEntity objExport = efac.GetExportJobSettingsByIdByClient(Id); // MP-846 Admin database cleanup and code cleanup.-CLIENT
if (objExport.ProcessStartDate == null)
{
efac.CancelExportJobSettings(objExport);
SessionHelper.ExportView_Message = ExportLang.msgJobCancel;
}
else if (objExport.ProcessStartDate != null && !objExport.IsProcessComplete)
{
SessionHelper.ExportView_Message = ExportLang.msgJobInProcess;
}
return(new JsonResult {
Data = CommonMessagesLang.msgSuccess
});
}
catch (Exception ex)
{
SessionHelper.ExportView_Message = ex.Message.ToString();
return(new JsonResult {
Data = CommonMessagesLang.msgFail
});
}
}
internal void UpdateExportJobSettingsSentMail(ExportJobSettingsEntity 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(ExportJobSettingsEntity 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;
}
}
// MP-846 Admin database cleanup and code cleanup.-MASTER
internal void DeleteExportJobSettingsForMaster(ExportJobSettingsEntity obj)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.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(ExportJobSettingsEntity obj, bool IsPorcessStart, bool IsRevert, int RetryCount, string ErrorMessage)
{
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));
sproc.StoredProceduresParameter.Add(GetParam("@RetryCount", RetryCount.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ErrorMessage", !string.IsNullOrEmpty(Convert.ToString(ErrorMessage)) ? ErrorMessage.ToString() : null, SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
//result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
}
internal int InserExportJobSettings(ExportJobSettingsEntity 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 JsonResult Delete(int Id)
{
try
{
ExportJobSettingsFacade efac = new ExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase));
ExportJobSettingsEntity objExport = efac.GetExportJobSettingsByIdByClient(Id); // MP-846 Admin database cleanup and code cleanup.-CLIENT
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, objExport.FilePath);
efac.DeleteExportJobSettingsForClients(objExport); // MP-846 Admin database cleanup and code cleanup.-CLIENT
SessionHelper.ExportView_Message = CommonMessagesLang.msgCommanDeleteMessage;
return(new JsonResult {
Data = CommonMessagesLang.msgSuccess
});
}
catch (Exception ex)
{
SessionHelper.ExportView_Message = ex.Message.ToString();
return(new JsonResult {
Data = CommonMessagesLang.msgFail
});
}
}
// MP-846 Admin database cleanup and code cleanup.-MASTER
public void DeleteExportJobSettingsForMaster(ExportJobSettingsEntity obj)
{
rep.DeleteExportJobSettingsForMaster(obj);
}
// Deletes export job queue
// MP-846 Admin database cleanup and code cleanup.-CLIENT
public void DeleteExportJobSettingsForClients(ExportJobSettingsEntity obj)
{
rep.DeleteExportJobSettingsForClients(obj);
}
public void UpdateExportJobSettingsSentMail(ExportJobSettingsEntity obj, bool IsEmailSent)
{
rep.UpdateExportJobSettingsSentMail(obj, IsEmailSent);
}
public void UpdateExportJobSettings(ExportJobSettingsEntity obj, bool IsPorcessStart, bool IsRevert, int RetryCount = 0, string ErrorMessage = null)
{
rep.UpdateExportJobSettings(obj, IsPorcessStart, IsRevert, RetryCount, ErrorMessage);
}
public int InserExportJobSettings(ExportJobSettingsEntity obj)
{
return(rep.InserExportJobSettings(obj));
}
public void CancelExportJobSettings(ExportJobSettingsEntity obj)
{
rep.CancelExportJobSettings(obj);
}
