private void btnSave_Click(object sender, EventArgs e) { try { string vMessage = string.Empty; if (txtName.Text.Trim() == string.Empty) { vMessage = "Please Insert Company Name!"; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Information Missing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtName.Focus(); return; } Objects.CompanyInfo obj = new Objects.CompanyInfo(); obj.CompanyName = txtName.Text.Trim(); obj.Phone = txtPhone.Text.Trim(); obj.Web = txtWeb.Text.Trim(); obj.Address = txtAddress.Text.Trim(); if (imgLogo.Image != null) { MemoryStream ms = new MemoryStream(); imgLogo.Image.Save(ms, imgLogo.Image.RawFormat); byte[] arrayImage = ms.GetBuffer(); obj.Logo = arrayImage; } objDAL.DeleteRecord(); objDAL.InsertRecord(obj); //ms.Close(); // Closes the Memory Stream vMessage = "Record Saved Successfully."; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Task Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }
public void InsertRecord(Objects.CompanyInfo obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_InsCompanyInfo"; cmd.Parameters.AddWithValue("@_CompanyName", obj.CompanyName); cmd.Parameters.AddWithValue("@_Address", obj.Address); cmd.Parameters.AddWithValue("@_Phone", obj.Phone); cmd.Parameters.AddWithValue("@_Web", obj.Web); cmd.Parameters.AddWithValue("@_CompanyLogo", obj.Logo); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }