public bool UpdateVaccinationDeatils(IEnumerable <VaccinationUpdateRequest> vaccList) { var success = false; foreach (var vaccData in vaccList) { var query = string.Format("SELECT SchId FROM VaccinationDetails WHERE InfantId={0} AND SchId={1}", vaccData.InfantId, vaccData.ScheduleId); var existingSchId = Convert.ToInt32(dbService.ExecuteScalar(query)); if (existingSchId != 0) { query = string.Format("UPDATE VaccinationDetails SET VaccinatedDate='{0}',Comments ={3} WHERE InfantId={1} AND SchId={2}", vaccData.VaccinatedDate, vaccData.InfantId, vaccData.ScheduleId, vaccData.Comments); dbService.ExecuteScalar(query); success = true; } else { query = string.Format( @"SELECT TOP(1) DATEADD(WEEK, imm.StartOn, inf.DOB) AS NextVaccinationDate FROM InfantDetails inf CROSS APPLY ImmunizationSchedule imm WHERE DATEADD(WEEK, imm.StartOn, inf.DOB) >= GETDATE() AND InfantID = {0} ORDER BY DATEADD(WEEK, imm.StartOn, inf.DOB)", vaccData.InfantId); var nextVaccinationDate = Convert.ToDateTime(dbService.ExecuteScalar(query)); query = string.Format(@"INSERT INTO VaccinationDetails(SchId,InfantID,VaccinatedDate,NextVaccinationDate,Comments) output inserted.VaccinationId VALUES ({0}, {1}, '{2}', '{3}', '{4}')", vaccData.ScheduleId, vaccData.InfantId, vaccData.VaccinatedDate, nextVaccinationDate, vaccData.Comments); var vaccinationId = Convert.ToInt32(dbService.ExecuteScalar(query)); success = true; } } return(success); }
public FilterResponse GetFilteredGraphData(FilterCriteriaRequest filterCriteria) { var vaccinationToQuery = string.Empty; var districtToQuery = string.Empty; if (filterCriteria.VaccineIdList.Count > 0) { vaccinationToQuery = "SchId in (" + string.Join(",", filterCriteria.VaccineIdList) + ")"; } if (filterCriteria.DistrictIdList.Count > 0) { districtToQuery = "DistrictId in (" + string.Join(",", filterCriteria.DistrictIdList) + ")"; } FilterResponse filterres = new FilterResponse(); if (filterCriteria.StatusList.Count > 0) { foreach (int status in filterCriteria.StatusList) { if (status == 0)//Done { var query = string.Format(@"SELECT Count(*) FROM ListOfSuccessfullVacc WHERE VaccinatedDate>='{0}' AND VaccinatedDate<='{1}' AND {2} AND {3}", filterCriteria.FromYear, filterCriteria.ToYear, districtToQuery, vaccinationToQuery); filterres.DoneCount = Convert.ToInt32(dbService.ExecuteScalar(query)); } else if (status == 1)//Due { var query = string.Format(@"SELECT Count(*) FROM ListOfVaccinationDue WHERE VAccStartOn>='{0}' AND VAccStartOn<='{1}'AND {2} AND {3} ", filterCriteria.FromYear, filterCriteria.ToYear, districtToQuery, vaccinationToQuery); filterres.DueCount = Convert.ToInt32(dbService.ExecuteScalar(query)); } else if (status == 2)//OverDue/Missed { var query = string.Format(@"SELECT Count(*) FROM ListOfVaccinationOverDue WHERE VAccStartOn>='{0}' AND VAccStartOn<='{1}' AND {2} AND {3}", filterCriteria.FromYear, filterCriteria.ToYear, districtToQuery, vaccinationToQuery); filterres.MissedCount = Convert.ToInt32(dbService.ExecuteScalar(query)); } } } //int Totalstatuscount = filterres.DueCount + filterres.DoneCount + filterres.MissedCount; //filterres.DoneCount = (filterres.DoneCount / Totalstatuscount) * 100; //filterres.DueCount = (filterres.DueCount / Totalstatuscount) * 100; //filterres.MissedCount = (filterres.MissedCount / Totalstatuscount) * 100; return(filterres); }
public int RegisterUser(RegistrationRequest registerData) { var userId = 0; var query = string.Format("select userId from UserDetails where Mobile = '{1}' or UserName = '******'", registerData.Email, registerData.Mobile, registerData.UserName); var existingUserId = Convert.ToInt32(dbService.ExecuteScalar(query)); if (existingUserId > 0) { userId = -1; } else { query = string.Format(@"insert into UserDetails(FullName,Address,PINCode,Mobile,Email,UserName,Password,UserType, RegistrationID,RegisteredPHC,EmailNotification,SMSNotification) output inserted.UserID values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', {7}, '{8}', '{9}', {10}, {11})", registerData.FullName, registerData.Address, registerData.PinCode, registerData.Mobile, registerData.Email, registerData.UserName, registerData.Password, registerData.UserType, registerData.RegistrationId, registerData.RegisteredPHC, Convert.ToInt32(registerData.EmailNotification), Convert.ToInt32(registerData.SMSNotification)); userId = Convert.ToInt32(dbService.ExecuteScalar(query)); } return(userId); }