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;
}
