public int RemoveFAdetail(int FAid)
        {
            try
            {
                IFAtargetOperations           targetOperation     = new FAtargetOperations();
                IFAeducationDetailOperations  educationOperation  = new FAeducationDetailOperations();
                IFAexperianceDetailOperations experienceOperation = new FAexperianceDetailOperations();
                IFAapprovalOperations         approvalOperation   = new FAapprovalOperations();
                IFAaddressDetailOperations    addressOperation    = new FAaddressDetailOperations();

                FAdetail faDetail = db.FAdetails.Select(x => x).Where(x => x.Id == FAid).FirstOrDefault();
                if (faDetail != null)
                {
                    int Faid = faDetail.Id;
                    //targetOperation.RemoveTargetsForFA(Faid);
                    //educationOperation.RemoveEducationDetailForFA(Faid);
                    //experienceOperation.RemoveExperienceDetailForFA(Faid);
                    //approvalOperation.RemoveApprovalDetailForFA(Faid);
                    //addressOperation.RemoveFAaddressDetail(Faid);
                    //db.FAdetails.Remove(faDetail);
                    faDetail.Status = 3;
                }
                return(db.SaveChanges());
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public int UpdateFAdetail(FAdetail faDetail)
        {
            try
            {
                IFAtargetOperations           targetOperation     = new FAtargetOperations();
                IFAeducationDetailOperations  educationOperation  = new FAeducationDetailOperations();
                IFAexperianceDetailOperations experienceOperation = new FAexperianceDetailOperations();
                IFAapprovalOperations         approvalOperation   = new FAapprovalOperations();
                IFAaddressDetailOperations    addressOperation    = new FAaddressDetailOperations();

                FAdetail faDetailToUpdate = db.FAdetails.Select(x => x).Where(x => x.Id == faDetail.Id).FirstOrDefault();

                if (faDetailToUpdate != null)
                {
                    faDetailToUpdate.BirthDate       = faDetail.BirthDate;
                    faDetailToUpdate.FAdesignationId = faDetail.FAdesignationId;
                    faDetailToUpdate.FAname          = faDetail.FAname;
                    faDetailToUpdate.FAStatu         = faDetail.FAStatu;
                    faDetailToUpdate.FirstName       = faDetail.FirstName;
                    faDetailToUpdate.IsExperienced   = faDetail.IsExperienced;
                    faDetailToUpdate.LastName        = faDetail.LastName;
                    faDetailToUpdate.MiddleName      = faDetail.MiddleName;
                    faDetailToUpdate.Status          = faDetail.Status;
                    faDetailToUpdate.UpdatedBy       = faDetail.UpdatedBy;
                    faDetailToUpdate.LastUpdated     = faDetail.LastUpdated;
                }

                targetOperation.UpdateTargetForFA(faDetail.FAtargetDetails.ToList());
                educationOperation.UpdateEducationDetailForFA(faDetail.FAeducationDetails.ToList());
                experienceOperation.UpdateExperienceDetailForFA(faDetail.FAexperianceDetails.ToList());
                approvalOperation.UpdateApprovalForFA(faDetail.FAapprovals.ToList());
                addressOperation.UpdateFAaddressDetail(faDetail.FAaddressDetails.ToList());


                return(db.SaveChanges());
            }
            catch (Exception ex)
            {
                throw;
            }
        }