public void UpdateCollege(UpdateCollegeViewModel model)
        {
            try
            {
                if (model != null && model.CollegeRowID > 0)
                {
                    MasterCollege entity = new MasterCollege();
                    entity.CollegeRowID       = model.CollegeRowID;
                    entity.UniversityRowID    = model.UniversityRowID;
                    entity.CollegeName        = model.CollegeName;
                    entity.CountryRowID       = model.CountryRowID;
                    entity.StateRowID         = model.StateRowID;
                    entity.DistrictRowID      = model.DistrictRowID;
                    entity.AdditionalComments = model.AdditionalComments;
                    entity.AdditionalCost     = model.AdditionalCost;
                    entity.AdditionalCosting  = model.AdditionalCosting;
                    entity.AffiliatedFrom     = model.AffliatiatedFrom;
                    entity.ConcernPersonName  = model.ConcernPersonName;
                    //entity.DDFavourOf = model.DDFavourOf;
                    entity.DegreeCertificate   = Convert.ToByte(model.DegreeCertificate);
                    entity.DesigConcernPerson  = model.DesigConcernPerson;
                    entity.FinalYearMarksSheet = Convert.ToByte(model.FinalYearMarksSheet);
                    entity.LocationRowID       = model.LocationRowID;
                    //entity.CityRowID = model.CityRowID;
                    entity.ProvisionalCertificate = Convert.ToByte(model.ProvisionalCertificate);
                    //entity.VerificationProcessTAT = model.VerificationProcessTAT;
                    entity.Website            = model.Website;
                    entity.CollegeStatus      = model.CollegeStatus;
                    entity.CollegeAddress     = model.CollegeAddress;
                    entity.SpecialInstruction = model.SpecialInstruction;
                    entity.PassingCertificate = Convert.ToByte(model.PassingCertificate);
                    entity.ModeOfInitiation   = model.ModeOfInitiation;
                    entity.ModeOfPayment      = model.ModeOfPayment;
                    entity.OfficialEmailId    = model.OfficialEmailId;
                    entity.OfficialLandlineNo = model.OfficialLandlineNo;
                    entity.MobileNo           = model.MobileNo;
                    entity.OtherDocument      = Convert.ToByte(model.OtherDocument);
                    entity.Other1             = model.Other1;
                    entity.Other2             = model.Other2;
                    entity.Other3             = model.Other3;
                    entity.Other4             = model.Other4;
                    entity.Other5             = model.Other5;
                    //entity.Status = model.Status;
                    entity.FavourOf            = model.FavourOf;
                    entity.ResultLink          = model.ResultLink;
                    entity.OtherDocumentDetail = model.OtherDocumentDetail;
                    //entity.OtherAffliatiated = model.OtherAffliatiated;
                    entity.OtherInitiation       = model.OtherInitiation;
                    entity.OtherStatus           = model.OtherStatus;
                    entity.PayableAT             = model.PayableAT;
                    entity.AccountNumber         = model.AccountNumber;
                    entity.IFSCCode              = model.IFSCCode;
                    entity.Snapshot              = model.Snapshot;
                    entity.VerificationTATLevel1 = model.VerificationTATLevel1;
                    entity.VerificationTATLevel2 = model.VerificationTATLevel2;
                    entity.ModifiedDate          = model.ModifiedDate;

                    db.Entry(entity).State = EntityState.Modified;
                }
                else
                {
                    throw new Exception("College could not be blank!");
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        public UpdateCollegeViewModel GetCollegeForUpdateById(short CollegeRowID)
        {
            try
            {
                UpdateCollegeViewModel model = new UpdateCollegeViewModel();
                var entity = db.MasterColleges.Find(CollegeRowID);

                if (entity != null)
                {
                    model.CollegeRowID       = entity.CollegeRowID;
                    model.UniversityRowID    = entity.UniversityRowID;
                    model.CollegeName        = entity.CollegeName;
                    model.CountryRowID       = entity.CountryRowID;
                    model.StateRowID         = entity.StateRowID;
                    model.DistrictRowID      = entity.DistrictRowID;
                    model.AdditionalComments = entity.AdditionalComments;
                    model.AdditionalCost     = entity.AdditionalCost;
                    model.AdditionalCosting  = entity.AdditionalCosting;
                    model.AffliatiatedFrom   = entity.AffiliatedFrom;
                    model.ConcernPersonName  = entity.ConcernPersonName;
                    //model.DDFavourOf = entity.DDFavourOf;
                    model.DegreeCertificate   = Convert.ToBoolean(entity.DegreeCertificate);
                    model.DesigConcernPerson  = entity.DesigConcernPerson;
                    model.FinalYearMarksSheet = Convert.ToBoolean(entity.FinalYearMarksSheet);
                    model.LocationRowID       = entity.LocationRowID;
                    //  model.CityRowID = entity.CityRowID;
                    model.ProvisionalCertificate = Convert.ToBoolean(entity.ProvisionalCertificate);
                    // model.VerificationProcessTAT = entity.VerificationProcessTAT;
                    model.Website             = entity.Website;
                    model.CollegeStatus       = entity.CollegeStatus;
                    model.CollegeAddress      = entity.CollegeAddress;
                    model.SpecialInstruction  = entity.SpecialInstruction;
                    model.PassingCertificate  = Convert.ToBoolean(entity.PassingCertificate);
                    model.ModeOfInitiation    = entity.ModeOfInitiation;
                    model.ModeOfPayment       = entity.ModeOfPayment;
                    model.OfficialEmailId     = entity.OfficialEmailId;
                    model.OfficialLandlineNo  = entity.OfficialLandlineNo;
                    model.MobileNo            = entity.MobileNo;
                    model.OtherDocument       = Convert.ToBoolean(entity.OtherDocument);
                    model.Other1              = entity.Other1;
                    model.Other2              = entity.Other2;
                    model.Other3              = entity.Other3;
                    model.Other4              = entity.Other4;
                    model.Other5              = entity.Other5;
                    model.Status              = entity.Status;
                    model.FavourOf            = entity.FavourOf;
                    model.ResultLink          = entity.ResultLink;
                    model.OtherDocumentDetail = entity.OtherDocumentDetail;
                    // model.OtherAffliatiated = entity.OtherAffliatiated;
                    model.OtherInitiation       = entity.OtherInitiation;
                    model.OtherStatus           = entity.OtherStatus;
                    model.PayableAT             = entity.PayableAT;
                    model.AccountNumber         = entity.AccountNumber;
                    model.IFSCCode              = entity.IFSCCode;
                    model.Snapshot              = entity.Snapshot;
                    model.VerificationTATLevel1 = entity.VerificationTATLevel1;
                    model.VerificationTATLevel2 = entity.VerificationTATLevel2;
                }
                else
                {
                    throw new Exception("Invalid Id!");
                }

                return(model);
            }
            catch (Exception)
            {
                throw;
            }
        }