/// <summary>
/// taburcu kayıtları
/// </summary>
/// <returns></returns>
public GenericResponse <List <Discharged> > SelectDischarged()
{
var returnObject = new GenericResponse <List <Discharged> >();
ConnectDB();
var sqlCommand = new SqlCommand();
sqlCommand.CommandText = Common.CreateProcedureText(Common.patientTable, null, null);
sqlCommand.Connection = conSOHATS;
var dr = sqlCommand.ExecuteReader();
var data = new List <Discharged>();
var patient = new Discharged();
while (dr.Read())
{
patient = new Discharged
{
DosyaNo = SQLDBHelper.GetIntValue(dr["dosyano"]),
SevkTarihi = SQLDBHelper.GetDateTimeValue(dr["sevktarihi"]),
CikisTarihi = SQLDBHelper.GetDateTimeValue(dr["cikistarihi"]),
Odeme = SQLDBHelper.GetStringValue(dr["odeme"]),
ToplamTutar = SQLDBHelper.GetIntValue(dr["toplamtutar"])
};
data.Add(patient);
}
endConnectDB();
returnObject.Value = data;
returnObject.Success = true;
return(returnObject);
}
/// <summary>
/// cıkıs tablosuna kayıt yapar
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public GenericResponse <bool> InsertDischarged(Discharged data)
{
var returnObject = new GenericResponse <Boolean>();
ConnectDB();
var cmd = new SqlCommand(Common.cikisKaydet, conSOHATS);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DosyaNo", data.DosyaNo);
cmd.Parameters.AddWithValue("@SevkTarihi", data.SevkTarihi);
cmd.Parameters.AddWithValue("@CikisTarihi", data.CikisTarihi);
cmd.Parameters.AddWithValue("@Odeme", data.Odeme);
cmd.Parameters.AddWithValue("@ToplamTutar", data.ToplamTutar);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Common.WriteLog("error", e.Message);
returnObject.Success = false;
returnObject.ErrorMessage = e.Message;
throw;
}
returnObject.Success = true;
endConnectDB();
return(returnObject);
}
