protected void btnEdit_Click(object sender, EventArgs e)
{
lblSate.Text = string.Empty;
if (MC.IsNullOrEmpty(cb.Value) || MC.IsNullOrEmpty(cbCompanion.Value))
{
return;
}
if (Session["CompanionImage3"] == null || MC.IsNullOrEmpty(cbNew.Value))
{
lblSate.Text = "من فضلك اختر صورة واختر عضو الذي سيتم له الاضافة";
return;
}
dsETST ds = new dsETST();
dsETSTTableAdapters.OldTBLCompanionTableAdapter adpOld = new dsETSTTableAdapters.OldTBLCompanionTableAdapter();
dsETSTTableAdapters.TBLCompanionTableAdapter adpNew = new dsETSTTableAdapters.TBLCompanionTableAdapter();
dsETST.OldTBLCompanionRow Old = (dsETST.OldTBLCompanionRow)adpOld.GetDataByCompanionId(Convert.ToDecimal(cbCompanion.Value)).Rows[0];
dsETST.TBLCompanionRow New = ds.TBLCompanion.NewTBLCompanionRow();
New.MemberId = Convert.ToDecimal(cbNew.Value);
New.CompanionId = Convert.ToDecimal(MC.GetNewID("TBLCompanion", "CompanionId"));
if (!Old.IsCompanionTypeIdNull())
{
New.CompanionTypeId = Old.CompanionTypeId;
}
if (!Old.IsCompanionNameNull())
{
New.CompanionName = Old.CompanionName;
}
if (!Old.IsGenderIdNull())
{
New.GenderId = Old.GenderId;
}
if (!Old.IsCompanionBdateNull())
{
New.CompanionBdate = Old.CompanionBdate;
}
New.CompanionImage = Session["CompanionImage3"].ToString();
New.renew = true;
Session.Remove("CompanionImage3");
New.userin = Convert.ToInt32(TheSessions.UserID);
New.datein = DateTime.Now;
ds.TBLCompanion.AddTBLCompanionRow(New);
New.EndEdit();
adpNew.Update(ds.TBLCompanion);
ASPxPopupControlEditor.JSProperties["cpShowPopup"] = "تم الاضافه";
}
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;
}
