public bool ToggleUninvoicedApproval(int approvalId, int uidCmpgn)
{
List <System.Data.SqlClient.SqlParameter> spParams = new List <System.Data.SqlClient.SqlParameter>();
if (approvalId != -1)
{
spParams.Add(Param.CreateParam("APPROVALID", SqlDbType.Int, approvalId));
}
else
{
spParams.Add(Param.CreateParam("UID_CMPGN", SqlDbType.Int, uidCmpgn));
spParams.Add(Param.CreateParam("APPROVEDBY", SqlDbType.VarChar, Security.GetFullUserNameFromId(Security.GetCurrentUserId)));
}
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("QUATTRO_TOGGLEUNINVOICEDAPPROVAL", spParams));
}
return(true);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return(false);
}
}
public string GetInvoicesByContract(string contractNumber, string companyId)
{
try
{
StringBuilder invoiceNumberList = new StringBuilder();
DataSet invoiceNumbers;
using (IO io = new IO(WebCommon.ConnectionString))
{
invoiceNumbers = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("QUATTRO_GETINVOICENUMBERSBYCONTRACT",
Param.CreateParam("CONTRACTNUMBER", SqlDbType.VarChar, contractNumber),
Param.CreateParam("COMPANYID", SqlDbType.Int, companyId)));
}
if (invoiceNumbers.Tables[0].Rows.Count == 0)
{
return(string.Empty);
}
foreach (DataRow row in invoiceNumbers.Tables[0].Rows)
{
if (!String.IsNullOrEmpty(invoiceNumberList.ToString()))
{
invoiceNumberList.Append(",");
}
invoiceNumberList.Append(Convert.ToString(row[0]));
}
return(invoiceNumberList.ToString());
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception(string.Format("An error occurred while trying to retrieve the Invoice Numbers for Contract: {0}", contractNumber));
}
}
public bool AddCreditCheckNote(int id, string contractNumber, string companyId, string creditAppReq, string creditChecked, string notes)
{
try
{
string enteredBy = Security.GetCurrentUserId;
using (IO io = new IO(WebCommon.ConnectionString))
{
using (System.Data.SqlClient.SqlCommand cmd = IO.CreateCommandFromStoredProc("COLLECTIONS_ADDCREDITCHECKNOTE"))
{
cmd.Parameters.Add(Param.CreateParam("CONTRACTNUMBER", SqlDbType.Int, Convert.ToInt32(contractNumber)));
cmd.Parameters.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(companyId)));
cmd.Parameters.Add(Param.CreateParam("CREDITAPPPREPAY", SqlDbType.VarChar, creditAppReq));
cmd.Parameters.Add(Param.CreateParam("CREDITCHECKED", SqlDbType.VarChar, creditChecked));
cmd.Parameters.Add(Param.CreateParam("NOTES", SqlDbType.NText, notes));
cmd.Parameters.Add(Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, enteredBy));
io.ExecuteActionQuery(cmd);
}
}
return(true);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return(false);
}
}
public List <SpotConflict> SaveMultiStationSpot(Spot spot, int numberOfWeeks, List <int> stationIds)
{
try
{
spot.EnteredBy = Security.GetCurrentUserId;
spot.EnteredOn = DateTime.Now;
spot.LastUpdatedBy = Security.GetCurrentUserId;
spot.LastUpdatedOn = DateTime.Now;
DataTable stations = PopulateStationIdTable(stationIds);
List <SpotConflict> conflicts = Spot.SaveMultiStationSpot(spot, stations);
int prevMonth = spot.Month;
for (int i = 1; i < numberOfWeeks; i++)
{
spot.SpotDate = spot.SpotDate.AddDays(7);
spot.Year = spot.SpotDate.Year;
spot.Month = spot.SpotDate.Month;
spot.Week = (spot.SpotDate.Month == prevMonth ? spot.Week + 1 : 1);
prevMonth = spot.SpotDate.Month;
foreach (SpotConflict conflict in Spot.SaveMultiStationSpot(spot, stations))
{
conflicts.Add(conflict);
}
//conflicts.Add(Spot.SaveMultiStationSpot(spot, stations));
}
return(conflicts);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to add the spot.");
}
}
public bool SendCCNNotificationEmail(int uidCmpgn, int companyId, string contractNumber, string attachmentUserId, int attachmentId)
{
//Make sure a notification email hasn't already been sent.
if (IsCCNEMailSent(uidCmpgn, attachmentId, true))
{
WebCommon.LogExceptionInfo(new Exception(string.Format("A notification email has already been sent for this contract: {0}. Please refresh your grid.", uidCmpgn)));
return(false);
}
try
{
List <System.Data.SqlClient.SqlParameter> spParams = new List <System.Data.SqlClient.SqlParameter>();
spParams.Add(Param.CreateParam("UIDCMPGN", SqlDbType.Int, uidCmpgn));
spParams.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, companyId));
spParams.Add(Param.CreateParam("ADDEDBY", SqlDbType.VarChar, Security.GetFullUserNameFromId(Security.GetCurrentUserId)));
spParams.Add(Param.CreateParam("ISNOTIFICATIONEMAILSENT", SqlDbType.Int, -1));
spParams.Add(Param.CreateParam("ATTACHMENTID", SqlDbType.Int, attachmentId));
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("QUATTRO_CCNREPORT_TOGGLENOTIFICATIONEMAILFLAG", spParams));
}
SendCCNEmail(false, contractNumber, attachmentUserId);
return(true);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to send the Notification email.");
}
}
public Booking LoadBookingById(int bookingId)
{
try
{
DataSet bookingData;
using (IO io = new IO(WebCommon.ConnectionString))
{
bookingData = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("Production_GetBookingById", Param.CreateParam("BOOKINGID", SqlDbType.Int, bookingId)));
}
return(new Booking(Convert.ToInt32(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "LOCATION_ID", -1))
, bookingId
, Convert.ToString(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "BOOKING_DESC", ""))
, Convert.ToDateTime(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "BOOKING_START_DATE", DateTime.MinValue))
, Convert.ToDateTime(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "BOOKING_END_DATE", DateTime.MaxValue))
, Convert.ToInt32(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "BOOKING_STATUS_ID", -1))
, Convert.ToString(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "BOOKING_STATUS_DESC", ""))
, Convert.ToString(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "BOOKING_COMMENTS", ""))
, Convert.ToString(IO.GetDataRowValue(bookingData.Tables[0].Rows[0], "AE_NTID", "-1"))
));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve Booking data.");
}
}
public XmlDocument GetInvoiceLineGlOverrideAuditGrid(int page, int rows, string sidx, string sord, bool _search, string contractNumber, string companyId)
{
XmlDocument xmlDoc = new XmlDocument();
try
{
DataSet ds;
using (IO io = new IO(WebCommon.ConnectionString))
{
ds = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("Quattro_GetInvoiceLineGLOverrideAudit",
Param.CreateParam("CONTRACTNUMBER", SqlDbType.VarChar, contractNumber),
Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(companyId))));
}
DataTable table = ds.Tables[0];
//Sort the table based on the sort index and sort direction
DataView sortedView = new DataView(table);
table = sortedView.ToTable();
table.DefaultView.RowFilter = "";
xmlDoc.LoadXml(WebCommon.GetGridData(table, string.Empty, page, rows));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
}
return(xmlDoc);
}
public List <AEFlatRate> GetAEFlatRates(string aeId, int companyId)
{
try
{
return(AEFlatRate.GetAEFlatRates(aeId, companyId));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Flat Rate data.");
}
}
public AEFlatRate GetAEFlatRateRecord(int aeFlatRateId)
{
try
{
return(new AEFlatRate(aeFlatRateId));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Flat Rate record.");
}
}
public AEDrawPayment GetAEDrawPaymentRecord(int aeDrawPaymentId)
{
try
{
return(new AEDrawPayment(aeDrawPaymentId));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Draw/Payment record.");
}
}
public void DeleteAEFlatRateRecord(int aeFlatRateId)
{
try
{
AEFlatRate.DeleteRecord(aeFlatRateId);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to delete the Flat Rate record.");
}
}
public void AddAEFlatRateRecord(AEFlatRate aeFlatRate)
{
try
{
aeFlatRate.Save();
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Flat Rate record.");
}
}
public void DeleteSpot(int spotId)
{
try
{
Spot.DeleteSpot(spotId);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to delete the spot.");
}
}
public SpotCampaignDetail GetSpotCampaignDetail(Spot spot)
{
try
{
return(SpotCampaignDetail.GetSpotCampaignDetail(spot.StationId, spot.StationSpotId, spot.SpotDate, spot.CampaignName, spot.CampaignNumber));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occured while trying to retrieve the Campaign detail for the selected spot.");
}
}
public List <CampaignSearchResult> ExecuteCampaignSearch(string campaignSearchText)
{
try
{
return(CampaignSearchResult.ExecuteCampaignSearch(campaignSearchText));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(new Exception(string.Format("An error occurred while trying to execute a Campaign search for the following text: {0}.", campaignSearchText), ex));
throw new Exception("An error occurred while trying to execute the Campaign search.");
}
}
public void AddAEDrawPaymentRecord(AEDrawPayment aeDrawPayment)
{
try
{
aeDrawPayment.Save();
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Draw/Payment record.");
}
}
public bool CheckExistingFlatRateEffectiveDate(string aeId, int companyId, DateTime flatRateEffectiveDate)
{
try
{
return(AEFlatRate.CheckExistingFlatRateEffectiveDate(aeId, companyId, flatRateEffectiveDate));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while checking for existing effective dates.");
}
}
public bool CheckExistingCommissionAmountYear(string aeId, int companyId, int year)
{
try
{
return(AECommissionAmount.CheckExistingCommissionAmountYear(aeId, companyId, year));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while checking for existing commission amount years.");
}
}
public void DeleteAEDrawPaymentRecord(int aeDrawPaymentId)
{
try
{
AEDrawPayment.DeleteRecord(aeDrawPaymentId);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to delete the Draw/Payment record.");
}
}
public List <AEDrawPayment> GetAEDrawPayments(string aeId, int companyId)
{
try
{
return(AEDrawPayment.GetAEDrawPayments(aeId, companyId));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Draw/Payment data.");
}
}
public void AddAECommissionAmountRecord(AECommissionAmount aeCommissionAmount)
{
try
{
aeCommissionAmount.Save();
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to add the Commission Amount record.");
}
}
public Spot LoadSpot(int spotId)
{
try
{
Spot spot = new Spot(spotId);
return(spot);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to load the spot.");
}
}
public Station GetStationInfoWithMatrix(StationOptions stationOptions)
{
try
{
Station station = new Station(stationOptions);
return(station);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(new Exception(string.Format("An error occurred while trying to load info for StationId: {0}", stationOptions.stationId), ex));
throw new Exception("An error occurred while trying to load the Station info.");
}
}
public List <Avails> GetAvails(int year, string market)
{
try
{
List <Avails> availsList = Avails.GetAvails(year, market);
return(availsList);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occured while trying to retrieve the Avails List.");
}
}
/// <summary>Deletes the file at the specified path if it exists</summary>
/// <param name="path">The path to the file to be deleted</param>
public static void DeleteFile(string path)
{
try
{
if (File.Exists(path))
{
File.Delete(path);
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(new Exception("An attempt to delete a file failed.", ex));
}
}
public XmlDocument GetMTAInvoiceNotesGrid(int page, int rows, string sidx, string sord, bool _search)
{
XmlDocument xmlDoc = new XmlDocument();
string searchField = string.Empty;
string searchString = string.Empty;
string searchFilter = string.Empty;
if (_search)
{
searchField = HttpContext.Current.Request["searchField"];
searchString = HttpContext.Current.Request["searchString"];
//spParams.Add(searchField, searchString);
if (String.IsNullOrEmpty(searchString))
{
searchFilter = string.Format("AND [{0}] IS NULL", searchField);
}
else
{
searchFilter = string.Format("AND [{0}] LIKE '%{1}%'", searchField, searchString);
}
}
try
{
DataSet ds;
using (IO io = new IO(WebCommon.ConnectionString))
{
using (System.Data.SqlClient.SqlCommand cmd = IO.CreateCommandFromStoredProc("Collections_GetMTAInvoiceNotesGrid"))
{
if (!String.IsNullOrEmpty(sidx))
{
cmd.Parameters.Add(Param.CreateParam("SORTBY", SqlDbType.VarChar, sidx));
}
if (!String.IsNullOrEmpty(sord))
{
cmd.Parameters.Add(Param.CreateParam("SORTDIR", SqlDbType.VarChar, sord));
}
ds = io.ExecuteDataSetQuery(cmd);
}
}
DataTable table = ds.Tables[0];
string filter = string.Format("(1=1) {0}", searchFilter);
xmlDoc.LoadXml(WebCommon.GetGridData(table, filter, page, rows));
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
}
return(xmlDoc);
}
public List <Quattro.Attachment> ExecuteAttachmentSearch(Quattro.AttachmentSearchParams searchParams)
{
try
{
List <System.Data.SqlClient.SqlParameter> spParams = new List <System.Data.SqlClient.SqlParameter>();
if (searchParams.contractNumber != null && searchParams.contractNumber.Count > 0)
{
spParams.Add(Param.CreateParam("CONTRACTNUMBERS", SqlDbType.Structured, GetContractNumberTable(searchParams.contractNumber)));
}
if (searchParams.invoiceNumber != null && searchParams.invoiceNumber.Count > 0)
{
spParams.Add(Param.CreateParam("INVOICENUMBERS", SqlDbType.Structured, GetInvoiceNumberTable(searchParams.invoiceNumber)));
}
if (!String.IsNullOrEmpty(searchParams.advertiser))
{
spParams.Add(Param.CreateParam("ADVERTISER", SqlDbType.VarChar, searchParams.advertiser));
}
if (searchParams.uidObjectType != -1 && searchParams.uidObjectType != 0)
{
spParams.Add(Param.CreateParam("UIDOBJECTTYPE", SqlDbType.Int, searchParams.uidObjectType));
}
spParams.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, searchParams.companyId));
DataSet attachmentData;
using (IO io = new IO(WebCommon.ConnectionString))
{
attachmentData = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("Quattro_ExecuteAttachmentSearch", spParams));
}
List <Quattro.Attachment> attachments = new List <Quattro.Attachment>();
foreach (DataRow row in attachmentData.Tables[0].Rows)
{
attachments.Add(new Quattro.Attachment(Convert.ToString(row["ATTACHMENT_ID"])
, Convert.ToString(row["ATTACHMENT_EXT"])
, Convert.ToString(row["ATTACHMENT_NAME"])
, Convert.ToString(row["ATTACHMENT_TITLE"])
, Convert.ToString(row["ATTACHMENT_DESC"])
, Convert.ToString(row["ATTACHMENT_TYPE"])
, Convert.ToInt32(row["ATTACHMENT_TYPE_ID"])
, Convert.ToDateTime(row["ATTACHMENT_DATE"])
, Convert.ToString(row["CONTRACT_NUMBER"])
, searchParams.companyId));
}
return(attachments);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to search for attachments.");
}
}
public Spot UpdateSpot(Spot spot)
{
try
{
spot.LastUpdatedBy = Security.GetCurrentUserId;
spot.LastUpdatedOn = DateTime.Now;
spot.Update();
return(spot);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to update the spot.");
}
}
public void DeleteBooking(int bookingId)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("PRODUCTION_DELETEBOOKING", Param.CreateParam("BOOKINGID", SqlDbType.Int, bookingId)));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to delete the Booking.");
}
}
public void DeleteLocation(int locationId)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("Production_DeleteLocation", Param.CreateParam("LOCATIONID", SqlDbType.Int, locationId)));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(new Exception(string.Format("An error occurred while trying to delete location id: {0}. Inner Exception: {1}", locationId, ex.InnerException)));
throw new Exception("An error occurred while trying to delete the location.");
}
}
