public void Update(ArbitrationViewModel db)
        {
            var entity = new Arbitration_Table();

            entity.ArbitrationID       = db.ArbitrationID;
            entity.ArbitrationNumber   = db.ArbitrationNumber;
            entity.ArbitrationDate     = (DateTime)db.ArbitrationDate.Date;
            entity.FirstSideName       = db.FirstSideName;
            entity.FirstSideIDNumber   = db.FirstSideIDNumber;
            entity.FirstSidePhone      = db.FirstSidePhone;
            entity.FirstSocialstatus   = db.FirstSocialstatus;
            entity.FirstSideAddress    = db.FirstSideAddress;
            entity.SecondSideName      = db.SecondSideName;
            entity.SecondSideIDNumber  = db.SecondSideIDNumber;
            entity.SecondSidePhone     = db.SecondSidePhone;
            entity.SecondSocialstatus  = db.SecondSocialstatus;
            entity.SecondSideAddress   = db.SecondSideAddress;
            entity.ArbitrationName     = db.ArbitrationName;
            entity.ArbitrationPhone    = db.ArbitrationPhone;
            entity.ArbitrationDecision = HttpUtility.HtmlDecode(db.ArbitrationDecision);
            entity.UserID = db.UserID;


            entities.Arbitration_Table.Attach(entity);
            entities.Entry(entity).State = EntityState.Modified;
            entities.SaveChanges();
        }
        public void Create(ArbitrationViewModel db)
        {
            var entity = new Arbitration_Table();


            entity.ArbitrationDate  = (DateTime)db.ArbitrationDate.Date;
            entity.Beneficiaries_ID = db.Beneficiaries_ID;
            var q = entities.Beneficiaries_Table.Where(p => p.Beneficiaries_ID == db.Beneficiaries_ID).SingleOrDefault();

            db.BeneficiariesIDNumber = q.BeneficiariesIDNumber;
            db.BeneficiariesName     = q.BeneficiariesName;
            db.Gender                = q.Gender_Table.GenderName;
            entity.Area_ID           = db.Area_ID;
            entity.Governorate_ID    = db.Governorate_ID;
            entity.FirstSocialstatus = db.FirstSocialstatus;

            entity.SecondSideName      = db.SecondSideName;
            entity.SecondSideIDNumber  = db.SecondSideIDNumber;
            entity.SecondSidePhone     = db.SecondSidePhone;
            entity.SecondSocialstatus  = db.SecondSocialstatus;
            entity.SecondSideAddress   = db.SecondSideAddress;
            entity.ArbitrationName     = db.ArbitrationName;
            entity.ArbitrationPhone    = db.ArbitrationPhone;
            entity.ArbitrationDecision = HttpUtility.HtmlDecode(db.ArbitrationDecision);
            entity.UserID    = db.UserID;
            entity.ProjectID = db.ProjectID;
            entities.Arbitration_Table.Add(entity);
            entities.SaveChanges();

            db.ArbitrationID = entity.ArbitrationID;
        }
        public void Destroy(ArbitrationViewModel db)
        {
            var entity = new Arbitration_Table();

            entity.ArbitrationID = db.ArbitrationID;

            entities.Arbitration_Table.Attach(entity);

            entities.Arbitration_Table.Remove(entity);

            entities.SaveChanges();
        }