/// <summary>
///
/// </summary>
/// <param name="dvcode"></param>
/// <param name="dcrActualDate"></param>
/// <param name="prodBringType"></param>
/// <returns></returns>
public JsonResult DeleteDoctorVisitData(string dvcode, string dcrActualDate, string prodBringType)
{
string userCode = _objcurrentInfo.GetUserCode();
string companyCode = _objcurrentInfo.GetCompanyCode();
DataSet dsProducts = new DataSet();
string result = _objSPData.DeleteDoctorVisitData(dvcode, dcrActualDate);
List <DCRProductDetailsModel> lstProducts = new List <DCRProductDetailsModel>();
if (result.ToUpper() == "SUCCESS")
{
// Execute the Query and returns the DataSet.
dsProducts = _objSPData.GetSelectedProducts(companyCode, userCode, prodBringType, "");
DataTable dtProducts = dsProducts.Tables[0];
// Convert the DataTable to list.
lstProducts = (from Products in dtProducts.AsEnumerable()
select new DCRProductDetailsModel
{
label = Products["Product_Name"].ToString() + "(" + Products["Stock"].ToString() + ")",
value = Products["Product_Code"].ToString(),
Product_Code = Products["Product_Code"].ToString().Split('_')[0]
}).ToList <DCRProductDetailsModel>();
// returns the list.
}
//return Json(lstProducts, JsonRequestBehavior.AllowGet);
return(new LargeJsonResult
{
MaxJsonLength = Int32.MaxValue,
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new
{
total = lstProducts.Count,
Data = lstProducts
}
});
}
