public JsonResult GetServicesChargesOPD(int ServiceID)
{
ServicesPackage location = new ServicesPackage();
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
List <ServicePackage_OPDCharges> serch = new List <ServicePackage_OPDCharges>();
DataSet ds = Bl_obj.GetServicesChargesOPD(ServiceID);
ServicesPackage obj = new ServicesPackage();
// obj.ServiceChargesID = ds.Tables[0].Rows[0]["Advise"].ToString();
// serch.Add(obj);
foreach (DataRow dr in ds.Tables[0].Rows)
{
serch.Add(new ServicePackage_OPDCharges
{
ServiceID = Convert.ToInt32(dr["ServiceID"].ToString()),
Quantity = Convert.ToInt32(dr["Quantity"].ToString()),
ServiceOrTestID = Convert.ToInt32(dr["ServiceOrTestID"].ToString()),
ServiceNTestName = dr["ServiceOrTestName"].ToString(),
GeneralCharges = dr["GeneralCharges"].ToString(),
EmergencyCharges = dr["EmergencyCharges"].ToString(),
ServiceType = dr["ServiceType"].ToString(),
});
}
return(new JsonResult {
Data = serch, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetServiceDetailsWardWise1(int ServiceID)
{
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
dsServicesNTests = Bl_obj.GetServiceDetailsPackage(ServiceID);
int count = 1;
DataSet dsWord = BindServiceCharges();
foreach (DataRow ds in dsServicesNTests.Tables[1].Rows)
{
}
List <ServicesPackage> search = new List <ServicesPackage>();
foreach (DataRow dr in dsServicesNTests.Tables[1].Rows)
{
search.Add(new ServicesPackage
{
SPWchargeID = dr["ServiceName"].ToString(),
ServicePackageID = dr["ServicePackageID"].ToString(),
ServiceType = dr["ServiceType"].ToString(),
ServiceOrTestID = Convert.ToInt32(dr["ServiceOrTestID"]),
WardID = Convert.ToInt32(dr["WardID"]),
WardName = dr["WardName"].ToString(),
Quantity = Convert.ToInt32(dr["Quantity"]),
GeneralCharges = Convert.ToInt32(dr["GeneralCharges"]),
});
}
return(new JsonResult {
Data = search, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult ShowAllServiceDetailsPackage()
{
ServicesPackage location = new ServicesPackage();
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
List <ServicesPackage> serch = new List <ServicesPackage>();
DataSet ds = Bl_obj.GetAllServiceDetailsPackage();
foreach (DataRow dr in ds.Tables[0].Rows)
{
serch.Add(new ServicesPackage
{
ServiceID = Convert.ToInt32(dr["ServiceID"].ToString()),
ServiceGroupID = dr["ServiceGroupID"].ToString(),
ServiceName = dr["ServiceName"].ToString(),
GeneralCharges = Convert.ToDecimal(dr["General Charges"].ToString()),
EmergencyCharges = Convert.ToDecimal(dr["Emergency Charges"].ToString()),
ServiceType = dr["ServiceType"].ToString(),
ServiceGroupName = dr["ServiceGroupName"].ToString(),
UnitName = dr["UnitName"].ToString(),
chkrechange = Convert.ToBoolean(dr["Rechange"].ToString())
});
}
return(new JsonResult {
Data = serch, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public DataSet BindServicePackagesCharges(int ServiceID)
{
// dsServicesCharges.Reset();
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
AddServicesPackagesMod.dsServicePackagesCharges = Bl_obj.GetAllWardNameWithPackageDetails(ServiceID);
return(AddServicesPackagesMod.dsServicePackagesCharges);
}
public JsonResult ServicePkgesDetailsCharges(int ServiceID, string ServiceType)
{
HospitalLocation();
string TableColumnsWordIDName = "";
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
List <Services> search = new List <Services>();
List <ServicesPackage> objmodel = new List <ServicesPackage>();
dsServicesNTests = Bl_obj.GetServicesPackageforServiceNTest();
AddServicesPackagesMod.dsServicePackagesCharges = BindServicePackagesCharges(ServiceID);
decimal GeneralCharges = 0;
foreach (DataRow dr in AddServicesPackagesMod.dsServicePackagesCharges.Tables[1].Rows)
{
objmodel.Add(new ServicesPackage
{
ServiceID = Convert.ToInt32(dr["ServiceID"].ToString()),
ServiceOrTestID = Convert.ToInt32(dr["ServiceOrTestID"].ToString()),
ServiceOrTestName = dr["ServiceOrTestName"].ToString(),
Quantity = Convert.ToInt32(dr["Quantity"].ToString()),
ServiceType = dr["ServiceType"].ToString(),
ServiceDetailsPackagelID = Convert.ToInt32(dr["ServiceDetailsPackagelID"].ToString())
});
}
var modeladd = new List <dynamic>(AddServicesPackagesMod.dsServicePackagesCharges.Tables[0].Rows.Count);
foreach (DataRow row in AddServicesPackagesMod.dsServicePackagesCharges.Tables[0].Rows)
{
var obj = (IDictionary <string, object>) new ExpandoObject();
foreach (DataColumn col in AddServicesPackagesMod.dsServicePackagesCharges.Tables[0].Columns)
{
obj.Add(col.ColumnName, row[col]);
}
modeladd.Add(obj);
}
return(Json(new { modeladd = modeladd, objmodel = objmodel }, JsonRequestBehavior.AllowGet));
}
public JsonResult TableFromCharges(int ServiceOrTestID, string ServiceType)
{
HospitalLocation();
string TableColumnsWordIDName = "";
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
List <Services> search = new List <Services>();
dsServicesNTests = Bl_obj.GetServicesPackageforServiceNTest();
AddServiceMod.dsServicesCharges = BindServiceCharges();
decimal GeneralCharges = 0;
dsServicesNTests = Bl_obj.GetServiceDetailsPackage(ServiceOrTestID);
int count = 1;
DataSet dsWord = BindServiceCharges();
var modeladd = new List <dynamic>(AddServiceMod.dsServicesCharges.Tables[0].Rows.Count);
var rowcount = 0;
foreach (DataRow row in AddServiceMod.dsServicesCharges.Tables[0].Rows)
{
var obj = (IDictionary <string, object>) new ExpandoObject();
rowcount = 0;
foreach (DataColumn col in AddServiceMod.dsServicesCharges.Tables[0].Columns)
{
string col1 = dsServicesNTests.Tables[1].Rows[rowcount]["GeneralCharges"].ToString();
obj.Add(col.ColumnName, dsServicesNTests.Tables[1].Rows[rowcount]["GeneralCharges"]);
rowcount++;
}
modeladd.Add(obj);
}
return(new JsonResult {
Data = modeladd, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetServicesPackageforServiceNTest()
{
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
dsServicesNTests = Bl_obj.GetServicesPackageforServiceNTest();
List <Services> search = new List <Services>();
foreach (DataRow dr in dsServicesNTests.Tables[0].Rows)
{
search.Add(new Services
{
ServiceID = Convert.ToInt32(dr["ServiceID"]),
ServiceName = dr["ServiceName"].ToString(),
});
}
return(new JsonResult {
Data = search, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public DataSet BindServiceCharges()
{
// dsServicesCharges.Reset();
KeystoneProject.Buisness_Logic.Master.BL_ServicesPackage Bl_obj = new Buisness_Logic.Master.BL_ServicesPackage();
AddServiceMod.dsServicesCharges = Bl_obj.GetAllWardName1();
//AddServiceMod.dsServicesCharges.Tables[0].Columns.Add("ServiceChargesID");
//AddServiceMod.dsServicesCharges.Tables[0].Columns.Add("ServiceID");
//AddServiceMod.dsServicesCharges.Tables[0].Columns.Add("CreationID");
//AddServiceMod.dsServicesCharges.Tables[0].Columns.Add("Mode");
//foreach (DataRow dr in AddServiceMod.dsServicesCharges.Tables[0].Rows)
//{
// dr["GeneralCharges"] = 0;
// dr["EmergencyCharges"] = 0;
//}
return(AddServiceMod.dsServicesCharges);
}
