private void saveButton_Click(object sender, EventArgs e)
{
MemberModel member = new MemberModel();
member.Id = Convert.ToInt32(idTextBox.Text);
member.Name = nameTextBox.Text;
member.Type = memberTypeTextBox.Text;
member.EntryDate = Convert.ToDateTime(entryDate.Text);
member.Address = addressTextBox.Text;
member.Contact = contactTextBox.Text;
string msg = memberbll.Insert(member);
MessageBox.Show(msg);
}
public string Insert(MemberModel member)
{
string url = @"server=faruk\SQLEXPRESS; database=library; integrated security=true";
SqlConnection connection = new SqlConnection(url);
connection.Open();
string query = string.Format("insert into member_table values ('{0}','{1}','{2}','{3}','{4}','{5}')", member.Id, member.Name, member.Type, member.EntryDate, member.Address, member.Contact);
SqlCommand command = new SqlCommand(query, connection);
int affectedrow = command.ExecuteNonQuery();
if (affectedrow > 0)
return "successful";
else
{
return "some error";
}
}
public string Insert(MemberModel member)
{
return gateway.Insert(member);
}
