public Medicine( string name, Dictionary <string, Color> tags, MedicineGroup medicineInfos, MedicineScheduleInfo medicineScheduleInfo) { this.name = name; this.tags = tags; this.medicineOverAllInfo = medicineInfos; this.medicineScheduleInfo = medicineScheduleInfo; }
public Medicine( string name, string registeredBy, List <MedicineGroup> medicineLongInfos, MedicineScheduleInfo medicineScheduleInfo, ManufacturerInfo manufacturerInfo) { this.name = name; this.registeredBy = registeredBy; this.perBatchInfoList = medicineLongInfos; this.medicineScheduleInfo = medicineScheduleInfo; this.manufacturerInfo = manufacturerInfo; }
public MedicineScheduleInfo GetScheduleInfo() { MedicineScheduleInfo md = new MedicineScheduleInfo("", 0); string query = "select * from scheduletable where medicinename = @medname"; MySqlCommand cmd = new MySqlCommand(query, globalCon); cmd.Parameters.AddWithValue("@medname", medName); MySqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow); while (reader.Read()) { string medName = reader.GetString(0); DateTime scDate = reader.GetDateTime(1); int nofS = reader.GetInt16(2); md = new MedicineScheduleInfo(medName, nofS, scDate); } reader.Close(); return(md); }
public Medicine MedicineLongInfo() { string companyName = ""; string query = "select manfName,username from mednametable where medName=@mname"; MySqlCommand getDetailsCommand = new MySqlCommand(query, globalCon); getDetailsCommand.Parameters.AddWithValue("@mname", name); MySqlDataReader reader = getDetailsCommand.ExecuteReader(); while (reader.Read()) { registeredBy = reader.GetString(1); companyName = reader.GetString(0); } reader.Close(); //Get List of Manufacturer Infos. manufacturerInfo = ManufacturerInfo.GetShortInfoOf(companyName); //Get List of Batch Infos. perBatchInfoList = MedicineGroup.SeparatedBatchInfo(name); //Get Full Schedule Info. medicineScheduleInfo = new MedicineScheduleInfo(name).GetScheduleInfo(); //Return the Medicine. return(new Medicine(name, registeredBy, perBatchInfoList, medicineScheduleInfo, manufacturerInfo)); }