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;
}
