public async Task <bool> ModifyService_Call(IService_Call modifiedService_Call) { var param = new { modifiedService_Call.UID, modifiedService_Call.Caller_Info, modifiedService_Call.Call_Description, modifiedService_Call.Date_time, modifiedService_Call.UID_Customer }; return(await _dataBaseManager.Modify("SP_UPDATE_Service_Call", param)); }
public async Task <bool> Service_CallExists(IService_Call service_Call) { string query = @"SELECT * FROM Service_Calls WHERE CAST(Date_time AS DATE) LIKE @date AND ( Caller_Info LIKE @Caller_Info OR UID_Customer LIKE @UID_Customer) "; var param = new { service_Call.Caller_Info, date = service_Call.Date_time.ToShortDateString(), service_Call.UID_Customer }; return(await _dataBaseManager.Find <Service_Call>(query, param) != null); }
public async Task <bool> AddService_Call(IService_Call service_Call) { var param = new { service_Call.UID, service_Call.Caller_Info, service_Call.Call_Description, service_Call.Date_time, service_Call.UID_Customer }; return(await _dataBaseManager.Add("SP_ADD_Service_Call", param)); }