public ActionResult ResendInvoiceNotifications()
{
InvNotifications invNotifications = new InvNotifications();
invNotifications.LstPharmacies = dbCommon.GetList("Pharmacies", "Vmrx", null);
return(View(invNotifications));
}
public ActionResult UpdateResendInvNotif(InvNotifications ResendNotifications)
{
DBCommon commObj = new DBCommon();
DBQueries dbQueries = new DBQueries();
string query = string.Format(dbQueries.sqlUpdateResendInvoiceNotif, ResendNotifications.PharmacyCode, ResendNotifications.FacilityCode, ResendNotifications.Email, getUserId());
int result = commObj.GetNumwithQuery("UpdateResend", query, getUserId());
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult ResendInvoiceNotifications(InvNotifications ResendNotifications)
{
DBCommon commObj = new DBCommon();
DBQueries dbQueries = new DBQueries();
string query = string.Format(dbQueries.sqlResendInvNotifProcess, ResendNotifications.PharmacyCode, ResendNotifications.FacilityCode, ResendNotifications.Email);
var dtresult = commObj.ExecteReader(query, "Vmrx"); var result = 0; var lastInvoiedDate = "";
if (dtresult.Rows.Count > 0)
{
result = Convert.ToInt16(dtresult.Rows[0][0]); lastInvoiedDate = dtresult.Rows[0][1].ToString();
}
query = string.Format(dbQueries.sqlGetStatementDate, ResendNotifications.PharmacyCode, ResendNotifications.FacilityCode);
string statementdate = commObj.GetValue(query, "OnlineBilling");
var fresult = new { result, lastInvoiedDate, statementdate };
return(Json(fresult, JsonRequestBehavior.AllowGet));
}
