/// <summary>
/// 修改开票信息
/// </summary>
/// <param name="model">开票实体</param>
/// <returns>true 成功，false失败</returns>
public static bool UpdateBillingInfo(BillingModel model)
{
if (model == null)
{
return(false);
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(model.BillingNum, 0);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = BillingDBHelper.UpdateBillingInfo(model);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, 0, ex);
return(false);
}
}
public BillingModel GetCustomerOrderDetailsByOrderId(BillingModel model)
{
BillingModel _BillingModel = new BillingModel();
_BillingModel.BillingList = new List <BillingModel>();
var orderDetails = _OrderRepository.GetById(model.OrderId);
if (orderDetails != null)
{
_BillingModel.SubTotal = orderDetails.ActualPrice;
_BillingModel.GrandTotal = orderDetails.TotalPrice;
_BillingModel.Discount = orderDetails.Discount;
_BillingModel.Adjustment = orderDetails.Adjustment;
_BillingModel.CustomerName = orderDetails.Customer.CustomerName;
if (orderDetails.OrderDetails != null && orderDetails.OrderDetails.Any())
{
_BillingModel.BillingList = (from @orderDetailsBill in orderDetails.OrderDetails select new BillingModel {
ProductNameId = (@orderDetailsBill.Product != null)? @orderDetailsBill.Product.ID:0,
ProductName = (@orderDetailsBill.Product != null) ? @orderDetailsBill.Product.ProductName : string.Empty,
ProductQuantity = @orderDetailsBill.Quantity,
ProductPrice = @orderDetailsBill.UnitPrice,
ProductAmount = @orderDetailsBill.TotalPrice,
ProductDiscount = orderDetailsBill.Discount
}).ToList();
}
}
return(_BillingModel);
}
public ActionResult SearchByTodayTransaction()
{
BillingModel model = new BillingModel();
model.TransactionDate = DateTime.Now;
return(View(model));
}
public ActionResult Payment(PaymentBillingViewModel payBillModel)
{
bool paid = false;
var errors = ModelState
.Where(x => x.Value.Errors.Count > 0)
.Select(x => new { x.Key, x.Value.Errors })
.ToArray();
int uid = Convert.ToInt32(Session["userID"]);
decimal totalPrice = Convert.ToDecimal(Session["totalPriceFromOrder"]);
if (Session["userID"] == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
try
{
if (ModelState.IsValid)
{
PaymentModel payment = new PaymentModel();
BillingModel billing = new BillingModel();
OrderModel order = new OrderModel();
payment.customerID = uid;
payment.paymentDate = DateTime.Now;
payment.paymentType = "Online Payment";
payment.totalPrice = totalPrice;
billing.customerID = uid;
billing.cardType = payBillModel.cardType;
billing.expDate = payBillModel.expDate;
billing.cardHolderName = payBillModel.cardHolderName;
billing.cardNumber = payBillModel.cardNumber;
billing.cvv = payBillModel.cvv;
db.BillingModelSet.Add(billing);
db.PaymentModelSet.Add(payment);
db.SaveChanges();
paid = true;
if (paid)
{
return(RedirectToAction("Index", "Order"));
}
}
}
catch (Exception)
{
//Response.Write(ex.Message);
}
}
return(View(payBillModel));
}
//Partial view
//[HttpGet]
public ActionResult _TimeslipDetail(string BillingId, string page)
{
var model = new BillingModel();
if (BillingId == null)
{
ClaimTeamLoginModel client = (ClaimTeamLoginModel)Session[SessionHelper.claimTeamLogin];
string UserId = client.UserId;
model.IsNew_Billable = true;
model.Is_Billable = true;
model.Service_By = UserId;
model.Service_By_Name = client.FirstName + " " + client.LastName;
model.Service_Date = DateTime.Today;
if (!string.IsNullOrEmpty(page))
{
model.PageType = page;
}
return(PartialView(model));
}
model.IsNew_Billable = false;
BillingRepo billingRepo = new BillingRepo();
model = billingRepo.GetTeamGetBillableTimeRecord(BillingId).Result;
model.Billable = (decimal.Round(model.Billable, 2));
model.Rate = (decimal.Round(model.Rate, 2));
model.Rate_Per_Unit = (decimal.Round(model.Rate_Per_Unit, 2));
return(PartialView(model));
}
public BillingModel GetTransacationDetailsById(int PatientId)
{
BillingModel model = new BillingModel();
using (EHMSEntities ent = new EHMSEntities())
{
int PatienLogId = HospitalManagementSystem.Utility.getPatientLogID(PatientId);
var TranByDepo = (from CBM in ent.CentralizedBillingMasters
join CBD in ent.CentralizedBillingDetails
on CBM.BillNo equals CBD.BillNo
where CBM.PatientLogId == PatienLogId && CBM.Narration1 != "Deposit" && CBM.Narration2 == "ByDeposit"
select new
{
CBM.PatientLogId,
CBD.AccountHeadID,
CBD.AccountSubHeadID,
CBD.Amount,
CBM.BillDate
}).ToList();
foreach (var item in TranByDepo)
{
var ViewmodelByDepo = new DepositUsedViewModel()
{
DepoParticulars = HospitalManagementSystem.Utility.GetFeeTypeNameFromId(item.AccountHeadID),
DepoBillDate = item.BillDate,
DepoBillAmount = item.Amount
};
model.DepositUsedViewModelList.Add(ViewmodelByDepo);
}
}
return(model);
}
public async Task <ActionResult> GetTimeslipDetail(string BillingId)
{
var model = new BillingModel();
if (BillingId == null || BillingId == "null" || BillingId == "undefined" || BillingId == "")
{
ClaimTeamLoginModel client = (ClaimTeamLoginModel)Session[SessionHelper.claimTeamLogin];
string UserId = client.UserId;
model.IsNew_Billable = true;
model.Is_Billable = true;
model.Service_By = UserId;
model.Service_By_Name = client.FirstName + " " + client.LastName;
model.Service_Date = DateTime.Today;
return(Json(model, JsonRequestBehavior.AllowGet));
}
model.IsNew_Billable = false;
BillingRepo billingRepo = new BillingRepo();
model = await billingRepo.GetTeamGetBillableTimeRecord(BillingId);
model.Billable = (decimal.Round(model.Billable, 2));
model.Rate = (decimal.Round(model.Rate, 2));
model.Rate_Per_Unit = (decimal.Round(model.Rate_Per_Unit, 2));
return(Json(model, JsonRequestBehavior.AllowGet));
}
public void CreateEntityBilling(int EntityID, int BillingTypeID, int StreamTypeID, int Cost)
{
BillingModel billingModel = new BillingModel();
SqlParameter[] FObj = new SqlParameter[4];
FObj[0] = new SqlParameter("@EntityID", SqlDbType.Int);
FObj[0].Value = EntityID;
FObj[1] = new SqlParameter("@BillingTypeID", SqlDbType.Int);
FObj[1].Value = BillingTypeID;
FObj[2] = new SqlParameter("@StreamTypeID", SqlDbType.Int);
// Check for Fixed Cost Billing
if (StreamTypeID == 0)
{
FObj[2].Value = null;
}
else
{
FObj[2].Value = StreamTypeID;
}
FObj[3] = new SqlParameter("@Cost", SqlDbType.Int);
FObj[3].Value = Cost;
try
{
billingModel.CreateEntityBilling(FObj);
}
catch (Exception ex)
{
}
}
public async Task <ActionResult> TeamInsertTimeslip(BillingModel model)
{
BillingRepo billingRepo = new BillingRepo();
ClaimTeamLoginModel client = (ClaimTeamLoginModel)Session[SessionHelper.claimTeamLogin];
if (model.IsNew_Billable)
{
var result = await billingRepo.TeamInsertTimeslip(model, client.UserId);
if (result)
{
return(RedirectToAction("MyBillableTime"));
}
return(RedirectToAction("TimeslipDetail"));
}
else
{
var result = await billingRepo.TeamUpdateTimeslip(model, client.UserId);
if (result)
{
return(RedirectToAction("MyBillableTime"));
}
return(RedirectToAction("TimeslipDetail"));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public FileResult ExportBillingDetails()
{
string output = null;
MemoryStream memoryStream = new MemoryStream();
StreamWriter streamWriter = new StreamWriter(memoryStream);
streamWriter.WriteLine("Company,Consultant,Work Code, Hours");
BillingModel billingModel = Session["BillingModel"] as BillingModel;
if (billingModel != null)
{
billingModel.Summary.ForEach(x =>
{
output = string.Format("{0},\"{1}\",{2},{3}", x.Company, x.Employee, x.WorkCode, x.Hours);
streamWriter.WriteLine(output);
});
}
streamWriter.Flush();
memoryStream.Position = 0;
return(File(memoryStream, "text/csv", "Export.csv"));
}
public PartialViewResult _SearchBilling(FormCollection formCollection)
{
BillingModel billingModel = new BillingModel();
if (!string.IsNullOrEmpty(formCollection["PatientName"]))
{
billingModel.PatientName = formCollection["PatientName"].ToString();
}
if (!string.IsNullOrEmpty(formCollection["FormId"]))
{
billingModel.FormId = Convert.ToInt32(formCollection["FormId"]);
}
if (!string.IsNullOrEmpty(formCollection["ServiceDate"]))
{
billingModel.ServiceDate = formCollection["ServiceDate"];
}
if (!string.IsNullOrEmpty(formCollection["SubFrom"]))
{
billingModel.SubFrom = formCollection["SubFrom"];
}
if (!string.IsNullOrEmpty(formCollection["SubTo"]))
{
billingModel.SubTo = formCollection["SubTo"];
}
billingModel.BillingList = GetBillingSearch(billingModel);
Session["SearchCriteria"] = "PatientName=" + formCollection["PatientName"] + ",FormId=" + formCollection["FormId"] + ",ServiceDate=" + formCollection["ServiceDate"] + ",SubFrom=" + formCollection["SubFrom"] + ",SubTo=" + formCollection["SubTo"];
return(PartialView("_SearchBilling", billingModel));
}
public ActionResult GetBillDetails(int id)
{
BillingModel model = new BillingModel();
model.GetBillDetailByBillNoViewModelList = bpro.GetAllBillDetailsByBillNumber(id);
return(PartialView("_BillDetailsByBillNumber", model));
}
public ActionResult SearchByDepartmentID()
{
BillingModel model = new BillingModel();
model.TransactionDate = DateTime.Now;
model.EndTransactionDate = DateTime.Now;
return(View(model));
}
public ActionResult BillingDetails(BillingModel model)
{
model.CentralizeBillingViewModelList = bpro.GetListForIndex(model.TransactionDate, model.EndTransactionDate);
model.TransactionDate = model.TransactionDate;
model.EndTransactionDate = model.EndTransactionDate;
TempData["Value"] = "";
return(View(model));
}
public List <PatientBilling> GetBillingSearch(BillingModel billingModel)
{
var UserId = Convert.ToString(Session["USERID"]) == "" ? 0 : Convert.ToInt32(Session["USERID"]);
string officename = Common.CommonFunctions.GetUserOffice(UserId);
if (billingModel == null)
{
billingModel = new BillingModel();
}
billingModel.BillingList = (from p in mbprosEntities.PatientBillings
//join fu in mbprosEntities.Feature_User.Where(k => k.CanView == true) on p.CreatedBy equals fu.UserID
//join fm in mbprosEntities.FeatureMasters.Where(k => k.FeatureName == "BILLING_FORM") on fu.FeatureID equals fm.FeatureID
join u in mbprosEntities.Users on p.CreatedBy equals u.UserId into pu
from u in pu.DefaultIfEmpty()
where p.OfficeName == officename && p.Active == true //&& p.SrNo == 1
select p).OrderByDescending(o => o.PatientBillingID).ToList();
if (billingModel != null)
{
if (!string.IsNullOrEmpty(billingModel.PatientName))
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.PatientName.ToLower().Contains(billingModel.PatientName.ToLower().Trim())).ToList();
}
if (!string.IsNullOrEmpty(Convert.ToString(billingModel.FormId)))
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.PatientBillingID == Convert.ToInt32(billingModel.FormId)).ToList();
}
if (!string.IsNullOrEmpty(billingModel.ServiceDate))
{
DateTime pDate = DateTime.ParseExact(billingModel.ServiceDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
billingModel.BillingList = billingModel.BillingList.Where(x => x.ServiceDate == pDate).ToList();
}
if (!string.IsNullOrEmpty(billingModel.SubFrom))
{
DateTime pDate = DateTime.ParseExact(billingModel.SubFrom, "MM/dd/yyyy", CultureInfo.InvariantCulture);
billingModel.BillingList = billingModel.BillingList.Where(x => x.CreatedDate >= pDate).ToList();
}
if (!string.IsNullOrEmpty(billingModel.SubTo))
{
DateTime pDate = DateTime.ParseExact(billingModel.SubTo, "MM/dd/yyyy", CultureInfo.InvariantCulture);
billingModel.BillingList = billingModel.BillingList.Where(x => x.CreatedDate <= pDate).ToList();
}
if (billingModel.ArchiveOption == 1)
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.IsArchived == true).ToList();
}
else if (billingModel.ArchiveOption == 2)
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.IsArchived == false).ToList();
}
var patientBillingIds = billingModel.BillingList.Select(p => p.PatientBillingID).Distinct().ToArray();
billingModel.BillingList = (from p in mbprosEntities.PatientBillings.Where(p => patientBillingIds.Contains(p.PatientBillingID) && p.SrNo == 1) select p).OrderByDescending(o => o.PatientBillingID).ToList();
}
return(billingModel.BillingList);
}
public ActionResult TransactionDetails(int id)
{
BillingModel model = new BillingModel();
int OpdId = HospitalManagementSystem.Utility.GetOpdIdFromAccountHeadIdFromOpdMaster(id);
model = bpro.GetTransacationDetailsById(OpdId);
return(PartialView("_TransactionDetails", model));
//return View();
}
public ActionResult SearchByUsers()
{
BillingModel model = new BillingModel();
model.TransactionDate = DateTime.Today;
model.EndTransactionDate = DateTime.Today;
return(View(model));
}
public List <BillingModel> BillingModelList(int FeeTypeId, BillingModel model)
{
List <BillingModel> BillingModelList = new List <BillingModel>();
if (FeeTypeId == 19 || FeeTypeId == 20)
{
using (EHMSEntities ent = new EHMSEntities())
{
var result = from a in ent.OpdMasters
join b in ent.CentralizedBillings on a.OpdID equals b.PatientId
where b.AccountHeadId == FeeTypeId && b.AmountDate >= model.TransactionDate && b.AmountDate <= model.EndTransactionDate
select new BillingModel
{
OpdId = a.OpdID,
Narration1 = b.Narration1,
LedgerName = "",
DepartmentID = b.SubDepartmentId,
Amount = b.Amount,
Name = a.FirstName + " " + (a.MiddleName + " " ?? string.Empty) + a.LastName,
TransactionDate = b.AmountDate
};
foreach (var item in result)
{
BillingModelList.Add(item);
}
}
}
else
{
using (EHMSEntities ent = new EHMSEntities())
{
var result = from a in ent.OpdMasters
join b in ent.CentralizedBillings on a.OpdID equals b.PatientId
where b.AccountHeadId == FeeTypeId && b.AmountDate >= model.TransactionDate && b.AmountDate <= model.EndTransactionDate
select new BillingModel
{
OpdId = a.OpdID,
Narration1 = b.Narration1,
LedgerName = "",
DepartmentID = b.SubDepartmentId,
Amount = b.Amount,
Name = a.FirstName + " " + (a.MiddleName + " " ?? string.Empty) + a.LastName,
TransactionDate = b.AmountDate
};
foreach (var item in result)
{
BillingModelList.Add(item);
}
}
}
return(BillingModelList);
}
public OrderDetail(BillingModel _obj)
{
ID = _obj.OrderDetailsId;
OrderID = _obj.OrderId;
ProductID = _obj.ProductNameId;
Quantity = _obj.ProductQuantity;
UnitPrice = _obj.ProductPrice;
TotalPrice = _obj.ProductAmount;
Discount = _obj.ProductDiscount;
}
public BillingModel GetAllDischargeBillSummary(int PatientLogId)
{
BillingModel model = new BillingModel();
using (EHMSEntities ent = new EHMSEntities())
{
//model.DischargeBillingDepositeList = ent.Database.SqlQuery<CentralizeBillingViewModel>("DischargeBillSummary '" + PatientLogId + "', '""++'").ToList();
}
return(model);
}
public ActionResult MTSInternalbilling(string d)
{
string fromDate = Request.Form["fromDate"];
string toDate = Request.Form["toDate"];
string location = Request.Form["locations"];
if (string.IsNullOrEmpty(location))
{
location = null;
}
BillingModel billingModel = null;
Session["BillingModel"] = null;
if (string.IsNullOrEmpty(fromDate) && string.IsNullOrEmpty(toDate))
{
fromDate = DateTime.Now.ToShortDateString();
if (User.IsInRole(Constants.ROLE_ADMIN))
{
billingModel = this.taskService.GetMTSBilling(fromDate, toDate, null, location);
}
else
{
billingModel = this.taskService.GetMTSBilling(fromDate, toDate, User.Identity.Name, location);
}
ViewBag.Message = "Result of " + DateTime.Now.ToShortDateString();
}
else
{
if (User.IsInRole(Constants.ROLE_ADMIN))
{
billingModel = this.taskService.GetMTSBilling(fromDate, toDate, null, location);
}
else
{
billingModel = this.taskService.GetMTSBilling(fromDate, toDate, User.Identity.Name, location);
}
if (!string.IsNullOrEmpty(toDate))
{
ViewBag.Message = "Result from " + fromDate + " to " + toDate;
}
else
{
ViewBag.Message = "Result of " + fromDate;
}
}
Session["BillingModel"] = billingModel;
ViewBag.locations = this.GetLocations();
return(View(billingModel));
}
public virtual Result <BillingModel> GetBillingData()
{
var result = new Result <BillingModel>();
var model = new BillingModel();
if (!Context.PageMode.IsExperienceEditor)
{
try
{
result.SetResult(model);
var currentCart = this.CartManager.GetCurrentCart(
this.StorefrontContext.ShopName,
this.VisitorContext.ContactId);
if (!currentCart.ServiceProviderResult.Success)
{
result.SetErrors(currentCart.ServiceProviderResult);
return(result);
}
var cartResult = currentCart.Result;
if ((cartResult.Lines != null) && cartResult.Lines.Any())
{
////result.Initialize(result, visitorContext);
this.AddPaymentOptions(result, cartResult);
if (result.Success)
{
this.AddPaymentMethods(result, cartResult);
if (result.Success)
{
this.AddPaymentClientToken(result);
if (result.Success)
{
this.AddUserInfo(result.Data, result);
}
////if (result.Success)
////{
//// this.AddAvailableCountries((BaseCheckoutDataJsonResult)model);
//// if (result.Success)
//// this.CheckForDigitalProductInCart(model, cartResult);
////}
}
}
}
}
catch (Exception ex)
{
Log.Error(ex.Message, ex, this);
result.SetErrors(nameof(this.GetBillingData), ex);
return(result);
}
}
return(result);
}
public ActionResult SearchByRoomType(BillingModel model)
{
model.BillingModelList = bpro.BillingListForRoom(model.RoomType);
if (model.BillingModelList == null)
{
TempData["a"] = 1;
return(RedirectToAction("SearchByRoomType"));
}
TempData["Value"] = model.BillingModelList.Sum(x => x.Amount);
return(View(model));
}
public List <PatientBilling> GetBillingSearchForAdmin(BillingModel billingModel)
{
if (billingModel == null)
{
billingModel = new BillingModel();
}
billingModel.BillingList = (from p in mbprosEntities.PatientBillings
where p.Active == true //&& p.SrNo == 1
select p).OrderByDescending(o => o.PatientBillingID).ToList();
if (billingModel != null)
{
if (!string.IsNullOrEmpty(billingModel.OfficeName))
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.OfficeName.ToLower().Contains(billingModel.OfficeName.ToLower().Trim())).ToList();
}
if (!string.IsNullOrEmpty(billingModel.PatientName))
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.PatientName.ToLower().Contains(billingModel.PatientName.ToLower().Trim())).ToList();
}
if (!string.IsNullOrEmpty(Convert.ToString(billingModel.FormId)))
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.PatientBillingID == Convert.ToInt32(billingModel.FormId)).ToList();
}
if (!string.IsNullOrEmpty(billingModel.SubFrom))
{
DateTime pDate = DateTime.ParseExact(billingModel.SubFrom, "MM/dd/yyyy", CultureInfo.InvariantCulture);
billingModel.BillingList = billingModel.BillingList.Where(x => x.CreatedDate >= pDate).ToList();
}
if (!string.IsNullOrEmpty(billingModel.SubTo))
{
DateTime pDate = DateTime.ParseExact(billingModel.SubTo, "MM/dd/yyyy", CultureInfo.InvariantCulture);
billingModel.BillingList = billingModel.BillingList.Where(x => x.CreatedDate <= pDate).ToList();
}
if (!string.IsNullOrEmpty(billingModel.ServiceDate))
{
DateTime pDate = DateTime.ParseExact(billingModel.ServiceDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
billingModel.BillingList = billingModel.BillingList.Where(x => x.ServiceDate == pDate).ToList();
}
if (billingModel.ArchiveOption == 1)
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.IsArchived == true).ToList();
}
else if (billingModel.ArchiveOption == 2)
{
billingModel.BillingList = billingModel.BillingList.Where(x => x.IsArchived == false).ToList();
}
var patientBillingIds = billingModel.BillingList.Select(p => p.PatientBillingID).Distinct().ToArray();
billingModel.BillingList = (from p in mbprosEntities.PatientBillings.Where(p => patientBillingIds.Contains(p.PatientBillingID) && p.SrNo == 1) select p).OrderByDescending(o => o.PatientBillingID).ToList();
}
return(billingModel.BillingList);
}
public Order(BillingModel _obj, DateTime _createdDate, int _userId)
{
ID = _obj.OrderId;
TransactionID = _obj.TransactionId;
CustomerID = _obj.CustomerId;
ActualPrice = _obj.SubTotal;
Discount = _obj.Discount;
Adjustment = _obj.Adjustment;
TotalPrice = _obj.GrandTotal;
CreatedOn = _createdDate;
CreatedBy = _userId;
}
public ActionResult BillingSearch(string editMessage, bool IsBack = false)
{
BillingModel billingModel = new BillingModel();
if (TempData["EditMessage"] != null)
{
ViewBag.EditMessage = editMessage;
}
if (IsBack)
{
//Get & Set search criteria model
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchCriteria"])))
{
string[] SearchCriteria = Session["SearchCriteria"].ToString().Split(",".ToArray());
for (int i = 0; i < SearchCriteria.Count(); i++)
{
string[] keyValues = SearchCriteria[i].Split("=".ToArray());
switch (keyValues[0])
{
case "PatientName":
billingModel.PatientName = keyValues[1];
break;
case "FormId":
if (!string.IsNullOrEmpty(Convert.ToString(keyValues[1])))
{
billingModel.FormId = Convert.ToInt32(keyValues[1]);
}
break;
case "ServiceDate":
billingModel.ServiceDate = keyValues[1];
break;
case "SubFrom":
billingModel.SubFrom = keyValues[1];
break;
case "SubTo":
billingModel.SubTo = keyValues[1];
break;
}
}
}
billingModel.BillingList = GetBillingSearch(billingModel);
}
else
{
Session["SearchCriteria"] = "";
billingModel.BillingList = GetBillingSearch(null);
}
return(View(billingModel));
}
// GET: Admin/Invoice
public ActionResult Index(int?id)
{
if (id == null || id == 0)
{
return(PageRedirection());
}
_BillingModel.OrderId = (Int32)id;
_BillingModel = _invoiveBusiness.GetCustomerOrderDetailsByOrderId(_BillingModel);
if (_BillingModel.BillingList == null || !_BillingModel.BillingList.Any())
{
return(PageRedirection());
}
return(View(_BillingModel));
}
public BillingModel GetPatientsDetailsByIdAndName(int TypeOfsearch, string SearchV)
{
BillingModel model = new BillingModel();
using (EHMSEntities ent = new EHMSEntities())
{
switch (TypeOfsearch)
{
case 1:
int OpdId = Convert.ToInt32(SearchV);
var result = ent.OpdMasters.Where(x => x.OpdID == OpdId);
foreach (var item in result)
{
var Viewmodel = new CentralizeBillingViewModel()
{
LedgerName = Utility.GetPatientNameWithIdFromOpd(item.OpdID), //PatientName
PatientId = item.OpdID,
Age = (int)item.AgeYear,
Narration1 = item.Address //address
};
model.CentralizeBillingViewModelList.Add(Viewmodel);
}
break;
case 2:
var resultName = ent.OpdMasters.Where(x => x.FirstName.Contains(SearchV));
foreach (var item in resultName)
{
var Viewmodel = new CentralizeBillingViewModel()
{
LedgerName = Utility.GetPatientNameWithIdFromOpd(item.OpdID),
PatientId = item.OpdID,
Age = (int)item.AgeYear,
Narration1 = item.Address
};
model.CentralizeBillingViewModelList.Add(Viewmodel);
}
break;
default:
break;
}
return(model);
}
}
public BillingModel GetModelIFBacktoBillingSrch4Admin(BillingModel billingModel)
{
//Get & Set search criteria model
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchCriteria"])))
{
string[] SearchCriteria = Session["SearchCriteria"].ToString().Split(",".ToArray());
for (int i = 0; i < SearchCriteria.Count(); i++)
{
string[] keyValues = SearchCriteria[i].Split("=".ToArray());
switch (keyValues[0])
{
case "OfficeName":
billingModel.OfficeName = keyValues[1];
break;
case "PatientName":
billingModel.PatientName = keyValues[1];
break;
case "FormId":
if (!string.IsNullOrEmpty(Convert.ToString(keyValues[1])))
{
billingModel.FormId = Convert.ToInt32(keyValues[1]);
}
break;
case "SubFrom":
billingModel.SubFrom = keyValues[1];
break;
case "SubTo":
billingModel.SubTo = keyValues[1];
break;
case "ServiceDate":
billingModel.ServiceDate = keyValues[1];
break;
case "ArchiveOption":
if (!string.IsNullOrEmpty(Convert.ToString(keyValues[1])))
{
billingModel.ArchiveOption = Convert.ToInt32(keyValues[1]);
}
break;
}
}
}
return(billingModel);
}
public ActionResult Payment(BillingModel values, PaymentModel values1)
{
var errors = ModelState
.Where(x => x.Value.Errors.Count > 0)
.Select(x => new { x.Key, x.Value.Errors })
.ToArray();
try
{
if (ModelState.IsValid)
{
var bill = new BillingModel
{
customerID = values.customerID,
cardNumber = values.cardNumber,
cardType = values.cardType,
expDate = DateTime.Today,
cardHolderName = values.cardHolderName
};
var pay = new PaymentModel
{
//orderID = values1.orderID,
//paymentID = values1.paymentID,
//customerID = values1.customerID,
//paymentType = values1.paymentType,
paymentDate = DateTime.Now
};
var order = new OrderModel {
orderDate = DateTime.Now
};
Context.BillingModelSet.Add(values);
Context.PaymentModelSet.Add(values1);
Context.OrderModelSet.Add(order);
Context.SaveChanges();
return(RedirectToAction("Index"));
//return RedirectToAction("CheckoutComplete", new { id = order.orderID });
}
}
catch (Exception e)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, e.Message));
}
Context.SaveChanges();
return(View(values));
}
