public ActionResult Updete1(Diagnozes d)
{
string id = Session["Patiant"].ToString();
BLDiagnozes bld = new BLDiagnozes();
int result = bld.UpdateDiagnoze(d, id);
return(RedirectToAction("PastMedical"));
}
public ActionResult updateDiagnoze(Diagnozes d)
{
try
{
BL_AddDiagnozeAndHospitalization b = new BL_AddDiagnozeAndHospitalization();
int result = b.Update_Diagnoze(d.Diagnoze, d.Status, d.BeginDate, d.EndDate);
return(RedirectToAction("PastMedical", "PastMedical"));
}
catch (Exception)
{
throw;
}
}
public ActionResult Diagnoze(Diagnozes d)
{
try
{
BL_AddDiagnozeAndHospitalization b = new BL_AddDiagnozeAndHospitalization();
d.By = Convert.ToInt32(Session["auth"]);
BLPatiants p = new BLPatiants();
d.PatiantCode = p.getPatiantsById(Convert.ToString(Session["IdPatiants"])).Code;
int result = b.Add_Diagnoze(d.Diagnoze, d.Status, d.BeginDate, d.EndDate);
return(RedirectToAction("PastMedical", "PastMedical"));
//Add_Diagnoze להוסיף אבחון למסד נתונים
}
catch (Exception)
{
return(RedirectToAction("PastMedical", "PastMedical"));
}
}
//public int DeleteDiagnoze(int Code)
//{
// DADiagnoze DAD = new DADiagnoze();
// ListDictionary Params = new ListDictionary();
// Params.Add("@Code", Code);
// int result = DAD.DeleteDiagnoze(Params);
// return result;
//}
public int UpdateDiagnoze(Diagnozes d, string id)
{
DADiagnoze DAD = new DADiagnoze();
ListDictionary Params = new ListDictionary();
Params.Add("@BeginDate", d.BeginDate);
Params.Add("@By", d.By);
Params.Add("@Code", d.Code);
Params.Add("@Diagnoze", d.Diagnoze);
Params.Add("@EndDate", d.EndDate);
Params.Add("@PatiantCode", d.PatiantCode);
Params.Add("@Status", d.Status);
int result = DAD.UpdateDiagnoze(Params);
//List<Diagnozes> all= GetAllDiagnoze(id);
//string S;
//List<string> MyNameWorker = new List<string>();
//S = BLCtrl.getString(ds.Tables[0].Rows[0], "FullName", "");
//MyNameWorker.Add(S);
return(result);
}
public List <Diagnozes> GetAllDiagnoze(string Id)
{
DADiagnoze DAD = new DADiagnoze();
ListDictionary Params = new ListDictionary();
Params.Add("@MyId", Id);
DataSet ds = DAD.GetAllDiagnoze(Params);
Diagnozes D = new Diagnozes();
List <Diagnozes> MyD = new List <Diagnozes>();
foreach (DataRow item in ds.Tables[0].Rows)
{
D.Code = BLCtrl.getInt(item, "Code", 0);
D.Diagnoze = BLCtrl.getInt(item, "Diagnoze", 1);
D.Status = BLCtrl.getInt(item, "Status", 1);
D.BeginDate = BLCtrl.getDateTime(item, "BeginDate", new DateTime(2018 - 1 - 1));
D.EndDate = BLCtrl.getDateTime(item, "EndDate", new DateTime(2018 - 1 - 1));
D.By = BLCtrl.getInt(item, "By", 0);
D.PatiantCode = BLCtrl.getInt(item, "PatiantCode", 0);
MyD.Add(D);
}
return(MyD);
}
