protected void FormView1_ItemDeleted1(object sender, FormViewDeletedEventArgs e)
{
WellProfileDataContext dc = new WellProfileDataContext();
GridView1.DataSource = dc.Meters.ToList();
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
drpMeters.SelectedIndex = -1;
WellProfileDataContext dc = new WellProfileDataContext();
GridView1.DataSource = dc.Meters.ToList();
GridView1.DataBind();
}
protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
{
WellProfileDataContext dc = new WellProfileDataContext();
var NewDataSource = from data in dc.Meters.Where(x => x.MeterDescription == drpMeters.SelectedValue)
select data;
GridView1.DataSource = NewDataSource.ToList();
GridView1.DataBind();
FormView1.ChangeMode(FormViewMode.Edit);
}
private void bindGridView()
{
WellProfileDataContext dc = new WellProfileDataContext();
if (drpMeters.SelectedValue.Length > 0)
{
var NewDataSource = from data in dc.Meters.Where(x => x.MeterDescription == drpMeters.SelectedValue)
select data;
GridView1.DataSource = NewDataSource.ToList();
GridView1.DataBind();
}
else
{
GridView1.DataSource = dc.Meters.ToList();
GridView1.DataBind();
}
}
protected static List <Well> BindWellList()
{
List <Well> wells = new List <Well>();
WellProfileDataContext dc = new WellProfileDataContext();
wells = dc.Wells.ToList();
//foreach (Well wl in wells)
//{
// wells.Add(new Well
// {
// ExcaliburWellName = wl.ExcaliburWellName,
// WellID = wl.WellID
// });
//}
return(wells);
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
//System.Linq.IOrderedEnumerable<Meter> lm = Sort(dc.Meters.ToList(), e.SortExpression.ToString(), e.SortDirection.ToString());
//string sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
WellProfileDataContext dc = new WellProfileDataContext();
string area = e.SortExpression.ToString();
string order = GetSortDirection(area);
string caseSwitch = e.SortExpression.ToString();
switch (caseSwitch)
{
case "Area":
area = "Area";
break;
case "Metername":
area = "Metername";
break;
case "MeterDescription":
area = "MeterDescription";
break;
default:
break;
}
var NewDataSource = from data in dc.Meters
select data;
//System.Linq.IOrderedQueryable<Meter> query;
if (area == "Area")
{
if (order == "ASC")
{
NewDataSource = NewDataSource.OrderBy(x => x.Area);
}
else
{
NewDataSource = NewDataSource.OrderByDescending(x => x.Area);
}
}
if (area == "Metername")
{
if (order == "ASC")
{
NewDataSource = NewDataSource.OrderBy(x => x.Metername);
}
else
{
NewDataSource = NewDataSource.OrderByDescending(x => x.Metername);
}
}
GridView1.DataSource = NewDataSource.ToList();
GridView1.DataBind();
}
