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); }