public string save(MemberEntry aMemberEntry)
 {
     try
     {
         aSqlConnection.Open();
         SqlCommand command = new SqlCommand("USPInsertIntoMemberCode", aSqlConnection);
         command.CommandType = CommandType.StoredProcedure;
         command.Parameters.AddWithValue("@memberName", aMemberEntry.name);
         command.Parameters.AddWithValue("@roomNo", aMemberEntry.roomNo);
         command.Parameters.AddWithValue("@address", aMemberEntry.address);
         command.Parameters.AddWithValue("@dateOfEntry", aMemberEntry.dateOfEntry);
         int effectedRows = command.ExecuteNonQuery();
         if (effectedRows > 0)
         {
             return "Member saved successfully.";
         }
     }
     catch (Exception e)
     {
         throw new Exception(e.Message, e);
     }
     finally
     {
         if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open)
         {
             aSqlConnection.Close();
         }
     }
     return "Error while saving member.";
 }
 public EditMemberCodeEntryUI(MemberEntry aEditMemberEntry)
     : this()
 {
     this.memberIdTextBox.Text = aEditMemberEntry.memberId.ToString();
     memberIdTextBox.Enabled = false;
     this.memberNameTextBox.Text = aEditMemberEntry.name;
     this.roomNoTextBox.Text = aEditMemberEntry.roomNo;
     this.addressTextBox.Text = aEditMemberEntry.address;
     dateTimePicker1.Value = aEditMemberEntry.dateOfEntry;
 }
 public string save(MemberEntry aMemberEntry)
 {
     if ((aMemberEntry.name == string.Empty)||(aMemberEntry.roomNo==string.Empty)||(aMemberEntry.address==string.Empty))
     {
         return "please fill up all field";
     }
     else
     {
         MemberEntryValidator validator = new MemberEntryValidator();
         validator.validateNameAndRoomNumber(aMemberEntry.name,aMemberEntry.roomNo);
         return aMemberCodeEntryGateway.save(aMemberEntry);
     }
 }
 private void updateButton_Click(object sender, EventArgs e)
 {
     try
     {
         MemberCodeEntryBLL aMemberCodeEntryBll = new MemberCodeEntryBLL();
         MemberEntry aMemberEntry = new MemberEntry(Convert.ToInt32(memberIdTextBox.Text), memberNameTextBox.Text,
             roomNoTextBox.Text, addressTextBox.Text, dateTimePicker1.Value);
         string msg = aMemberCodeEntryBll.update(aMemberEntry);
         MessageBox.Show(msg, @"Message");
         Hide();
         new MemberCodeEntryUI().Show();
     }
     catch(Exception exception)
     {
         MessageBox.Show(exception.Message,@"Message");
     }
 }
        public System.Collections.Generic.List<DAO.MemberEntry> getMemberCodeInfo()
        {
            try
            {
                aSqlConnection.Open();
                SqlCommand command = new SqlCommand("uspMembers", aSqlConnection);
                command.CommandType = CommandType.StoredProcedure;
                SqlDataReader aReader = command.ExecuteReader();
                memberCodeList = new List<MemberEntry>();
                if (aReader.HasRows)
                {
                    while (aReader.Read())
                    {
                        MemberEntry aMemberEntry = new MemberEntry();
                        aMemberEntry.memberId = Convert.ToInt32(aReader[0].ToString());
                        aMemberEntry.name = aReader[1].ToString();
                        aMemberEntry.roomNo = aReader[2].ToString();
                        aMemberEntry.address = aReader[3].ToString();
                        aMemberEntry.dateOfEntry = (DateTime)aReader[4];
                        memberCodeList.Add(aMemberEntry);
                    }
                }

            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open)
                {
                    aSqlConnection.Close();
                }
            }
            return memberCodeList;
        }
 private void saveButton_Click(object sender, EventArgs e)
 {
     try
     {
         MemberEntry aMemberEntry = new MemberEntry(memberNameTextBox.Text, roomNoTextBox.Text, addressTextBox.Text, dateTimePicker1.Value);
         string msg = aMemberCodeEntryBll.save(aMemberEntry);
         showDataInDataGridView();
         MessageBox.Show(msg, @"Message");
         clearTextBoxes();
         MemberCodeEntryUI_Load(0, null);
     }
     catch (Exception exception)
     {
         MessageBox.Show(exception.Message);
     }
 }
 public string update(MemberEntry aMemberEntry)
 {
     try
     {
         aSqlConnection.Open();
         SqlCommand command = new SqlCommand("USPMemberInfoUpdation", aSqlConnection);
         command.CommandType = CommandType.StoredProcedure;
         command.Parameters.AddWithValue("@memberId", aMemberEntry.memberId);
         command.Parameters.AddWithValue("@memberName", aMemberEntry.name);
         command.Parameters.AddWithValue("@roomNo", aMemberEntry.roomNo);
         command.Parameters.AddWithValue("@address", aMemberEntry.address);
         command.Parameters.AddWithValue("@dateOfEntry", aMemberEntry.dateOfEntry);
         int effectedRows = command.ExecuteNonQuery();
         if (effectedRows > 0)
         {
             return @"Memeber Information is updated";
         }
     }
     catch (Exception e)
     {
         throw new Exception(e.Message);
     }
     finally
     {
         if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open)
         {
             aSqlConnection.Close();
         }
     }
     return "Error while updating member.";
 }
 public string update(MemberEntry aMemberEntry)
 {
     new EditMemberCodeEntryValidator().isRoomNumberAndMemberNameValid(aMemberEntry.roomNo, aMemberEntry.name);
        return aMemberCodeEntryGateway.update(aMemberEntry);
 }