public ActionResult PriorCharge()
{ //Model Class 'InvoiceDownLoad' contains LstPharmacies property.
InvoiceDownLoad IncPriorDownload = new InvoiceDownLoad();
IncPriorDownload.LstPharmacies = db.GetList("Pharmacies", "Vmrx", null);
return(View(IncPriorDownload));
}
public ActionResult InvoiceDownload()
{
InvoiceDownLoad invDownload = new InvoiceDownLoad();
invDownload.LstPharmacies = dbCommon.GetList("Pharmacies", "Vmrx", null);
invDownload.LstCorporations = dbCommon.GetList("Corporations", "Vmrx", null);
return(View(invDownload));
}
public List <InvoiceDownLoad> DownloadPDF(List <string> fileNames, InvoiceDownLoad info)
{
List <InvoiceDownLoad> lstInvoiceDownLoad = new List <Models.InvoiceDownLoad>();
try
{
string query = "";
var files = "";
string sqlQuery = string.Format(dbQueries.sqlFacilityype, info.PharmacyCode, info.FacilityCode, info.CorpCode);
int facType = ExcecuteScalar(sqlQuery, "PharmericaCommon");
if (string.IsNullOrEmpty(info.PharmacyCode))
{
sqlQuery = string.Format(dbQueries.sqlPharmacyCode, info.PharmacyCode, info.FacilityCode, info.CorpCode);
info.PharmacyCode = ExcecuteScalar(sqlQuery, "PharmericaCommon").ToString();
}
foreach (var file in fileNames)
{
files = files + "'" + file + "',";
}
if (facType == 1)
{
query = string.Format(dbQueries.sqlPdmiInvoice, files.Remove(files.Length - 1), info.PharmacyCode + '-' + info.FacilityCode);
}
else
{
query = string.Format(dbQueries.sqlFfsinvoicedownload, files.Remove(files.Length - 1), info.PharmacyCode + '-' + info.FacilityCode);
}
using (var connection = GetDbConnection("OnlineBilling"))
{
using (SqlCommand cmd = new SqlCommand(query, connection))
{
connection.Open();
SqlDataReader dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
InvoiceDownLoad InDld = new InvoiceDownLoad();
string fileName = string.Empty;
InDld.FileName = dr1["FileName"].ToString();
InDld.ID = dr1["ID"].ToString();
InDld.Archived = dr1["Archieve"].ToString();
InDld.isPdmi = facType;
if (facType == 0)
{
InDld.FfsOld = dr1["GetFile"].ToString();
}
string file = fileName;
lstInvoiceDownLoad.Add(InDld);
}
dr1.Close();
}
}
}
catch (Exception msg)
{
}
return(lstInvoiceDownLoad);
}
public ActionResult InvoiceDownload(InvoiceDownLoad invoiceDownload)
{
DateTime startDate = DateTime.ParseExact(invoiceDownload.StatementDate, "MM-dd-yyyy", null);
DateTime endDate = DateTime.ParseExact(invoiceDownload.EndDate, "MM-dd-yyyy", null);
List <string> fileNames = new List <string>();
for (DateTime date = startDate; date <= endDate; date = date.AddDays(1))
{
fileNames.Add("'+@accountno +'-" + date.ToString("MMddyyyy") + ".pdf");
}
var data = dbCommon.DownloadPDF(fileNames, invoiceDownload);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public InvoiceDownLoad GetFile(int id, int isPdmi, string isffsOld, string archived)
{
InvoiceDownLoad InDld = new InvoiceDownLoad(); string sqlQuery = "";
if (isPdmi == 1 && archived == "NARC")
{
sqlQuery = string.Format(dbQueries.sqlPdmiinvoiceblob, id);
}
else if (isPdmi == 1 && archived == "ARC")
{
sqlQuery = string.Format(dbQueries.sqlArchPdmiinvoiceblob, id);
}
else if (isPdmi == 0 && isffsOld == "NEW" && archived == "NARC")
{
sqlQuery = string.Format(dbQueries.sqlNewFfsinvoiceblob, id);
}
else if (isPdmi == 0 && isffsOld == "OLD" && archived == "NARC")
{
sqlQuery = string.Format(dbQueries.sqlOldFfsinvoiceblob, id);
}
else if (isPdmi == 0 && isffsOld == "NEW" && archived == "ARC")
{
sqlQuery = string.Format(dbQueries.sqlArchNewFfsinvoiceblob, id);
}
else if (isPdmi == 0 && isffsOld == "OLD" && archived == "ARC")
{
sqlQuery = string.Format(dbQueries.sqlArchOldFfsinvoiceblob, id);
}
using (var connection = GetDbConnection("OnlineBilling"))
{
using (SqlCommand cmd = new SqlCommand(sqlQuery, connection))
{
connection.Open();
SqlDataReader dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
string fileName = string.Empty;
InDld.FileName = dr1["FileName"].ToString();
InDld.BlobData = (byte[])dr1.GetValue(1);
}
dr1.Close();
}
}
return(InDld);
}
