public DataView BindAreaZoneDetail() { DataTable dt = new DataTable(); dt = AreaZoneMaster.GetAreaZoneMaster(); DataView dv = new DataView(dt); return(dv); }
public void SaveAreaZoneMaster() { if (DDLSuperZone.SelectedIndex == 0) { MessageBox("Select SuperZone"); DDLSuperZone.Focus(); } if (DDLZone.SelectedIndex == 0) { MessageBox("Select Zone"); DDLZone.Focus(); } else { AreaZoneMaster _ObjAreaZoneMaster = new AreaZoneMaster(); _ObjAreaZoneMaster.AreaZoneID = Convert.ToInt32(lblID.Text); _ObjAreaZoneMaster.AreaZoneCode = txtAreaZoneCode.Text.Trim(); _ObjAreaZoneMaster.AreaZoneName = txtAreaZoneName.Text.Trim(); _ObjAreaZoneMaster.ZoneID = Convert.ToInt32(DDLZone.SelectedItem.Value.ToString()); _ObjAreaZoneMaster.IsActive = Chekacv.Checked; try { _ObjAreaZoneMaster.Save(); MessageBox("Record saved successfully"); grdAreaZoneDetails.DataSource = BindAreaZoneDetail(); grdAreaZoneDetails.DataBind(); if (btnSave.Text == "Update") { pnlAreaZoneDetails.Visible = true; PnlAreaZone.Visible = false; btnSave.Visible = false; btnSave.Text = "Save"; txtAreaZoneCode.Enabled = true; filter.Visible = true; } else { PnlAreaZone.Visible = true; pnlAreaZoneDetails.Visible = false; txtAreaZoneCode.Text = ""; txtAreaZoneName.Text = ""; DDLSuperZone.SelectedValue = null; DDLZone.Items.Clear(); //DDLZone.SelectedValue = null; Bind_DDL_SuperZone(); } } catch { } } }
protected void grdAreaZoneDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { AreaZoneMaster _objAZM = new AreaZoneMaster(); _objAZM.AreaZoneID = Convert.ToInt32(((Label)grdAreaZoneDetails.Rows[e.RowIndex].FindControl("lblAreaZoneID")).Text); _objAZM.AreaZoneCode = ((Label)grdAreaZoneDetails.Rows[e.RowIndex].FindControl("lblAreaZoneCode")).Text; _objAZM.AreaZoneName = ((Label)grdAreaZoneDetails.Rows[e.RowIndex].FindControl("lblAreaZoneName")).Text; _objAZM.IsActive = Convert.ToBoolean(false); _objAZM.IsDeleted = Convert.ToBoolean(true); try { _objAZM.Save(); // MessageBox("Your Record is deleted"); grdAreaZoneDetails.DataSource = BindAreaZoneDetail(); grdAreaZoneDetails.DataBind(); pnlAreaZoneDetails.Visible = true; PnlAreaZone.Visible = false; } catch { } }