//public DataSet FetchMap()
// {
// DataSet ds = new DataSet();
// SpotDetailsDAL sp = new SpotDetailsDAL();
// ds = sp.FetchMap();
// return ds;
// }
public DataSet FetchSpotDetails1()
{
DataSet ds = new DataSet();
SpotDetailsDAL sp = new SpotDetailsDAL();
ds = sp.FetchSpotDetails1();
return ds;
}
public DataTable EditSpotDetails(string SpotID)
{
DataTable ds = new DataTable();
SpotDetailsDAL sp = new SpotDetailsDAL();
ds = sp.EditSpotDetails(SpotID);
return ds;
}
public int DeleteSpotDetails(string SpotID)
{
int a;
SpotDetailsDAL sp = new SpotDetailsDAL();
a = sp.DeleteSpotDetails(SpotID);
return a;
}
public DataTable EditSpotDetails(string SpotID)
{
DataTable ds = new DataTable();
SpotDetailsDAL sp = new SpotDetailsDAL();
ds = sp.EditSpotDetails(SpotID);
return(ds);
}
public int DeleteSpotDetails(string SpotID)
{
int a;
SpotDetailsDAL sp = new SpotDetailsDAL();
a = sp.DeleteSpotDetails(SpotID);
return(a);
}
//public DataSet FetchMap()
// {
// DataSet ds = new DataSet();
// SpotDetailsDAL sp = new SpotDetailsDAL();
// ds = sp.FetchMap();
// return ds;
// }
public DataSet FetchSpotDetails1()
{
DataSet ds = new DataSet();
SpotDetailsDAL sp = new SpotDetailsDAL();
ds = sp.FetchSpotDetails1();
return(ds);
}
protected void gridPageChanging(object sender, GridViewPageEventArgs e)
{
SpotDetailsDAL sp = new SpotDetailsDAL();
ds = sp.FetchSpotDetails1();
gridviewSpot.DataSource = ds.Tables[4];
gridviewSpot.PageIndex = e.NewPageIndex;
gridviewSpot.DataBind();
}
protected void gridPageChanging(object sender, GridViewPageEventArgs e)
{
SpotDetailsDAL sp = new SpotDetailsDAL();
ds = sp.FetchSpotDetails1();
gridviewSpot.DataSource = ds.Tables[4];
gridviewSpot.PageIndex = e.NewPageIndex;
gridviewSpot.DataBind();
}
public int UpdateSpotDetails(string SpotID, string SpotName, string Description, string Religion, string Deity, string Period, string BuiltBy,
string Architecture, string Sculpture, string painting, string Inscription, string Hymns, string Mythology, string Events,
string Timing, string Location, string Sketch, string SpotCategory, string SanctifiedBy, int Active)
{
int a;
SpotDetailsDAL sp = new SpotDetailsDAL();
a = sp.UpdateSpotDetails(SpotID,SpotName, Description, Religion, Deity, Period, BuiltBy,
Architecture, Sculpture, painting, Inscription, Hymns, Mythology, Events,
Timing, Location, Sketch, SpotCategory, SanctifiedBy, Active);
return a;
}
public int UpdateSpotDetails(string SpotID, string SpotName, string Description, string Religion, string Deity, string Period, string BuiltBy,
string Architecture, string Sculpture, string painting, string Inscription, string Hymns, string Mythology, string Events,
string Timing, string Location, string Sketch, string SpotCategory, string SanctifiedBy, int Active)
{
int a;
SpotDetailsDAL sp = new SpotDetailsDAL();
a = sp.UpdateSpotDetails(SpotID, SpotName, Description, Religion, Deity, Period, BuiltBy,
Architecture, Sculpture, painting, Inscription, Hymns, Mythology, Events,
Timing, Location, Sketch, SpotCategory, SanctifiedBy, Active);
return(a);
}