public static bool UpdateTBLMembers(object MemberId, object SyndicateId, object SubCommitteId, object MemberName, object Bdate, object GenderId, object MaritalStatusId, object IdTypeId,
object NID, object NIDEndDate, object Street, object HomeNo, object FlatNo, object Area, object City, object GovId, object Mobile, object HomeTel, object WorkTel,
object EMail, object KidNO, object ContactTypeID, object MemberImage, object ReceiptNo, object GehaId, object renew, object MemberSyndicateId)
{
bool ReturnMe = false;
dsETST ds = new dsETST();
dsETSTTableAdapters.TBLMembersTableAdapter adp = new dsETSTTableAdapters.TBLMembersTableAdapter();
adp.FillByMemberId(ds.TBLMembers, Convert.ToDecimal(MemberId));
dsETST.TBLMembersRow row = ds.TBLMembers[0];
if (!IsNullOrEmpty(SyndicateId))
row.SyndicateId = Convert.ToInt32(SyndicateId);
if (!IsNullOrEmpty(MemberSyndicateId))
row.MemberSyndicateId = Convert.ToInt32(MemberSyndicateId);
if (!IsNullOrEmpty(SubCommitteId))
row.SubCommitteId = Convert.ToInt32(SubCommitteId);
row.MemberName = MemberName.ToString();
if (!IsNullOrEmpty(Bdate))
row.Bdate = Convert.ToDateTime(Bdate);
if (!IsNullOrEmpty(GenderId))
row.GenderId = Convert.ToByte(GenderId);
if (!IsNullOrEmpty(MaritalStatusId))
row.MaritalStatusId = Convert.ToByte(MaritalStatusId);
if (!IsNullOrEmpty(IdTypeId))
row.IdTypeId = Convert.ToByte(IdTypeId);
if (!IsNullOrEmpty(NID))
row.NID = NID.ToString();
if (!IsNullOrEmpty(NIDEndDate))
row.NIDEndDate = Convert.ToDateTime(NIDEndDate);
if (!IsNullOrEmpty(Street))
row.Street = Street.ToString();
if (!IsNullOrEmpty(HomeNo))
row.HomeNo = HomeNo.ToString();
if (!IsNullOrEmpty(FlatNo))
row.FlatNo = FlatNo.ToString();
if (!IsNullOrEmpty(Area))
row.Area = Area.ToString();
if (!IsNullOrEmpty(FlatNo))
row.City = City.ToString();
if (!IsNullOrEmpty(GovId))
row.GovId = Convert.ToByte(GovId);
if (!IsNullOrEmpty(Mobile))
row.Mobile = Mobile.ToString();
if (!IsNullOrEmpty(HomeTel))
row.HomeTel = HomeTel.ToString();
if (!IsNullOrEmpty(WorkTel))
row.WorkTel = WorkTel.ToString();
if (!IsNullOrEmpty(EMail))
row.EMail = EMail.ToString();
if (!IsNullOrEmpty(KidNO))
row.KidNO = Convert.ToInt32(KidNO);
if (!IsNullOrEmpty(ContactTypeID))
row.ContactTypeID = Convert.ToByte(ContactTypeID);
if (!IsNullOrEmpty(MemberImage))
row.MemberImage = MemberImage.ToString();
if (!IsNullOrEmpty(ReceiptNo))
row.ReceiptNo = Convert.ToInt32(ReceiptNo);
if (!IsNullOrEmpty(GehaId))
row.GehaId = Convert.ToInt32(GehaId);
if (!IsNullOrEmpty(renew))
row.renew = Convert.ToBoolean(renew);
try
{
row.EndEdit();
adp.Update(ds.TBLMembers);
ReturnMe = true;
}
catch (SqlException ex)
{
throw ex;
}
return ReturnMe;
}
public static object InsertTBLMembers(object SyndicateId, object SubCommitteId, object MemberName, object Bdate, object GenderId, object MaritalStatusId, object IdTypeId,
object NID, object NIDEndDate, object Street, object HomeNo, object FlatNo, object Area, object City, object GovId, object Mobile, object HomeTel, object WorkTel,
object EMail, object KidNO, object ContactTypeID, object MemberImage, object ReceiptNo, object GehaId, object renew, object MemberSyndicateId)
{
object ReturnMe = MC.GetNewID("TBLMembers", "MemberId");
dsETST ds = new dsETST();
dsETSTTableAdapters.TBLMembersTableAdapter adp = new dsETSTTableAdapters.TBLMembersTableAdapter();
dsETST.TBLMembersRow row = ds.TBLMembers.NewTBLMembersRow();
row.MemberId = Convert.ToDecimal(ReturnMe);
if (!IsNullOrEmpty(SyndicateId))
row.SyndicateId = Convert.ToInt32(SyndicateId);
if (!IsNullOrEmpty(MemberSyndicateId))
row.MemberSyndicateId = Convert.ToInt32(MemberSyndicateId);
if (!IsNullOrEmpty(SubCommitteId))
row.SubCommitteId = Convert.ToInt32(SubCommitteId);
row.MemberName = MemberName.ToString();
if (!IsNullOrEmpty(Bdate))
row.Bdate = Convert.ToDateTime(Bdate);
if (!IsNullOrEmpty(GenderId))
row.GenderId = Convert.ToByte(GenderId);
if (!IsNullOrEmpty(MaritalStatusId))
row.MaritalStatusId = Convert.ToByte(MaritalStatusId);
if (!IsNullOrEmpty(IdTypeId))
row.IdTypeId = Convert.ToByte(IdTypeId);
if (!IsNullOrEmpty(NID))
row.NID = NID.ToString();
if (!IsNullOrEmpty(NIDEndDate))
row.NIDEndDate = Convert.ToDateTime(NIDEndDate);
if (!IsNullOrEmpty(Street))
row.Street = Street.ToString();
if (!IsNullOrEmpty(HomeNo))
row.HomeNo = HomeNo.ToString();
if (!IsNullOrEmpty(FlatNo))
row.FlatNo = FlatNo.ToString();
if (!IsNullOrEmpty(Area))
row.Area = Area.ToString();
if (!IsNullOrEmpty(City))
row.City = City.ToString();
if (!IsNullOrEmpty(GovId))
row.GovId = Convert.ToByte(GovId);
if (!IsNullOrEmpty(Mobile))
row.Mobile = Mobile.ToString();
if (!IsNullOrEmpty(HomeTel))
row.HomeTel = HomeTel.ToString();
if (!IsNullOrEmpty(WorkTel))
row.WorkTel = WorkTel.ToString();
if (!IsNullOrEmpty(WorkTel))
row.WorkTel = WorkTel.ToString();
if (!IsNullOrEmpty(KidNO))
row.KidNO = Convert.ToInt32(KidNO);
if (!IsNullOrEmpty(ContactTypeID))
row.ContactTypeID = Convert.ToByte(ContactTypeID);
if (!IsNullOrEmpty(MemberImage))
row.MemberImage = MemberImage.ToString();
if (!IsNullOrEmpty(ReceiptNo))
{
row.ReceiptNo = Convert.ToInt32(ReceiptNo);
}
if (!IsNullOrEmpty(renew))
row.renew = Convert.ToBoolean(renew);
row.userin = Convert.ToInt32(TheSessions.UserID);
row.datein = DateTime.UtcNow.AddHours(2);
if (!IsNullOrEmpty(GehaId))
row.GehaId = Convert.ToByte(GehaId);
try
{
ds.TBLMembers.AddTBLMembersRow(row);
row.EndEdit();
adp.Update(ds.TBLMembers);
}
catch (SqlException ex)
{
throw ex;
}
return ReturnMe;
}
