public bool PerformFileUploadOperation(MSI_MediaTracker _mediaTracker, int MediaTypeId, IEnumerable<HttpPostedFileBase> FilesCollection)
{
Cascade.Data.Repositories.MSIMediaTrackerRepository repository = new MSIMediaTrackerRepository();
string _allMediaDocuments = "";
string _additionalIdentifier = Guid.NewGuid().ToString() + "_" + _mediaTracker.Account + "_" + MediaTypeId.ToString();
//Get all fileNames together so store in the Database
foreach (var file in FilesCollection)
{
if (file != null)
{
if (_allMediaDocuments.Length > 0)
{
_allMediaDocuments = _allMediaDocuments + "|" + _additionalIdentifier + "_" + file.FileName;
}
else
{
_allMediaDocuments = _additionalIdentifier + "_" + file.FileName;
}
}
}
//Now Upload and set the properties
foreach (var file in FilesCollection)
{
if (file != null)
{
if (file.ContentLength > 0)
{
//Upload the file
fileProcessor.SaveUploadedFileWithIdentifier(file, _additionalIdentifier);
}
}
}
if (_allMediaDocuments != "")
{
//Perform Save Operation
_mediaTracker.MediaTypeId = MediaTypeId;
_mediaTracker.MediaDocuments = _allMediaDocuments;
repository.Add(_mediaTracker);
}
//response
return true;
}
public ActionResult UploadAllDocuments(IEnumerable<HttpPostedFileBase> AfdvtIssuerfiles, IEnumerable<HttpPostedFileBase> AfdvtSellerfiles,
IEnumerable<HttpPostedFileBase> Applicationfiles, IEnumerable<HttpPostedFileBase> Contactfiles,
IEnumerable<HttpPostedFileBase> Statementfiles, IEnumerable<HttpPostedFileBase> ChargeOffStmtfiles, IEnumerable<HttpPostedFileBase> RightOfCurefiles,
IEnumerable<HttpPostedFileBase> BalanceLtrfiles, IEnumerable<HttpPostedFileBase> NoticeOfIntentfiles,
IEnumerable<HttpPostedFileBase> CardHolderAgrmtfiles, IEnumerable<HttpPostedFileBase> TermAndCndfiles)
{
//Collect information from the hiddern fields
string PIMSAcctNumber = Request.Form["hdnpimsAccountNumber"];
string OrigAcctNumber = Request.Form["hdnoriginalAccountNumber"];
string hdnstatementStDt = Request.Form["hdnstatementStDt"];
string hdnstatementEndDt = Request.Form["hdnstatementEndDt"];
string hdnRedirectAction = Request.Form["hdnRedirectAction"];
//Get the Object
MSI_MediaTracker _mediaTracker = new MSI_MediaTracker();
//Get the necessary Information
_mediaTracker.Account = PIMSAcctNumber;
_mediaTracker.OriginalAccount = OrigAcctNumber;
_mediaTracker.CreatedDate = DateTime.Now;
_mediaTracker.CreatedBy = UserId.ToString();
_mediaTracker.IsActive = true;
//For Files
#region [[ Affedavit(Issuer) ]]
if (AfdvtIssuerfiles != null)
{
if (AfdvtIssuerfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 1, AfdvtIssuerfiles);
}
}
#endregion
#region [[ Affedavit(Seller) ]]
if (AfdvtSellerfiles != null)
{
if (AfdvtSellerfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 2, AfdvtSellerfiles);
}
}
#endregion
#region [[ Application ]]
if (Applicationfiles != null)
{
if (Applicationfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 3, Applicationfiles);
}
}
#endregion
#region [[ Contact ]]
if (Contactfiles != null)
{
if (Contactfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 4, Contactfiles);
}
}
#endregion
#region [[ Charge of Statement ]]
if (ChargeOffStmtfiles != null)
{
if (ChargeOffStmtfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 6, ChargeOffStmtfiles);
}
}
#endregion
#region [[ Right of Cure ]]
if (RightOfCurefiles != null)
{
if (RightOfCurefiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 7, RightOfCurefiles);
}
}
#endregion
#region [[ Balance Letter ]]
if (BalanceLtrfiles != null)
{
if (BalanceLtrfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 8, BalanceLtrfiles);
}
}
#endregion
#region [[ Notice of Intent ]]
if (NoticeOfIntentfiles != null)
{
if (NoticeOfIntentfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 9, NoticeOfIntentfiles);
}
}
#endregion
#region [[ Card Holder Agreement ]]
if (CardHolderAgrmtfiles != null)
{
if (CardHolderAgrmtfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 10, CardHolderAgrmtfiles);
}
}
#endregion
#region [[ Terms and Conditions ]]
if (TermAndCndfiles != null)
{
if (TermAndCndfiles.Count() >= 1)
{
PerformFileUploadOperation(_mediaTracker, 11, TermAndCndfiles);
}
}
#endregion
//IMPORTANT: Do it at the end so TypeConstraints are added for only Statement type media
#region [[ Statement ]]
if (Statementfiles != null)
{
if (Statementfiles.Count() >= 1)
{
if (hdnstatementStDt != "" && hdnstatementEndDt != "")
{
_mediaTracker.TypeConstraints = hdnstatementStDt + ":" + hdnstatementEndDt;
}
PerformFileUploadOperation(_mediaTracker, 5, Statementfiles);
}
}
#endregion
CascadeBusiness.MediaRequest business = new CascadeBusiness.MediaRequest();
business.PerfomPreFulfillmentProcess(PIMSAcctNumber, UserId);
//Exit
if (string.IsNullOrEmpty(hdnRedirectAction))
return RedirectToAction("Index", "Home");
else
return RedirectToAction(hdnRedirectAction, "Media");
}
public IEnumerable<MSI_MediaTracker> GetExistingUploadMediaDetails(string accountNumber)
{
DBFactory db;
SqlDataReader rdr;
List<MSI_MediaTracker> data = null;
try
{
db = new DBFactory();
rdr = db.ExecuteReader("MSI_spGetMediaTrackerByAccountNumber", new SqlParameter("@account", accountNumber));
data = new List<MSI_MediaTracker>();
MSI_MediaTracker record;
while (rdr.Read())
{
record = new MSI_MediaTracker();
record.Id = Convert.ToInt32(rdr["Id"].ToString());
record.Account = rdr["Account"].ToString();
record.OriginalAccount = rdr["OriginalAccount"].ToString();
record.MediaTypeId = Convert.ToInt32(rdr["MediaTypeId"].ToString());
record.MediaDocuments = rdr["MediaDocuments"].ToString();
record.TypeConstraints = rdr["TypeConstraints"].ToString();
data.Add(record);
}
//Close the datareader
rdr.Close();
}
catch (Exception ex)
{
throw new Exception("Exception in DataQueries.GetExistingUploadMediaDetails:" + ex.Message);
}
return data.AsEnumerable<MSI_MediaTracker>();
}
