public Guarantors(Guid guarantor_ID)
{
GuarantorsBL guarantors = new GuarantorsBL();
tblGuarantors = guarantors.GetGuarantorByGuarantor_ID(guarantor_ID);
Guarantor_ID = guarantor_ID;
IsShow_IDNull = tblGuarantors[0].IsShow_IDNull();
if (!IsShow_IDNull)
Show_ID = tblGuarantors[0].Show_ID;
IsChairman_Person_IDNull = tblGuarantors[0].IsChairman_Person_IDNull();
if (!IsChairman_Person_IDNull)
Chairman_Person_ID = tblGuarantors[0].Chairman_Person_ID;
IsSecretary_Person_IDNull = tblGuarantors[0].IsSecretary_Person_IDNull();
if (!IsSecretary_Person_IDNull)
Secretary_Person_ID = tblGuarantors[0].Secretary_Person_ID;
IsTreasurer_Person_IDNull = tblGuarantors[0].IsTreasurer_Person_IDNull();
if (!IsTreasurer_Person_IDNull)
Treasurer_Person_ID = tblGuarantors[0].Treasurer_Person_ID;
IsCommittee1_Person_IDNull = tblGuarantors[0].IsCommittee1_Person_IDNull();
if (!IsCommittee1_Person_IDNull)
Committee1_Person_ID = tblGuarantors[0].Committee1_Person_ID;
IsCommittee2_Person_IDNull = tblGuarantors[0].IsCommittee2_Person_IDNull();
if (!IsCommittee2_Person_IDNull)
Committee2_Person_ID = tblGuarantors[0].Committee2_Person_ID;
IsCommittee3_Person_IDNull = tblGuarantors[0].IsCommittee3_Person_IDNull();
if (!IsCommittee3_Person_IDNull)
Committee3_Person_ID = tblGuarantors[0].Committee3_Person_ID;
}
public List <Guarantors> GetGuarantorsByGuarantor_ID(Guid guarantor_ID)
{
List <Guarantors> guarantorList = new List <Guarantors>();
try
{
GuarantorsBL guarantors = new GuarantorsBL(_connString);
tblGuarantors = guarantors.GetGuarantorByGuarantor_ID(guarantor_ID);
if (tblGuarantors != null && tblGuarantors.Rows.Count > 0)
{
foreach (DataRow row in tblGuarantors.Rows)
{
Guarantors guarantor = new Guarantors(_connString, Utils.DBNullToGuid(row["Guarantor_ID"]));
guarantorList.Add(guarantor);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(guarantorList);
}
public Guarantors(string connString, Guid guarantor_ID)
{
_connString = connString;
try
{
GuarantorsBL guarantors = new GuarantorsBL(_connString);
tblGuarantors = guarantors.GetGuarantorByGuarantor_ID(guarantor_ID);
DataRow row = tblGuarantors.Rows[0];
_guarantor_ID = guarantor_ID;
_show_ID = Utils.DBNullToGuid(row["Show_ID"]);
_chairman_Person_ID = Utils.DBNullToGuid(row["Chairman_Person_ID"]);
_secretary_Person_ID = Utils.DBNullToGuid(row["Secretary_Person_ID"]);
_treasurer_Person_ID = Utils.DBNullToGuid(row["Treasurer_Person_ID"]);
_committee1_Person_ID = Utils.DBNullToGuid(row["Committee1_Person_ID"]);
_committee2_Person_ID = Utils.DBNullToGuid(row["Committee2_Person_ID"]);
_committee3_Person_ID = Utils.DBNullToGuid(row["Committee3_Person_ID"]);
}
catch (Exception ex)
{
throw ex;
}
}
public List<Guarantors> GetGuarantorsByGuarantor_ID(Guid guarantor_ID)
{
List<Guarantors> guarantorList = new List<Guarantors>();
GuarantorsBL guarantors = new GuarantorsBL();
tblGuarantors = guarantors.GetGuarantorByGuarantor_ID(guarantor_ID);
if (tblGuarantors != null && tblGuarantors.Count > 0)
{
foreach (sss.tblGuarantorsRow row in tblGuarantors)
{
Guarantors guarantor = new Guarantors(row.Guarantor_ID);
guarantorList.Add(guarantor);
}
}
return guarantorList;
}