public bool DeleteCounsil(Counsil c)
{
try
{
string delete = "Delete from Counsil where CounsilID=" + c.CounsilID + "";
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 <Counsil> GetCounsil()
{
Locounsil = new List <Counsil>();
try
{
string Get = " Select * from Counsil ";
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())
{
Counsil c = new Counsil();
c.CounsilID = Convert.ToInt32(dr["CounsilID"]);
c.CounsilName = dr["CounsilName"].ToString();
Locounsil.Add(c);
}
dr.Close();
tran.Commit();
return(Locounsil);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public bool SaveCounsil(Counsil c)
{
try
{
string insert;
if (c.CounsilID == 0)
{
insert = " Insert into Counsil (CounsilName) values ('" + c.CounsilName + "')";
}
else
{
insert = "Update Counsil set CounsilName='" + c.CounsilName + "' where CounsilID=" + c.CounsilID + "";
}
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();
}
}
public List <Counsil> GetCouncils(Membership mem)
{
List <Counsil> councils = new List <Counsil>();
try
{
members = new List <Membership>();
string insert = "Select mc.*,c.CounsilName from MemberCouncil mc,Counsil c where c.CounsilID = mc.CounsilId 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())
{
Counsil c = new Counsil();
c.CounsilID = Convert.ToInt32(dr["CounsilID"]);
c.CounsilName = dr["CounsilName"].ToString();
councils.Add(c);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(councils);
}
private void tsSelect_Click(object sender, EventArgs e)
{
if (DGVCounsil.CurrentRow != null)
{
if (DGVCounsil.CurrentRow.Cells["CounsilID"].Value != null)
{
int ID = Convert.ToInt32(DGVCounsil.CurrentRow.Cells["CounsilID"].Value);
this.CurrentCounsil = ((Counsil)Counsil.Where(c => c.CounsilID == ID).Single <Counsil>());
}
}
this.Close();
}
public List <Counsil> GetMemberCouncil(Membership MemberID)
{
Locounsil = new List <Counsil>();
try
{
string Get = "SELECT mc.CounsilID,c.CounsilName from Counsil c,MemberCouncil mc,MembershipData md" +
" WHERE mc.CounsilID=c.CounsilID 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())
{
Counsil c = new Counsil();
c.CounsilID = Convert.ToInt32(dr["CounsilID"]);
c.CounsilName = dr["CounsilName"].ToString();
Locounsil.Add(c);
}
dr.Close();
tran.Commit();
return(Locounsil);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private void tsSave_Click(object sender, EventArgs e)
{
try
{
if (txtCounsil.Text.Length > 0)
{
c = new Counsil();
c.CounsilName = this.txtCounsil.Text.Trim();
if (frm.CurrentCounsil != null)
{
c.CounsilID = frm.CurrentCounsil.CounsilID;
}
if (new CounsilBLL().SaveCounsil(c))
{
MessageBox.Show("Counsil Saved Successfully", "Success");
ClearControls();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool DeleteCounsil(Counsil c)
{
return(new CounsilDAL().DeleteCounsil(c));
}
public bool SaveCounsil(Counsil c)
{
return(new CounsilDAL().SaveCounsil(c));
}
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);
}
}
