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)); }