public static FirstCall GetByCase(int caseId) { FirstCall firstCall = null; SqlConnection con; using (SqlDataReader dr = DataManager.GetDataReader("ESystem_FirstCallGetByCase", out con, DataManager.CreateParameter("@caseId", SqlDbType.Int, caseId))) { if (dr.HasRows) { while (dr.Read()) { firstCall = FillDataRecord(dr); } } else { throw new Exception("No Data"); } con.Close(); } return(firstCall); }
private static FirstCall FillDataRecord(IDataRecord myDataRecord) { FirstCall firstCall = new FirstCall(); firstCall.FcallId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("FcallId")); firstCall.CaseId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("CaseId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("dateTime"))) { firstCall.dateTime = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("dateTime")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Report"))) { firstCall.Report = myDataRecord.GetString(myDataRecord.GetOrdinal("Report")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("TechnichalReport"))) { firstCall.TechnichalReport = myDataRecord.GetString(myDataRecord.GetOrdinal("TechnichalReport")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("VisitDate"))) { firstCall.VisitDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("VisitDate")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("VisitTime"))) { firstCall.VisitTime = myDataRecord.GetString(myDataRecord.GetOrdinal("VisitTime")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Status"))) { firstCall.Status = (FirstCallStatus)myDataRecord.GetInt32(myDataRecord.GetOrdinal("Status")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Notes"))) { firstCall.Notes = myDataRecord.GetString(myDataRecord.GetOrdinal("Notes")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("CreatedBy"))) { firstCall.CreatedBy = myDataRecord.GetString(myDataRecord.GetOrdinal("CreatedBy")); } return(firstCall); }
public static int UpdateByCase(FirstCall firstCall) { object o = DataManager.ExecuteScalar("ESystem_FirstCallUpdateByCase", DataManager.CreateParameter("@caseId", SqlDbType.Int, firstCall.CaseId), DataManager.CreateParameter("@dateTime", SqlDbType.NVarChar, firstCall.dateTime), DataManager.CreateParameter("@report", SqlDbType.NVarChar, firstCall.Report), DataManager.CreateParameter("@techReport", SqlDbType.NVarChar, firstCall.TechnichalReport), DataManager.CreateParameter("@visitDate", SqlDbType.DateTime, firstCall.VisitDate), DataManager.CreateParameter("@visitTime", SqlDbType.NVarChar, firstCall.VisitTime), DataManager.CreateParameter("@status", SqlDbType.Int, firstCall.Status), DataManager.CreateParameter("@notes", SqlDbType.NVarChar, firstCall.Notes)); return(Convert.ToInt32(o)); }
protected void btnSave_Click(object sender, EventArgs e) { if (rdStatusList.SelectedValue == "1") { FirstCall fCall = new FirstCall(); fCall.CaseId = id; fCall.dateTime = DateTime.Now; fCall.Report = txtCallReport.Text; fCall.TechnichalReport = txtTechnichalReport.Text; fCall.VisitDate = Convert.ToDateTime(txtVisitDate.Text); // Fix the bug am here fCall.VisitTime = txtTime.Text; fCall.Status = FirstCallStatus.available; fCall.Notes = txtNotes.Text; fCall.CreatedBy = userName; fCall.FcallId = FirstCallBLL.Insert(fCall); } else if (rdStatusList.SelectedValue == "2") { FirstCall fCall = new FirstCall(); fCall.CaseId = id; fCall.dateTime = DateTime.Now; fCall.Report = ""; fCall.TechnichalReport = ""; fCall.VisitDate = (DateTime)(NullDate); fCall.VisitTime = ""; fCall.Status = FirstCallStatus.onhold; fCall.Notes = ""; fCall.CreatedBy = userName; fCall.FcallId = FirstCallBLL.Insert(fCall); } else if (rdStatusList.SelectedValue == "3") { //TODO : deactivate the account } }
public static int UpdateByCase(FirstCall firstCall) { firstCall.CaseId = FirstCallDAL.UpdateByCase(firstCall); return(firstCall.CaseId); }
public static int Update(FirstCall firstCall) { firstCall.FcallId = FirstCallDAL.Update(firstCall); return(firstCall.FcallId); }
public static int Insert(FirstCall firstCall) { firstCall.FcallId = FirstCallDAL.Insert(firstCall); return(firstCall.FcallId); }
private void SaveButtonCommandExecute() { var firstCall = new FirstCall(); firstCall.DutyOperator = GeneralInfo.DutyOps; firstCall.DutyDoctorId = GeneralInfo.DutyDoctor.Id; firstCall.DocDateTime = GeneralInfo.DocDateTime.ToString(CultureInfo.CurrentCulture); firstCall.EventDateTime = GeneralInfo.EventDateTime.ToString(CultureInfo.CurrentCulture); firstCall.CalFirstName = Caller.FirstName; firstCall.CalLastName = Caller.LastName; firstCall.CalMiddleName = Caller.MiddleName; firstCall.CalLocationInfo = Caller.LocationInfo; firstCall.PlaceOfStay = Caller.PlaceOfStay; firstCall.CalRoom = Caller.Room; firstCall.CallerId = Caller.CallerId; firstCall.CalRelToSubId = Caller.RelToSub.Id; firstCall.CalCountryId = Caller.Country.Id; firstCall.CalRegionId = Caller.Region.Id; firstCall.CalCityId = Caller.City.Id; firstCall.InsuranceId = Membership.Insurance.Id; firstCall.PolicyNum = Membership.PolicyNum; firstCall.LetterCode = Membership.LetterCode; firstCall.InsuredDays = Membership.InsuredDays; firstCall.InsuredProgramm = Membership.InsuredProgramm; firstCall.Deductable = Membership.Deductable; firstCall.ValidFrom = Membership.ValidFrom.ToString(CultureInfo.CurrentCulture); firstCall.ValidTo = Membership.ValidTo.ToString(CultureInfo.CurrentCulture); firstCall.HomeAdress = Subscriber.HomeAdress; firstCall.SubFirstName = Subscriber.FirstName; firstCall.SubLastName = Subscriber.LastName; firstCall.SubMiddleName = Subscriber.MiddleName; firstCall.SubLocationInfo = Subscriber.LocationInfo; firstCall.SubRoom = Subscriber.Room; firstCall.Age = Subscriber.Age; firstCall.DoB = Subscriber.DoB.ToString(CultureInfo.CurrentCulture); firstCall.Arrival = Subscriber.Arrival.ToString(CultureInfo.CurrentCulture); firstCall.Departure = Subscriber.Departure.ToString(CultureInfo.CurrentCulture); firstCall.HotelId = Subscriber.Hotel.Id; firstCall.SubCountryId = Subscriber.Country.Id; firstCall.SubRegionId = Subscriber.Region.Id; firstCall.SubCityId = Subscriber.City.Id; firstCall.StatusOfCallId = CallInfo.StatusSelected.Id; firstCall.ReasonForCall = CallInfo.ReasonForCall; firstCall.IsChronical = CallInfo.IsChronical ? 1 : 0; firstCall.IsAlcohol = CallInfo.IsAlcohol ? 1 : 0; firstCall.DocLocationInfo = TreatDoctor.LocationInfo; firstCall.IsDoctor = TreatDoctor.IsDoctor ? 1 : 0; firstCall.IsFacility = TreatDoctor.IsFacility ? 1 : 0; firstCall.DocCountryId = TreatDoctor.Country.Id; firstCall.DocRegionId = TreatDoctor.Region.Id; firstCall.DocCityId = TreatDoctor.City.Id; firstCall.TreatingDoctorId = TreatDoctor.TreatingDoctorView.Id; DataBaseManager.AddFirstCall(firstCall); var lastFirstCall = DataBaseManager.SearchfFirstCall(firstCall); var listOfConacts = new List <Contact> (); foreach (var c in ContactSection.ContactViewInForm) { var contact = new Contact() { FirstCallId = lastFirstCall.Id, RelToSubId = c.SelectedRelToSub.Id, TypeOfContactId = c.SelectedContact.Id, Name = c.Name, ContactNum = c.ContactNum, Info = c.Info }; listOfConacts.Add(contact); } DataBaseManager.AddContacts(listOfConacts); SaveButttonEnabled = false; }