public void bindClientList() { ClientManager cl = new ClientManager(); DataSet ds = cl.getClientList(); if (ds.Tables[0].Rows.Count > 0) { ClientGrid.AutoGenerateColumns = false; ClientGrid.DataSource = null; //Set Columns Count ClientGrid.ColumnCount = 6; //Add Columns ClientGrid.Columns[0].Name = "ClientID"; ClientGrid.Columns[0].HeaderText = "Client ID"; ClientGrid.Columns[0].DataPropertyName = "ClientID"; ClientGrid.Columns[1].HeaderText = "Client Name"; ClientGrid.Columns[1].Name = "ClientName"; ClientGrid.Columns[1].DataPropertyName = "ClientName"; ClientGrid.Columns[2].Name = "LocationID"; ClientGrid.Columns[2].HeaderText = "Location ID"; ClientGrid.Columns[2].DataPropertyName = "LocationID"; ClientGrid.Columns[3].Name = "ClientEmail"; ClientGrid.Columns[3].HeaderText = "Client Email"; ClientGrid.Columns[3].DataPropertyName = "ClientEmail"; ClientGrid.Columns[4].Name = "ClientPhoneNo"; ClientGrid.Columns[4].HeaderText = "Contac No"; ClientGrid.Columns[4].DataPropertyName = "ClientPhoneNo"; ClientGrid.Columns[5].Name = "ClientAddress"; ClientGrid.Columns[5].HeaderText = "Client Address"; ClientGrid.Columns[5].DataPropertyName = "ClientAddress"; ClientGrid.DataSource = ds.Tables[0]; DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn(); Editlink.UseColumnTextForLinkValue = true; Editlink.HeaderText = "Edit"; Editlink.DataPropertyName = "lnkForEditColumn"; Editlink.LinkBehavior = LinkBehavior.SystemDefault; Editlink.Text = "Edit"; ClientGrid.Columns.Add(Editlink); DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn(); Deletelink.UseColumnTextForLinkValue = true; Deletelink.HeaderText = "delete"; Deletelink.DataPropertyName = "lnkForDeleteColumn"; Deletelink.LinkBehavior = LinkBehavior.SystemDefault; Deletelink.Text = "Delete"; ClientGrid.Columns.Add(Deletelink); //DataGridViewButtonColumn db = new DataGridViewButtonColumn(); //db.Text = "Delete"; //ClientGrid.Columns.Insert(6, (DataGridViewColumn)db); } }
public bool AddNewClient(ClientManager newClient) { SqlParameter[] sp = new SqlParameter[6]; sp[0] = new SqlParameter("@ClientName", newClient.ClientName); sp[1] = new SqlParameter("@LocationID", newClient.LocationID); sp[2] = new SqlParameter("@ClientEmail", newClient.ClientEmail); sp[3] = new SqlParameter("@ClientPhoneNo", newClient.ClientPhoneNo); sp[4] = new SqlParameter("@ClientAddress", newClient.ClientAddress); sp[5] = new SqlParameter("@IsDeleted", false); return datalayer.Execute_NonQuery("sp_AddClient", CommandType.StoredProcedure, sp); }
public void bindClientList(int LocationID) { ClientManager cm = new ClientManager(); DataSet ds = cm.getClientByLocationID(LocationID); if (ds.Tables[0].Rows.Count > 0) { drpClientList.DisplayMember = "ClientName"; drpClientList.ValueMember = "ClientID"; drpClientList.DataSource = ds.Tables[0]; } else { //drpLocation.Items.Add() } }
private void ClientGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { int Client_ID = 0; if (e.ColumnIndex == 6) { txtClientName.Text = ClientGrid.Rows[e.RowIndex].Cells["ClientName"].Value.ToString(); drpLocation.SelectedValue= Convert.ToInt32(ClientGrid.Rows[e.RowIndex].Cells["LocationID"].Value.ToString()); lblClientID.Text = ClientGrid.Rows[e.RowIndex].Cells["ClientID"].Value.ToString(); txtClientEmail.Text = ClientGrid.Rows[e.RowIndex].Cells["ClientEmail"].Value.ToString(); txtContactNo.Text = ClientGrid.Rows[e.RowIndex].Cells["ClientPhoneNo"].Value.ToString(); txtAddress.Text = ClientGrid.Rows[e.RowIndex].Cells["ClientAddress"].Value.ToString(); pnlClientForm.Visible = true; pnlClientGrid.Visible = false; btnAddClient.Visible = false; btnUpdate.Visible = true; } if (e.ColumnIndex == 7) { Client_ID = Convert.ToInt32(ClientGrid.Rows[e.RowIndex].Cells["ClientID"].Value); ClientManager cm = new ClientManager(); cm.DeleteClient(Client_ID); bindClientList(); pnlClientForm.Visible = false; pnlClientGrid.Visible = true; } }
private void btnUpdate_Click(object sender, EventArgs e) { int ClientID = Convert.ToInt32(lblClientID.Text); string ClientName = txtClientName.Text; int LocationID = Convert.ToInt32(drpLocation.SelectedValue); string ClientEmail = txtClientEmail.Text; string ph = txtContactNo.Text; string address = txtAddress.Text; ClientManager cl = new ClientManager(ClientName, LocationID, ClientEmail, ph, address); cl.ClientID = ClientID; bool res = cl.updateClient(cl); if (res) { MessageBox.Show("Record Updated Succesfully.!"); bindClientList(); pnlClientGrid.Visible = true; pnlClientForm.Visible = false; btnUpdate.Visible = false; } else { MessageBox.Show("Error.!"); } }