private void modify_Click(object sender, EventArgs e)
{
if (cdtextbox.TextLength > 0)
{
Activity_Layer moddata = new Activity_Layer();
client_details cd = new client_details();
cd.ClientID = cdtextbox.Text;
cd.ClientName = cntextbox.Text;
cd.ClientAddress = catextbox.Text;
cd.ContactNo = Convert.ToInt64(cctextbox.Text);
cd.IP_Address = iptextbox.Text;
cd.MAC_Address = mactextbox.Text;
cd.ConnectionType = cttextbox.Text;
cd.ConnTakenOn = conDatebox.Value;
cd.PackageTaken = packagecombobox.Text;
try
{
moddata.UpdateClientDetails(cd);
MessageBox.Show("Client Data Updated");
Cancel_Click(null, null);
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex, "OOPS!!!");
}
}
else
{
MessageBox.Show("Load data into the form first.");
}
}
public searchremovemodify(client_details _getcd)
{
InitializeComponent();
cdtextbox.Text = _getcd.ClientID;
cntextbox.Text = _getcd.ClientName;
catextbox.Text = _getcd.ClientAddress;
cctextbox.Text = _getcd.ContactNo.ToString();
iptextbox.Text = _getcd.IP_Address;
mactextbox.Text = _getcd.MAC_Address;
cttextbox.Text = _getcd.ConnectionType;
conDatebox.Value = _getcd.ConnTakenOn;
packagecombobox.Text = _getcd.PackageTaken;
Delete.Enabled = true;
}
public bool insert_clientdetails(client_details cd)
{
SqlConnection C = new SqlConnection(ConnectionString);
SqlCommand cd_add = new SqlCommand(
"INSERT INTO [dbo].[ClientDetails] ([ClientId], [ClientName], [ClientAddress], [ContactNo], [IP_Address], [MAC_Address], [ConnectionType], [ConnTakenOn], [PackageTaken] ) VALUES (@ClientId, @ClientName, @ClientAddress, @ContactNo, @IP_Address, @MAC_Address, @ConnectionType, @ConnTakenOn, @PackageTaken )", C);
SqlParameter p1 = new SqlParameter("@ClientId", SqlDbType.VarChar);
p1.Value = cd.ClientID;
SqlParameter p2 = new SqlParameter("@ClientName", SqlDbType.VarChar, 50);
p2.Value = cd.ClientName;
SqlParameter p3 = new SqlParameter("@ClientAddress", SqlDbType.VarChar, 255);
p3.Value = cd.ClientAddress;
SqlParameter p4 = new SqlParameter("@ContactNo", SqlDbType.Int);
p4.Value = cd.ContactNo;
SqlParameter p5 = new SqlParameter("@IP_Address", SqlDbType.VarChar, 50);
p5.Value = cd.IP_Address;
SqlParameter p6 = new SqlParameter("@MAC_Address", SqlDbType.VarChar, 50);
p6.Value = cd.MAC_Address;
SqlParameter p7 = new SqlParameter("@ConnectionType", SqlDbType.VarChar, 50);
p7.Value = cd.ConnectionType;
SqlParameter p8 = new SqlParameter("@ConnTakenOn", SqlDbType.DateTime);
p8.Value = cd.ConnTakenOn;
SqlParameter p9 = new SqlParameter("@PackageTaken", SqlDbType.VarChar, 50);
p9.Value = cd.PackageTaken;
cd_add.Parameters.Add(p1);
cd_add.Parameters.Add(p2);
cd_add.Parameters.Add(p3);
cd_add.Parameters.Add(p4);
cd_add.Parameters.Add(p5);
cd_add.Parameters.Add(p6);
cd_add.Parameters.Add(p7);
cd_add.Parameters.Add(p8);
cd_add.Parameters.Add(p9);
C.Open();
int result = cd_add.ExecuteNonQuery();
C.Close();
return(result > 0);
}
private void Submit_Click(object sender, EventArgs e)
{
var emptyimput = from tb in tableLayoutPanel1.Controls.OfType <TextBox>()
where string.IsNullOrWhiteSpace(tb.Text)
select tb;
if (emptyimput.Any())
{
MessageBox.Show("One or more input box is empty", "Can not execute command");
}
else
{
client_details cd = new client_details();
cd.ClientID = cdtextbox.Text;
cd.ClientName = cntextbox.Text;
cd.ClientAddress = catextbox.Text;
cd.ContactNo = Convert.ToInt64(cctextbox.Text);
cd.IP_Address = iptextbox.Text;
cd.MAC_Address = mactextbox.Text;
cd.ConnectionType = cttextbox.Text;
cd.ConnTakenOn = conDatebox.Value;
cd.PackageTaken = packagecombobox.Text;
DialogResult submitresult = MessageBox.Show("Are you sure that all data are correct? Pressing Ok will submit the data into the database", "Warning", MessageBoxButtons.YesNo);
if (submitresult == DialogResult.Yes)
{
try
{
Activity_Layer submittingrequest = new Activity_Layer();
submittingrequest.insert_clientdetails(cd);
MessageBox.Show("Entry Successful");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error Found" + ex, "Warning");
}
}
}
}
private void client_dataGridView_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
client_details cd_sent = new client_details();
int selectedindex = e.RowIndex;
object selectedObject = client_dataGridView.Rows[selectedindex].DataBoundItem;
DataRow ddt = (selectedObject as DataRowView).Row;
cd_sent.ClientID = ddt["ClientID"].ToString();
cd_sent.ClientName = ddt["ClientName"].ToString();
cd_sent.ClientAddress = ddt["ClientAddress"].ToString();
cd_sent.ContactNo = Convert.ToInt32(ddt["ContactNo"].ToString());
cd_sent.IP_Address = ddt["IP_Address"].ToString();
cd_sent.MAC_Address = ddt["MAC_Address"].ToString();
cd_sent.ConnectionType = ddt["ConnectionType"].ToString();;
cd_sent.ConnTakenOn = Convert.ToDateTime(ddt["ConnTakenOn"].ToString());
cd_sent.PackageTaken = ddt["PackageTaken"].ToString();
searchremovemodify _sending_client = new searchremovemodify(cd_sent);
_sending_client.Show();
}
public bool UpdateClientDetails(client_details cd_obj)
{
SqlConnection C = new SqlConnection(ConnectionString);
SqlCommand modclient = new SqlCommand(@"UPDATE [dbo].[ClientDetails] SET [ClientName]=@ClientName, [Clientaddress]=@ClientAddress,[ContactNo]=@ContactNo,[IP_Address]=@IP_Address,
[MAC_Address]=@MAC_Address,[ConnectionType]=@ConnectionType,[ConnTakenOn]=@ConnectionTakenOn,[PackageTaken]=@PackageTaken WHERE [ClientId] = @ClientId", C);
SqlParameter p1 = new SqlParameter("@ClientName", System.Data.SqlDbType.VarChar, 50);
p1.Value = cd_obj.ClientName;
modclient.Parameters.Add(p1);
SqlParameter p2 = new SqlParameter("@ClientAddress", System.Data.SqlDbType.VarChar, 255);
p2.Value = cd_obj.ClientAddress;
modclient.Parameters.Add(p2);
SqlParameter p3 = new SqlParameter("@ContactNo", System.Data.SqlDbType.Int);
p3.Value = cd_obj.ContactNo;
modclient.Parameters.Add(p3);
SqlParameter p4 = new SqlParameter("@IP_Address", System.Data.SqlDbType.VarChar);
p4.Value = cd_obj.IP_Address;
modclient.Parameters.Add(p4);
SqlParameter p5 = new SqlParameter("@MAC_Address", System.Data.SqlDbType.VarChar, 255);
p5.Value = cd_obj.MAC_Address;
modclient.Parameters.Add(p5);
SqlParameter p6 = new SqlParameter("@ConnectionType", System.Data.SqlDbType.VarChar, 255);
p6.Value = cd_obj.ConnectionType;
modclient.Parameters.Add(p6);
SqlParameter p7 = new SqlParameter("@ConnectionTakenOn", System.Data.SqlDbType.DateTime);
p7.Value = cd_obj.ConnTakenOn;
modclient.Parameters.Add(p7);
SqlParameter p8 = new SqlParameter("@PackageTaken", System.Data.SqlDbType.VarChar, 255);
p8.Value = cd_obj.PackageTaken;
modclient.Parameters.Add(p8);
SqlParameter p9 = new SqlParameter("@ClientId", System.Data.SqlDbType.VarChar, 50);
p9.Value = cd_obj.ClientID;
modclient.Parameters.Add(p9);
C.Open();
int result = modclient.ExecuteNonQuery();
C.Close();
return(result > 0);
}
