using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Infragistics.Web.UI.ListControls;

public partial class Webform1 : System.Web.UI.Page
{

    RLDatabase.ODPClient oDb;
    RLUtils.Utils oUtils;
    protected void Page_Load(object sender, EventArgs e)
    {
       
        LoadGrid();
       
    }
    private void LoadGrid()
    {
        try
        {
            grdNotes.ClearDataSource();
            oDb = new RLDatabase.ODPClient();
            oUtils = new RLUtils.Utils();
            string sSQL = oDb.GetQueryFromXML("Root/Notes", "~/RI", CommandType.Text);
            DataSet oDs = oDb.GetDataSet(sSQL);
            grdNotes.DataSource = oDs.Tables[0];
        }
        catch (Exception ex)
        {
            CException cEx = new CException(ex.ToString());
        }
    }
    

    protected void Grd_DDPriority_Init(object sender, EventArgs e)
    {
        try
        {
            oDb = new RLDatabase.ODPClient();
            string sSQL = oDb.GetQueryFromXML("Root/Priority", "~/RI", CommandType.Text);
            DataSet oDs = oDb.GetDataSet(sSQL);

            WebDropDown dropdown = (WebDropDown)sender;
            dropdown.Items.Clear();
            dropdown.DataSource = oDs;
        }
        catch (Exception ex)
        {
            CException cEx = new CException(ex.ToString());
        }
    }

    protected void grdNotes_RowAdding(object sender, Infragistics.Web.UI.GridControls.RowAddingEventArgs e)
    {
        string s_priority = Convert.ToString(e.Values["PRIORITY"]);
        string s_Subject = Convert.ToString(e.Values["SUBJECT"]);
        string s_Created_By = Convert.ToString(e.Values["CREATED_BY"]);
        string s_Created_Date = Convert.ToString(e.Values["CREATED_DATE"]);
        string s_Notes = Convert.ToString(e.Values["NOTES"]);

        LoadGrid();
    }
    protected void grdNotes_RowsDeleting(object sender, Infragistics.Web.UI.GridControls.RowDeletingEventArgs e)
    {

    }
    protected void grdNotes_RowUpdating(object sender, Infragistics.Web.UI.GridControls.RowUpdatingEventArgs e)
    {
        //string s_id_note = Convert.ToString(e.Row.DataKey[0]);
        string s_priority = Convert.ToString(e.Values["RID_PRIORITY"]);
        string s_Subject = Convert.ToString(e.Values["SUBJECT"]);
        string s_Created_By = Convert.ToString(e.Values["CREATED_BY"]);
        string s_Created_Date = Convert.ToString(e.Values["CREATED_DATE"]);
        string s_Notes = Convert.ToString(e.Values["NOTES"]);
        LoadGrid();
    }
   
}