public ExpensesDetails ViewAllExpenses(int hId)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[2];
sqlparam[0] = new SqlParameter("@Flag", "1");
//sqlparam[1] = new SqlParameter("@MedicineId", 0);
sqlparam[1] = new SqlParameter("@HospitalId", hId);
DataSet ds = CommonFunction.GetDataSet("USP_Get_ExpancesDetails", sqlparam, "");
ExpensesDetails ED = new ExpensesDetails();
List <ExpensesDetails> lst = new List <ExpensesDetails>();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
ExpensesDetails Model = new ExpensesDetails();
CommonFunction.ReflectSingleData(Model, dr);
lst.Add(Model);
}
}
//Income
List <IncomeDetails> Inclst = new List <IncomeDetails>();
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
DataTable dt = ds.Tables[1];
foreach (DataRow dr in dt.Rows)
{
IncomeDetails Model = new IncomeDetails();
CommonFunction.ReflectSingleData(Model, dr);
Inclst.Add(Model);
}
}
//Invoice
List <InvoiceDetails> Invclst = new List <InvoiceDetails>();
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
DataTable dt = ds.Tables[2];
foreach (DataRow dr in dt.Rows)
{
InvoiceDetails Model = new InvoiceDetails();
CommonFunction.ReflectSingleData(Model, dr);
Invclst.Add(Model);
}
}
ED.Invlst = Invclst.OrderByDescending(x => x.Date).ToList();
ED.Inclst = Inclst.OrderByDescending(x => x.Date).ToList();
ED.lst = lst.OrderByDescending(x => x.ExId).ToList();
return(ED);
}
catch (Exception Ex)
{
throw Ex;
}
}
public int ManageExpensesDetails(ExpensesDetails ED)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[9];
sqlparam[0] = new SqlParameter("@ExId", ED.ExId);
if (ED.ExDate == null)
{
sqlparam[1] = new SqlParameter("@ExDate", DBNull.Value);
}
else
{
sqlparam[1] = new SqlParameter("@ExDate", DateTime.ParseExact(ED.ExDate, "dd/MM/yyyy", CultureInfo.InvariantCulture));// ED.ExDate);
}
sqlparam[2] = new SqlParameter("@ExCatagory", ED.ExCatagory);
sqlparam[3] = new SqlParameter("@ExAmount", ED.ExAmount);
sqlparam[4] = new SqlParameter("@ExDetails", ED.ExDetails);
sqlparam[5] = new SqlParameter("@CreatedBy", ED.CreatedBy);
sqlparam[6] = new SqlParameter("@ModifiedBy", ED.ModifiedBy);
sqlparam[7] = new SqlParameter("@IsAcive", 1);
sqlparam[8] = new SqlParameter("@HospitalId", ED.HospitalId);
return(CommonFunction.Save("USP_ManageExpancesDetails", sqlparam, ""));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DeleteExpenses(int Id)
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
ExpensesDetails ED = new ExpensesDetails();
// ED = BL.ViewAllMedicine();
int Flag1 = BL.DeleteExpences(Id);
ED = BL.ViewAllExpenses(admObj.HospitalId);
return(View("AccountDetails", ED));
}
public ActionResult ViewAllExpenses()
{
try
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
ExpensesDetails ED = new ExpensesDetails();
ED = BL.ViewAllExpenses(admObj.HospitalId);
return(View("AccountDetails", ED));
}
catch (Exception)
{
throw;
}
}
public ActionResult ManageExpensesDetails(ExpensesDetails ED)
{
try
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
ED.HospitalId = admObj.HospitalId;
int Flag = BL.ManageExpensesDetails(ED);
ED = BL.ViewAllExpenses(admObj.HospitalId);
ModelState.Clear();
return(View("AccountDetails", ED));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult GetExpensesById(int Id, int hId)
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
ExpensesDetails ED = new ExpensesDetails();
ED = BL.ViewAllExpenses(hId);
if (true)
{
var v = ED.lst.FirstOrDefault(x => x.ExId == Id);
ED.ExId = v.ExId;
ED.ExDate = v.ExDate.Substring(0, v.ExDate.ToString().IndexOf(" ") + 1).TrimEnd();
ED.ExDetails = v.ExDetails;
ED.ExAmount = v.ExAmount;
ED.ExCatagory = v.ExCatagory;
ED.CreatedBy = v.CreatedBy;
}
return(View("AccountDetails", ED));
}
public int ManageExpensesDetails(ExpensesDetails MD)
{
return(DP.ManageExpensesDetails(MD));
}
