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