public void GetTitrationTemplateData(int MadicationNameId)
    {
        Streamline.UserBusinessServices.ClientMedication objClientMedication = null;
        DataSet _dataSetTitrationTemplate = new DataSet();

        Streamline.UserBusinessServices.DataSets.DataSetTitrationTemplate _dsTitrationTemplate = null;
        try
        {
            objClientMedication       = new ClientMedication();
            _dataSetTitrationTemplate = objClientMedication.GetTitrationTemplateData(MadicationNameId);
            _dsTitrationTemplate      = new Streamline.UserBusinessServices.DataSets.DataSetTitrationTemplate();
            if (_dataSetTitrationTemplate != null)
            {
                _dsTitrationTemplate.Merge(_dataSetTitrationTemplate);
            }

            if (_dsTitrationTemplate != null)
            {
                Session["DataSetTitrationTemplate"] = _dsTitrationTemplate;
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }
    public void DeleteTitrationTemplate(int TitrationTemplateId, string filterCondition)
    {
        Streamline.UserBusinessServices.DataSets.DataSetTitrationTemplate.TitrationTemplatesRow _drTitrationTemplates = null;
        Streamline.UserBusinessServices.DataSets.DataSetTitrationTemplate _dsTitrationTemplate = null;

        DataTable dataTableTitrationTemplate = null;

        Streamline.UserBusinessServices.ClientMedication objClientMedication = null;
        try
        {
            if (Session["DataSetTitrationTemplate"] != null)
            {
                _dsTitrationTemplate = (Streamline.UserBusinessServices.DataSets.DataSetTitrationTemplate)Session["DataSetTitrationTemplate"];
            }
            else
            {
                _dsTitrationTemplate = new Streamline.UserBusinessServices.DataSets.DataSetTitrationTemplate();
            }
            dataTableTitrationTemplate = _dsTitrationTemplate.TitrationTemplates;
            DataRow[] dataRowTitrationTemplate = dataTableTitrationTemplate.Select("TitrationTemplateId=" + TitrationTemplateId);
            if (dataRowTitrationTemplate.Length > 0)
            {
                dataRowTitrationTemplate[0]["RecordDeleted"] = "Y";
                dataRowTitrationTemplate[0]["DeletedDate"]   = Convert.ToDateTime(DateTime.Now.ToShortDateString());
                //dataRowTitrationTemplate[0]["DeletedBy"] = Context.User.Identity.Name;
                dataRowTitrationTemplate[0]["DeletedBy"]    = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
                dataRowTitrationTemplate[0]["ModifiedBy"]   = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
                dataRowTitrationTemplate[0]["ModifiedDate"] = Convert.ToDateTime(DateTime.Now.ToShortDateString());
            }

            objClientMedication = new ClientMedication();
            DataSet temp = new DataSet();
            temp = objClientMedication.UpdateDocuments(_dsTitrationTemplate);
            _dsTitrationTemplate.Clear();
            _dsTitrationTemplate.Merge(temp.Tables["TitrationTemplates"]);
            _dsTitrationTemplate.Merge(temp.Tables["TitrationTemplateInstructions"]);
            Session["DataSetTitrationTemplate"] = _dsTitrationTemplate;
            GenerateTitrationTemplateRows(filterCondition);
            //return 1;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }