public static List<EquipmentDetails> GetSingleEquipmentDetails(string id) { string query = "select equipemntdescription.id,equipemntdescription.typeid,equipemntdescription.amount,equipemntdescription.description,equipmnttype.typename from equipemntdescription,equipmnttype where equipemntdescription.typeid=equipmnttype.id and equipemntdescription.id=" + id; DBGateway aGateway=new DBGateway(); List<EquipmentDetails> aList = new List<EquipmentDetails>(); DataSet aDataSet = aGateway.Select(query); foreach (DataRow dataRow in aDataSet.Tables[0].Rows) { EquipmentDetails aEquipmentDetails = new EquipmentDetails(); aEquipmentDetails.EquipmentId = dataRow["Id"].ToString(); aEquipmentDetails.TypeID = (int)dataRow["TypeID"]; aEquipmentDetails.Amount = (int)dataRow["Amount"]; aEquipmentDetails.Description = dataRow["Description"].ToString(); aEquipmentDetails.TypeName = dataRow["typename"].ToString(); aList.Add(aEquipmentDetails); } return aList; }
public static void UpdateEquipmentDetails(EquipmentDetails aEquipmentDetails) { string updateQuery; updateQuery = "UPDATE `signalappdb`.`equipemntdescription` SET `TypeId`=" + aEquipmentDetails.TypeID + ", `Amount`=" + aEquipmentDetails.Amount + ", `Description`='" + aEquipmentDetails.Description + "' WHERE `Id`=" + aEquipmentDetails.EquipmentId + ";"; DBGateway aGateway = new DBGateway(); string updateResult = aGateway.Update(updateQuery); }
public List<EquipmentDetails> GetEquipmentList(string equipmentType,string description) { DBGateway aGateway=new DBGateway(); string query = "select equipemntdescription.id,equipemntdescription.typeid,equipemntdescription.amount," + "equipemntdescription.description,equipmnttype.typename from equipemntdescription," + "equipmnttype where equipemntdescription.typeid=equipmnttype.id"; if (equipmentType.Trim().Length != 0) { query += " and equipmnttype.TypeName like '%"+equipmentType+"%' "; } if (description.Trim().Length != 0) { query += " and equipemntdescription.description like '%" + description + "%' "; } query += ";"; List<EquipmentDetails> aList = new List<EquipmentDetails>(); DataSet aDataSet = aGateway.Select(query); foreach (DataRow dataRow in aDataSet.Tables[0].Rows) { EquipmentDetails aEquipmentDetails = new EquipmentDetails(); aEquipmentDetails.EquipmentId = dataRow["Id"].ToString(); aEquipmentDetails.TypeID = (int)dataRow["TypeID"]; aEquipmentDetails.Amount = (int)dataRow["Amount"]; aEquipmentDetails.Description = dataRow["Description"].ToString(); aEquipmentDetails.TypeName = dataRow["typename"].ToString(); aList.Add(aEquipmentDetails); } return aList; }