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> GetGuarantorsByShow_ID(Guid show_ID)
{
List <Guarantors> guarantorList = new List <Guarantors>();
try
{
GuarantorsBL guarantors = new GuarantorsBL(_connString);
tblGuarantors = guarantors.GetGuarantorsByShow_ID(show_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 bool Update_Guarantor(Guid guarantor_ID, Guid user_ID)
{
bool success = false;
try
{
GuarantorsBL guarantors = new GuarantorsBL(_connString);
success = guarantors.Update_Guarantors(guarantor_ID, _show_ID, _chairman_Person_ID, _secretary_Person_ID, _treasurer_Person_ID,
_committee1_Person_ID, _committee2_Person_ID, _committee3_Person_ID, _deleteGuarantor, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(success);
}
public Guid?Insert_Guarantor(Guid user_ID)
{
Guid?retVal = null;
try
{
GuarantorsBL guarantors = new GuarantorsBL(_connString);
retVal = (Guid?)guarantors.Insert_Guarantors(_show_ID, _chairman_Person_ID, _secretary_Person_ID, _treasurer_Person_ID,
_committee1_Person_ID, _committee2_Person_ID, _committee3_Person_ID, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
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 bool Update_Guarantor(Guid guarantor_ID, Guid user_ID)
{
bool success = false;
GuarantorsBL guarantors = new GuarantorsBL();
success = guarantors.Update_Guarantors(guarantor_ID, Show_ID, Chairman_Person_ID, Secretary_Person_ID, Treasurer_Person_ID,
Committee1_Person_ID, Committee2_Person_ID, Committee3_Person_ID, DeleteGuarantor, user_ID);
return success;
}
public Guid? Insert_Guarantor(Guid user_ID)
{
GuarantorsBL guarantors = new GuarantorsBL();
Guid? newID = (Guid?)guarantors.Insert_Guarantors(Show_ID, Chairman_Person_ID, Secretary_Person_ID, Treasurer_Person_ID,
Committee1_Person_ID, Committee2_Person_ID, Committee3_Person_ID, user_ID);
return newID;
}
public List<Guarantors> GetGuarantorsByShow_ID(Guid show_ID)
{
List<Guarantors> guarantorList = new List<Guarantors>();
GuarantorsBL guarantors = new GuarantorsBL();
tblGuarantors = guarantors.GetGuarantorsByShow_ID(show_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;
}