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(); }