public List <Committe> GetCommitte()
{
committe = new List <Committe>();
try
{
string Get = " Select * from Committe ";
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(Get, con);
cmd.Transaction = tran;
dr = cmd.ExecuteReader();
while (dr.Read())
{
Committe c = new Committe();
c.CommitteID = Convert.ToInt32(dr["ID"]);
c.CommitteName = dr["CommitteName"].ToString();
committe.Add(c);
}
dr.Close();
tran.Commit();
return(committe);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public bool DeleteCommitte(Committe c)
{
try
{
string delete = "Delete from Committe where ID=" + c.CommitteID + "";
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(delete, con);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public List <Committe> GetCommittes(Membership mem)
{
List <Committe> cms = new List <Committe>();
try
{
string insert = "Select mc.*,c.CommitteName from MemberComittee mc,Committe c where c.ID = mc.CommitteeID and mc.MID=" + mem.MID;
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(insert, con);
cmd.Transaction = tran;
dr = cmd.ExecuteReader();
while (dr.Read())
{
Committe cm = new Committe();
cm.CommitteID = Convert.ToInt32(dr["CommitteeID"]);
cm.CommitteName = dr["CommitteName"].ToString();
cms.Add(cm);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(cms);
}
public bool SaveCommitte(Committe c)
{
try
{
string insert;
if (c.CommitteID == 0)
{
insert = " Insert into Committe (CommitteName) values ('" + c.CommitteName + "')";
}
else
{
insert = "Update Committe set CommitteName='" + c.CommitteName + "' where ID=" + c.CommitteID + "";
}
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(insert, con);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private void tsSelect_Click(object sender, EventArgs e)
{
int ID = Convert.ToInt32(DGVCountry.CurrentRow.Cells["Committeid"].Value);
if (DGVCountry.CurrentRow != null)
{
if (DGVCountry.CurrentRow.Cells["Committeid"].Value != null)
{
this.CurrentCommitte = ((Committe)committe.Where(c => c.CommitteID == ID).Single <Committe>());
}
}
this.Close();
}
public List <Committe> GetMemberCommitte(Membership MemberID)
{
LoCommitte = new List <Committe>();
try
{
string Get = "SELECT mc.CommitteeID,c.CommitteName from Committe c,MemberComittee mc,MembershipData md" +
" WHERE mc.CommitteeID=c.ID AND mc.MID=md.MID AND md.MID=" + MemberID.MID;
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(Get, con);
cmd.Transaction = tran;
dr = cmd.ExecuteReader();
while (dr.Read())
{
Committe c = new Committe();
c.CommitteID = Convert.ToInt32(dr["CommitteeID"]);
c.CommitteName = dr["CommitteName"].ToString();
LoCommitte.Add(c);
}
dr.Close();
tran.Commit();
return(LoCommitte);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private void tsSave_Click(object sender, EventArgs e)
{
try
{
if (txtCommitte.Text.Length > 0)
{
c = new Committe();
c.CommitteName = this.txtCommitte.Text.Trim();
if (frm.CurrentCommitte != null)
{
c.CommitteID = frm.CurrentCommitte.CommitteID;
}
if (new CommitteBLL().SaveCommitte(c))
{
MessageBox.Show("Committe Saved Successfully", "Success");
ClearControls();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void tsSave_Click_1(object sender, EventArgs e)
{
try
{
if (txtname.Text.Length > 0)
{
memb = new Membership();
memb.branch.BranchName = this.cbxbranches.Text.Trim();
memb.MemberName = this.txtname.Text.Trim();
memb.MemberLastName = this.txtfathername.Text.Trim();
Decimal age;
Decimal.TryParse(this.txtAge.Text, out age);
memb.AGE = age;
memb.Gender = this.cbxGender.Text.Trim();
memb.NIC = this.txtNIC.Text.Trim();
// memb.Refrence = cbxReference.SelectedItem as Membership;
memb.refrence = cbxReference.Text.Trim();
memb.Phone = this.txtPhoneNumber.Text;
memb.Email = this.txtEmaiAdress.Text.Trim();
memb.BloodGroup = this.cbxbloodGroup.Text.Trim();
Decimal memFee;
Decimal.TryParse(this.txtMembershipFee.Text, out memFee);
memb.MembershipFee = memFee;
Decimal memno;
Decimal.TryParse(this.txtMembersshipNo.Text, out memno);
memb.MembershipNo = memno;
memb.Status = this.cbxStatus.Text.Trim();
Decimal monthFee;
Decimal.TryParse(this.txtMonthlyFee.Text, out monthFee);
memb.MonthlyFee = monthFee;
DateTime colldate;
DateTime.TryParse(this.dtpCollectionDate.Text, out colldate);
memb.CollectionDate = colldate;
memb.Adress = this.txtAdress.Text.Trim();
memb.CurrentDate = dtpcurrentdate.Value.Date;
memb.City.CityName = cbxCities.Text.Trim();
memb.Country.CountryName = cbxCountry.Text.Trim();
memb.MemberType = cbxMembertype.Text.Trim();
foreach (var item in cbxCounsil.CheckedItems)
{
Counsil cl = (Counsil)item;
memb.Counsil.Add(cl);
}
foreach (var item in cbxCommitte.CheckedItems)
{
Committe cm = (Committe)item;
memb.Committe.Add(cm);
}
if (frm.CurrentMembership != null)
{
memb.MID = frm.CurrentMembership.MID;
}
if (new MembershipBLL().SaveMembersData(memb))
{
MessageBox.Show("Membership Saved Successfully", "Success");
ClearControls();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool DeleteCommitte(Committe c)
{
return(new CommitteDAL().DeleteCommitte(c));
}
public bool SaveCommitte(Committe c)
{
return(new CommitteDAL().SaveCommitte(c));
}
