Example #1
0
        public bool AdminTestInsert(AdminSampleModel model)
        {
            TblAdminSample obj = new TblAdminSample();

            obj.Frequncy        = model.Frequncy;
            obj.Remarks         = model.Remarks;
            obj.SampleLocation1 = model.SampleLocation1;
            obj.SampleLocation2 = model.SampleLocation2;
            obj.SampleLocation3 = model.SampleLocation3;
            obj.SampleLocation4 = model.SampleLocation4;
            obj.SampleName      = model.SampleName;
            obj.SampleType      = model.SampleType;
            obj.SelectFrequncy  = model.SelectFrequncy;
            obj.CreatedBy       = model.CreatedBy;
            obj.CreatedDate     = DateTime.Now.ToString();
            obj.LogedInUser     = model.LogedInUser;
            obj.ModifiedBy      = model.ModifiedBy;
            obj.ModifiedDate    = DateTime.Now.ToString();

            dbcontext.TblAdminSamples.Add(obj);
            dbcontext.SaveChanges();
            int         id          = obj.Id;
            TblSchedule objschedule = new TblSchedule();

            objschedule.SampleId        = id;
            objschedule.FrequencyDays   = null;
            objschedule.FrequencyNumber = null;
            //objschedule.SampleId = model.Id;
            objschedule.SampleLocation = model.SampleLocation4;
            objschedule.SampleType     = model.SampleType;
            objschedule.ScheduleDate   = DateTime.Now.ToString();
            objschedule.SampleName     = model.SampleName;
            objschedule.CreatedBy      = model.CreatedBy;
            objschedule.createdDate    = DateTime.Now.ToString();
            objschedule.SampleName     = model.SampleName;
            objschedule.ModifiedBy     = model.ModifiedBy;
            objschedule.ModifiedDate   = DateTime.Now.ToString();
            dbcontext.TblSchedules.Add(objschedule);
            dbcontext.SaveChanges();
            return(true);
        }
Example #2
0
        public bool AdminTestUpdate(int Id, AdminSampleModel model)
        {
            var data = (from p in dbcontext.TblAdminSamples.Where(x => x.Id == Id) select p).FirstOrDefault();

            data.Frequncy        = model.Frequncy;
            data.Remarks         = model.Remarks;
            data.SampleLocation1 = model.SampleLocation1;
            data.SampleLocation2 = model.SampleLocation2;
            data.SampleLocation3 = model.SampleLocation3;
            data.SampleLocation4 = model.SampleLocation4;
            data.SampleName      = model.SampleName;
            data.SampleType      = model.SampleType;
            data.SelectFrequncy  = model.SelectFrequncy;
            //data.CreatedBy = model.CreatedBy;
            // data.CreatedDate = model.CreatedDate;
            data.LogedInUser  = model.LogedInUser;
            data.ModifiedBy   = model.ModifiedBy;
            data.ModifiedDate = DateTime.Now.ToString();

            var objschedule = (from p in dbcontext.TblSchedules.Where(x => x.SampleId == Id) select p).FirstOrDefault();


            objschedule.SampleLocation = model.SampleLocation4;
            objschedule.SampleType     = model.SampleType;
            objschedule.SampleName     = model.SampleName;

            // objschedule.ScheduleDate = DateTime.Now.ToString();
            objschedule.SampleName  = model.SampleName;
            objschedule.CreatedBy   = model.CreatedBy;
            objschedule.createdDate = DateTime.Now.ToString();

            objschedule.ModifiedBy   = model.ModifiedBy;
            objschedule.ModifiedDate = DateTime.Now.ToString();


            dbcontext.SaveChanges();
            return(true);
        }
 public bool AdminSampleInsert(AdminSampleModel model)
 {
     return(repo.AdminTestInsert(model));
 }
 public bool AdminSampleUpdate(int Id, AdminSampleModel model)
 {
     return(repo.AdminTestUpdate(Id, model));
 }
        public IHttpActionResult Post([FromBody] AdminSampleModel model)
        {
            var data = service.AdminSampleInsert(model);

            return(Ok(data));
        }
        public IHttpActionResult Put([FromBody] AdminSampleModel model)
        {
            var data = service.AdminSampleUpdate(model.Id, model);

            return(Ok(data));
        }