public List <Updatings> getUpdateDateAndcode(string id) { DAgetUpdateDateAndCode da = new DAgetUpdateDateAndCode(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); DataSet ds = da.getUpdateDateAndCode(Params); List <Updatings> l = new List <Updatings>(); Updatings f; foreach (DataRow item in ds.Tables[0].Rows) { f = new Updatings(); f.UpdateDate = BLCtrl.getDateTime(item, "UpdateDate", new DateTime()); f.Code = BLCtrl.getInt(item, "Code", 0); l.Add(f); } return(l); }
public Patiants getPatiantsById(string id) { DAPatiants da = new DAPatiants(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); DataSet ds = da.getPatiantsById(Params); Patiants p = new Patiants(); p.A = BLCtrl.getInt(ds.Tables[0].Rows[0], "A", 0); p.BirthDate = BLCtrl.getDateTime(ds.Tables[0].Rows[0], "BirthDate", DateTime.Today); p.Children = BLCtrl.getInt(ds.Tables[0].Rows[0], "Children", 0); p.City = BLCtrl.getString(ds.Tables[0].Rows[0], "City", ""); p.Code = BLCtrl.getInt(ds.Tables[0].Rows[0], "Code", 0); p.ContactExam = BLCtrl.getString(ds.Tables[0].Rows[0], "ContactExam", ""); p.ContactGinformation = BLCtrl.getString(ds.Tables[0].Rows[0], "ContactGinformation", ""); p.Doctor = BLCtrl.getString(ds.Tables[0].Rows[0], "Doctor", ""); p.Email = BLCtrl.getString(ds.Tables[0].Rows[0], "Email", ""); p.FathersOrigin = BLCtrl.getString(ds.Tables[0].Rows[0], "FathersOrigin", ""); p.Fax = BLCtrl.getString(ds.Tables[0].Rows[0], "Fax", ""); p.FirstName = BLCtrl.getString(ds.Tables[0].Rows[0], "FirstName", ""); p.followedup = BLCtrl.getBool(ds.Tables[0].Rows[0], "followedup", false); p.FollowUp = BLCtrl.getBool(ds.Tables[0].Rows[0], "FollowUp", false); p.G = BLCtrl.getInt(ds.Tables[0].Rows[0], "G", 0); p.Id = BLCtrl.getString(ds.Tables[0].Rows[0], "Id", ""); p.Kupah = BLCtrl.getInt(ds.Tables[0].Rows[0], "Kupah", 0); p.L = BLCtrl.getInt(ds.Tables[0].Rows[0], "L", 0); p.Language = BLCtrl.getString(ds.Tables[0].Rows[0], "Language", ""); p.LastName = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName", ""); p.MaritalStatus = BLCtrl.getInt(ds.Tables[0].Rows[0], "MaritalStatus", 0); p.MothersOrigin = BLCtrl.getString(ds.Tables[0].Rows[0], "MothersOrigin", ""); p.Occupation = BLCtrl.getString(ds.Tables[0].Rows[0], "Occupation", ""); p.P = BLCtrl.getInt(ds.Tables[0].Rows[0], "P", 0); p.Phone = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone", ""); p.Phone2 = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone2", ""); p.reffered = BLCtrl.getString(ds.Tables[0].Rows[0], "reffered", ""); p.Street = BLCtrl.getString(ds.Tables[0].Rows[0], "Street", ""); p.T = BLCtrl.getInt(ds.Tables[0].Rows[0], "T", 0); return(p); }