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