public DataTable PostOwnerMaintanance([FromBody] ClubOwner_maintanance m)
{
System.Diagnostics.Debug.WriteLine("Inside maintanance_Post********************************** ");
DataTable result = handler.clubOwner_maintanance(m);
return(result);
}
public DataTable clubOwner_maintanance(ClubOwner_maintanance c)
{
string query = "INSERT INTO Maintanance (clubid,pitch#,startTime,endTime,cost,description) " +
" VALUES (" + c.clubid + "," + c.pitch_no + ",'" + c.maintanance_start_date.ToString("yyyy-MM-dd hh:mm:00.000")
+ "','" + c.maintanance_end_date.ToString("yyyy-MM-dd hh:mm:00.000") + "'," + c.cost + ",'" + c.description + "')";
if (dbMan.ExecuteNonQuery(query) != 0)
{
query = "SELECT * FROM Maintanance WHERE clubId=" + c.clubid + " AND Pitch#=" + c.pitch_no + ";";
profitexist(c.maintanance_start_date.ToString("yyyy-MM-dd "), c.clubid);
Addoutcome(c.maintanance_start_date.ToString("yyyy-MM-dd "), c.clubid, (int)c.cost);
return(dbMan.ExecuteReader(query));
}
else
{
return(null);
}
}
