//public FileResult DownLoadFile()
//{
// //SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
// var workbook = new ExcelFile();
// var worksheet = workbook.Worksheets.Add("DataTable to Sheet");
// Services AddServiceMod = new Services();
// KeystoneProject.Buisness_Logic.Master.Bl_Services Bl_obj = new Buisness_Logic.Master.Bl_Services();
// AddServiceMod.dsServicesCharges = Bl_obj.GetWardDetailsPivot();
// // worksheet.AddServiceMo
// //string fileName = Server.MapPath("~/") + "Service_Excel/" + Bl_obj.ReffrenceExcel() + ".xlsx";
// //ExcelLibrary.DataSetHelper.CreateWorkbook(fileName, AddServiceMod.dsServicesCharges);
// worksheet.InsertDataTable(AddServiceMod.dsServicesCharges.Tables[0],
// new InsertDataTableOptions()
// {
// ColumnHeaders = true,
// //StartRow = 2
// });
// string fileName = Server.MapPath("~/") + "Service_Excel/" + Bl_obj.ReffrenceExcel() + ".xlsx";
// // workbook.Save("DataTable to Sheet.xlsx");
// workbook.Save(fileName);
// // workbook.Close(true, Type.Missing, Type.Missing);
// return File("","","");
//}
//public FileResult DownLoadFile()
//{
// #region Exal
// byte[] bytes;
// string fileName = "", contentType = "", PaperPath = "";
// DataSet dswordchargeinrow = new DataSet();
// Buisness_Logic.Master.BL_ServiceTPAWise objServiceTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
// Services AddServiceMod = new Services();
// KeystoneProject.Buisness_Logic.Master.Bl_Services Bl_obj = new Buisness_Logic.Master.Bl_Services();
// // AddServiceMod.StoreAllServices = objServiceTPAWise.SelectAllServiceTPAWise();
// AddServiceMod.dsServicesCharges = Bl_obj.GetWardDetailsPivot();
// Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
// Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
// Microsoft.Office.Interop.Excel._Worksheet worksheet = null;
// Excel.Range chartRange;
// worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets["Sheet1"];
// worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet;
// app.get_Range("A2", "S2").Locked = true;
// string WardNAme;
// //worksheet.Name = "Exported from Keystone";
// int count = 0;
// for (int i = 1; i < AddServiceMod.dsServicesCharges.Tables[0].Columns.Count + 1; i++)
// {
// string column_name = AddServiceMod.dsServicesCharges.Tables[0].Columns[i - 1].ColumnName;
// worksheet.Cells[1, i] = AddServiceMod.dsServicesCharges.Tables[0].Columns[i - 1].ColumnName;
// count = i;
// int m = 0;
// }
// for (int i = 0; i < AddServiceMod.dsServicesCharges.Tables[0].Rows.Count; i++)
// {
// for (int j = 0; j < AddServiceMod.dsServicesCharges.Tables[0].Columns.Count; j++)
// {
// // if (j < 2)
// // {
// string name = AddServiceMod.dsServicesCharges.Tables[0].Rows[i][j].ToString();
// worksheet.Cells[i + 2, j + 1] = AddServiceMod.dsServicesCharges.Tables[0].Rows[i][j].ToString();
// }
// }
// // if (AddServiceMod.StoreAllServices.Tables[0].Rows[i]["ServiceID"].ToString() != "")
// // {
// // dswordchargeinrow = objServiceTPAWise.GetServicesTPAWiseDetail(Convert.ToInt32( AddServiceMod.StoreAllServices.Tables[0].Rows[i]["ServiceID"].ToString()));
// // if (dswordchargeinrow.Tables[0].Rows.Count > 0)
// // {
// // foreach (DataRow drcharge in AddServiceMod.dsServicesCharges.Tables[0].Rows)
// // {
// // int charge = 0;
// // foreach (DataRow dr in dswordchargeinrow.Tables[0].Rows)
// // {
// // string WardName = drcharge["WardName"].ToString();
// // string WardName1 = dr["WardName"].ToString();
// // if (drcharge["WardName"].ToString() == dr["WardName"].ToString())
// // {
// // worksheet.Cells[i + 2, charge + 7] = dr["GeneralCharges"];
// // }
// // charge++;
// // }
// // }
// // }
// // }
// // }
// //}
// #endregion
// Random obj = new Random();
// int a = obj.Next(1, 300);
// string DateCode = "ServiceTPA_Excel_Data" + Bl_obj.ReffrenceExcel();
// fileName = Server.MapPath("~/") + "Service_Excel/" + DateCode;
// workbook.SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// workbook.Close(true, Type.Missing, Type.Missing);
// string Path = fileName + ".xlsx";
// string filename = System.IO.Path.GetFileName(DateCode + ".xlsx");
// // string fullpath = System.IO.Path.Combine(Path, fileName);
// contentType = MimeMapping.GetMimeMapping(Path);
// //fileName = "Service_Excel_Data" + Bl_obj.ReffrenceCode()+".xlsx";
// return File(Path, contentType, filename);
// // return File(FileById.FileContent, "/MRDFiles/pdf", FileById.FileName);
//}
// public JsonResult
public JsonResult imageuplod(Doctor model)
{
string path = "";
//PatientMRD_Model Model
// PatientMRD_Model obj = new PatientMRD_Model();
var file = model.ImageFile;
if (file != null)
{
KeystoneProject.Buisness_Logic.Master.BL_ServiceTPAWise Bl_obj = new Buisness_Logic.Master.BL_ServiceTPAWise();
//var path = "";
var filename = Path.GetFileName(file.FileName);
var extention = Path.GetExtension(file.FileName);
var filenamethoutextenction = Path.GetFileNameWithoutExtension(file.FileName);
file.SaveAs(Server.MapPath("~/MRDFiles/" + file.FileName));
// Session["Paper"] = "/MRDFiles/" + file.FileName;
path = Server.MapPath("~/") + "MRDFiles/" + filename;
// path = Server.MapPath("~/") + "Service_Excel/" + file.FileName;
DataSet ds = new DataSet();
// file.SaveAs(path);
ds = Bl_obj.btnImport_Click(path);
//
// Session["Paper"] = path;
// ViewData["ImagePath"] = path;
}
return(new JsonResult {
Data = path, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
//public JsonResult DeleteServicesTPAWise(int ServiceID, string ServiceType)
//{
// Buisness_Logic.Master.BL_ServiceTPAWise ServiceEditTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
// Services AddServiceMod = new Services();
// string _Del = null;
// try
// {
// int Dependency = ServiceEditTPAWise.DeleteServicesTPAWise(Convert.ToInt32(ServiceID), ServiceType);
// if (Dependency == 2)
// {
// _Del = "ServiceTPAWise Deleted Successfully";
// }
// else
// {
// _Del = "Error";
// }
// }
// catch (Exception)
// {
// throw;
// }
// return new JsonResult { Data = _Del, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
//}
public JsonResult DeleteServicesTPAWise(int ServiceID, string ServiceType)
{
string _Del = null;
try
{
KeystoneProject.Buisness_Logic.Master.BL_ServiceTPAWise objdb = new Buisness_Logic.Master.BL_ServiceTPAWise();
ServicesTPAWise objSG = new Models.Master.ServicesTPAWise();
int DependaincyName = objdb.DeleteServicesTPAWise(Convert.ToInt32(ServiceID), ServiceType);
if (DependaincyName == 1)
{
_Del = "ServiceTPAWise Deleted Successfully";
}
else
{
_Del = "Can not Delete";
}
}
catch (Exception ex)
{
throw ex;
}
return(new JsonResult {
Data = _Del, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult SelectAllServiceTPAWise()
{
Buisness_Logic.Master.BL_ServiceTPAWise objServiceTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
DataSet ds = new DataSet();
ds = objServiceTPAWise.SelectAllServiceTPAWise();
List <ServicesTPAWise> searchList = new List <ServicesTPAWise>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchList.Add(new ServicesTPAWise
{
OrganizationName = dr["OrganizationName"].ToString(),
ServiceName = dr["ServiceName"].ToString(),
UnitName = dr["UnitName"].ToString(),
ServiceType = dr["ServiceType"].ToString(),
ServicesTPAWiseID = Convert.ToInt32(dr["ServicesTPAWiseID"]),
ServiceID = dr["ServiceID"].ToString(),
OrganizationID = dr["OrganizationID"].ToString(),
});
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public ActionResult ServicesTPAWise(ServicesTPAWise location, ArrayWordDetailTpa TpaDetail)
{
Buisness_Logic.Master.BL_ServiceTPAWise ServiceEditTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
string Save = ServiceEditTPAWise.Save(location, TpaDetail);
if (location.ServicesTPAWiseID > 0)
{
if (Save == "Save")
{
TempData["Msg"] = "ServiceTPAWise Updated Successfully";
return(RedirectToAction("ServicesTPAWise", "ServicesTPAWise"));
}
}
else
{
if (Save == "Save")
{
TempData["msg"] = "Privilege Card Saved Successfully";
return(RedirectToAction("ServicesTPAWise", "ServicesTPAWise"));
}
}
//if (Save == "Save") // passing Value to DBClass from model
//{
// TempData["Msg"] = "ServiceTPAWise Save Sussefully";
//}
return(RedirectToAction("ServicesTPAWise", "ServicesTPAWise"));
}
//
// GET: /ServicesTPAWise/
//DataSet ds = new DataSet();
public ActionResult ServicesTPAWise()
{
Buisness_Logic.Master.BL_ServiceTPAWise objServiceTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
dsSer.ds = objServiceTPAWise.GetWardDetailsPivot();
return(View(dsSer));
}
public JsonResult EditServiceTPAWise(int ServicesTPAWiseID)
{
Buisness_Logic.Master.BL_ServiceTPAWise ServiceEditTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
List <ServicesTPAWise> searchList = new List <ServicesTPAWise>();
DataSet ds = ServiceEditTPAWise.GetServicesTPAWise(ServicesTPAWiseID);
ServicesTPAWise AddServiceTPAWise = new ServicesTPAWise();
AddServiceTPAWise.OrganizationName = ds.Tables[0].Rows[0]["OrganizationName"].ToString();
AddServiceTPAWise.OrganizationID = ds.Tables[0].Rows[0]["OrganizationID"].ToString();
AddServiceTPAWise.ServiceName = ds.Tables[0].Rows[0]["ServiceName"].ToString();
AddServiceTPAWise.ServiceID = ds.Tables[0].Rows[0]["ServiceID"].ToString();
AddServiceTPAWise.UnitName = ds.Tables[0].Rows[0]["UnitName"].ToString();
AddServiceTPAWise.UnitID = ds.Tables[0].Rows[0]["UnitID"].ToString();
AddServiceTPAWise.GeneralCharges = Convert.ToDecimal(ds.Tables[0].Rows[0]["GeneralCharges"].ToString());
AddServiceTPAWise.EmergencyCharges = Convert.ToDecimal(ds.Tables[0].Rows[0]["EmergencyCharges"].ToString());
AddServiceTPAWise.ServiceType = ds.Tables[0].Rows[0]["ServiceType"].ToString();
AddServiceTPAWise.RecommendedByDoctor = ds.Tables[0].Rows[0]["RecommendedByDoctor"].ToString();
AddServiceTPAWise.HideInBilling = ds.Tables[0].Rows[0]["HideInBilling"].ToString();
AddServiceTPAWise.ServiceID = ds.Tables[0].Rows[0]["ServiceID"].ToString();
AddServiceTPAWise.UnitID = ds.Tables[0].Rows[0]["UnitID"].ToString();
AddServiceTPAWise.OrganizationID = ds.Tables[0].Rows[0]["OrganizationID"].ToString();
// DataSet ds1 = ServiceEditTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
AddServiceTPAWise.ServicesTPAWiseID = ServicesTPAWiseID;
// AddServiceTPAWise.dsServiceTPAWiseCharges = ServiceEditTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
ds = ServiceEditTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
searchList.Add(AddServiceTPAWise);
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchList.Add(new ServicesTPAWise
{
WardName = dr["WardName"].ToString(),
GeneralCharges = Convert.ToDecimal(dr["GeneralCharges"]),
EmergencyCharges = Convert.ToDecimal(dr["EmergencyCharges"]),
WardID = Convert.ToInt32(dr["WardID"]),
ServicesDetailsTPAWiseID = Convert.ToInt32(dr["ServicesDetailsTPAWiseID"]),
});
}
//return View(ServiceTPACharges);
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public JsonResult GetOrganisation(string prefix)
{
Buisness_Logic.Master.BL_ServiceTPAWise Bl_obj = new Buisness_Logic.Master.BL_ServiceTPAWise();
DataSet ds = Bl_obj.GetOrganisation(prefix);
List <ServicesTPAWise> searchList = new List <ServicesTPAWise>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchList.Add(new ServicesTPAWise
{
OrganizationID = dr["OrganizationID"].ToString(),
OrganizationName = dr["OrganizationName"].ToString()
});
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetWardDetailsPivot()
{
Buisness_Logic.Master.BL_ServiceTPAWise objServiceTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
dsSer.ds = objServiceTPAWise.GetWardDetailsPivot();
var modeladd = new List <dynamic>(dsSer.ds.Tables[0].Rows.Count);
int a = 0;
foreach (DataRow row in dsSer.ds.Tables[0].Rows)
{
var obj = (IDictionary <string, object>) new System.Dynamic.ExpandoObject();
a = 0;
foreach (DataColumn col in dsSer.ds.Tables[0].Columns)
{
string Rowname = row[col].ToString();
//if (a > 3)
//{
// if (row[col].ToString() == "")
// {
// row[col] = 0;
// }
// //string aa = Convert.ToDecimal(row["TotalAmount"]).ToString();
// //string aa1 = Convert.ToDecimal(row[col]).ToString();
// //decimal TotalPer = Convert.ToDecimal(row["TotalAmount"]) / 100 * Convert.ToDecimal(row[col]);
// Rowname = "(" + row[col].ToString() + "%)" + " " + "(Rs " + Math.Round(TotalPer, 2).ToString() + ")";
//}
obj.Add(col.ColumnName, Rowname.ToString());
a++;
}
modeladd.Add(obj);
}
return(new JsonResult {
Data = modeladd, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetServicesTPAWiseDetail(int ServicesTPAWiseID)
{
Buisness_Logic.Master.BL_ServiceTPAWise objServiceTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
DataSet ds = new DataSet();
ds = objServiceTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
List <ServicesTPAWise> searchList = new List <ServicesTPAWise>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchList.Add(new ServicesTPAWise
{
WardName = dr["WardName"].ToString(),
GeneralCharges = Convert.ToDecimal(dr["GeneralCharges"]),
EmergencyCharges = Convert.ToDecimal(dr["EmergencyCharges"]),
});
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
