protected void grdLocation_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = int.Parse(e.CommandArgument.ToString());
Session.Add("rowIndex", rowIndex);
ManageLocation locationObj = new ManageLocation();
DataTable dt = locationObj.getALocation(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, rowIndex);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txtLocationName.Value = DBUtility.readDBString(dr, "Location_Name");
txtLocationDescription.Value = DBUtility.readDBString(dr, "Location_Description");
if (dr["Disable"] != null && !dr.IsNull("Disable"))
{
chkBoxLocationDisable.Checked = Convert.ToBoolean(dr["Disable"]);
}
}
}
protected void btnSaveLocation_ServerClick(object sender, EventArgs e)
{
LocationObject obj = new LocationObject();
obj.Location_Name = txtLocationName.Value;
obj.Location_Description = txtLocationDescription.Value;
obj.Disable = chkBoxLocationDisable.Checked;
ManageLocation manageLocations = new ManageLocation();
bool success = manageLocations.insert(obj, ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
}
protected void btnSaveLocation_ServerClick(object sender, EventArgs e)
{
LocationObject obj = new LocationObject();
obj.Location_Name = txtLocationName.Value;
obj.Location_Description = txtLocationDescription.Value;
obj.Disable = chkBoxLocationDisable.Checked;
ManageLocation manageLocations = new ManageLocation();
bool success = manageLocations.updateALocation(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"]));
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
Session.Remove("rowIndex");
}
private void bindLstLocation()
{
ManageLocation manageLocation = new ManageLocation();
var lstLocation = manageLocation.getLocationList(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
lstVehicleLocation.DataSource = lstLocation;
lstVehicleLocation.DataTextField = "Location_Name";
lstVehicleLocation.DataValueField = "Location_Name";
lstVehicleLocation.DataBind();
}
protected void grdLocation_Load(object sender, EventArgs e)
{
ManageLocation locationObj = new ManageLocation();
grdLocation.DataSource = locationObj.getLocationInfo(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
grdLocation.DataBind();
}
